A is wrong - they are never archived. C is wrong - 19c docs: Queries do not change data and thus do not contribute to logging activity for Flashback Database. D is wrong - according to documentation and my practice some ARCHIVE LOGs are required too.