Oracle
1Z0-062 · Question #116
1Z0-062 Question #116: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #116. The question stem and answer options stay visible for context.
Question
You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE; Which is true about the result of this command?
Options
- AThe STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
- BThe STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
- CThe STATISTICS_LEVEL parameter is set to all whenever the multitenant container database
- DNothing happens; because there is no SPFILE for each PDB, the statement is ignored.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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.