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 immediately set to all in the SPFILE and the CDB instance.
B.
It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
C.
It is immediately set to all only for cd3Sroot.
D.
It is immediately set to all in all PDBs where the statistics_level parameter is not set.
E.
It is set to all for all PDBs only in the SPFILE.
This section is not available anymore. Please use the main Exam Page.1z0-067 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
VIKY786
4 years, 6 months ago