Prev Question
Next Question

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

A.
Optimizer statistics are collected automatically.

B.
Only timed operating system (OS) statistics and plan execution statistics are collected.

C.
Automatic Workload Repository (AWR) snapshots are not generated automatically.

D.
The Oracle server dynamically generates the necessary object-level statistics on tables as part of query
optimization.

Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *