Which two statements are true about the statistics level parameter?

Your database instance is started using an SPFILE. You are connected to cdb$root, as a
DBA . You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?

Your database instance is started using an SPFILE. You are connected to cdb$root, as a
DBA . You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?

A.
It is set to all for all PDBs only in the SPFILE.

B.
It is immediately set to all in the SPFILE and the CDB instance.

C.
It is immediately set to all in only those pluggable databases (PDBs) where the value is
set to typical.

D.
It is immediately set to all only for cd3Sroot.

E.
It is immediately set to all in all PDBs where the statistics_level parameter is not set.



Leave a Reply 2

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


srks

srks

BD
CONTAINER=ALL is not mentioned.
Please crosscheck