Oracle
1Z0-063 · Question #135
1Z0-063 Question #135: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-063 to reveal the answer and full explanation for question #135. The question stem and answer options stay visible for context.
Question
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?
Options
- AIt is immediately set to all in the SPFILE and the CDB instance.
- BIt is immediately set to all in only those pluggable databases (PDBs) where the value is set to
- CIt is immediately set to all only for cd3Sroot.
- DIt is immediately set to all in all PDBs where the statistics_level parameter is not set.
- EIt is set to all for all PDBs only in the SPFILE.
Unlock 1Z0-063 to see the answer
You've previewed enough free 1Z0-063 questions. Unlock 1Z0-063 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.