Oracle
1Z0-060 · Question #225
1Z0-060 Question #225: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #225. The question stem and answer options stay visible for context.
Question
You are connected to a multitenant container database (CDB) with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You issue: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; Which three effects does this have on the CDB and its pluggable databases (PDBs)? (Choose three.)
Options
- AThe STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs where the
- BThe STATISTICS_LEVEL parameter is immediately set to ALL in the CDB instance.
- CThe STATISTICS_LEVEL parameter is set to ALL on all PDBs when they are opened.
- DThe STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs.
- EThe STATISTICS_LEVEL parameter is set to ALL in the SPFILE.
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 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.