1Z0-060 · Question #132
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…
The correct answer is A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened. SPFILE The initialization parameter setting is changed for the PDB in the SPFILE. The new setting takes effect in any of the following cases: The PDB is closed and re-opened. The CDB is shut down and re-opened. In these cases, the new setting affects only the PDB.
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.
How the community answered
(27 responses)- A81% (22)
- B4% (1)
- C11% (3)
- D4% (1)
Explanation
SPFILE The initialization parameter setting is changed for the PDB in the SPFILE. The new setting takes effect in any of the following cases: The PDB is closed and re-opened. The CDB is shut down and re-opened. In these cases, the new setting affects only the PDB.
Topics
Community Discussion
No community discussion yet for this question.