Exam 1z0-083 topic 1 question 129 discussion

A - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated B - TRUE. Only STATISTICS_LEVEL=BASIC stops them being generated C - FALSE. You can create them manually. D - FALSE. The DB will, by default, create them automatically every hour E - TRUE. You can setup AWR Warehouse, allowing these reports to be kept, and queried, forever. F - FALSE. STATISTICS_LEVEL=BASIC stops them being generated So, ABE is correct. Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/STATISTICS_LEVEL.html

I agree with xRodge

ABE - see xrodge

No doubts no comments. See xRodge's explanation.

ABE is correct

It's ABE.

ABE are correction options. Snapshots can be retained forever in warehouse environment so E is correct.

A, B, E E: https://docs.oracle.com/database/121/TDPPT/tdppt_auto.htm#TDPPT025 C,D - not always.. based on statistic_level F- only manual possible

A, B, E Not always manual , not always automatic. to retain forever (E): exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( retention=>0);

ABD (DBMS_WORKLOAD_REPOSITORY.create_snapshot)

ABE correct

I think ABC