Oracle
1Z0-062 · Question #116
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 C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database. In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases. You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new…
Exploring the Oracle Database Architecture
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
(38 responses)- A11% (4)
- B3% (1)
- C68% (26)
- D18% (7)
Explanation
- In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases. You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same.
Topics
#Multitenant architecture#PDB_MODIFIABLE parameters#ALTER SYSTEM SET#SPFILE scope
Community Discussion
No community discussion yet for this question.