PDB Management

8 Questions
Study Guide: This page shows the correct answers and explanations for all questions in this topic. Review these to understand the key concepts.

Question:

You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the approp riate mode to open the PDB to achieve this?

Correct Answer: A
  • A. READ WRITE
Explanation
To change a PDB_MODIFIABLE parameter, the PDB must be in READ WRITE mode, allowing ALTER SYSTEM commands to modify parameters stored in the PDB’s SPFILE or memory. READONLY modes prevent modifications, and no RESTRICTED WRITE ONLY mode exists.

Question:

Which statement regarding PDBs (Pluggable Databases) is correct?

Correct Answer: A
  • A. You can drop a PDB as long as it is not the PDB seed.
Explanation
A .True. Any PDB except PDB$SEED can be dropped. B .False. Source PDBs of refreshable clones can be dropped after cloning. C .False. Dropping an application root requires explicit handling of PDBs. D .False. Relocation doesn’t mandate dropping the source PDB.

Question:

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

Correct Answer: A
  • A. The role has the privileges to administer the PDB.
Explanation
A .True. PDB_DBA grants admin rights (e.g., CREATE SESSION, ALTER SYSTEM) within the PDB. B .False. DDL on objects requires ownership or explicit grants. C .False. User management needs CREATE USER privilege, not inherent. D .False. It includes multiple privileges, not none.

Question:

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?

Correct Answer: A,D
  • A. ALTER SYSTEM CHECKPOINT
  • D. ALTER SYSTEM ENABLE/DISABLE RESTRICTED SESSION
Explanation
A .True. Local checkpoints are allowed in PDBs. B .False. Buffer cache is CDB-level. C .False. Log switching is CDB-level. D .True. Restricted session can be toggled per PDB.

Question:

At which two container database levels can COMMON Unified Audit Policies be used?

Correct Answer: B,C
  • B. At the CDB level.
  • C. At the Application Root level of an Application Container.
Explanation
A .False. Not limited to CDB; PDBs can use common policies. B .True. Common policies apply at CDB level. C .False. Application Root uses app-specific policies. D .False. “COMMON option” isn’t a feature; policies are common by creation context. E .True. A common user can create policies for PDBs.

Question:

What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;

Correct Answer: B
  • B. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart.
Explanation
A .False. DISCARD STATE isn’t tied to upgrades; it resets PDB startup behavior. B .True. Discards saved state, reverting PDB1 to manual open mode (not auto-open) after CDB restart. C .False. Default is not auto-open; it’s manual unless explicitly saved as OPEN. D .False. Used for state management, not general mode changes (e.g., OPEN READ WRITE).

Question:

Which of the following is true about the status of a PDB that has been unplugged from a CDB?

Correct Answer: A
  • A. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
Explanation
A .True. After ALTER PLUGGABLE DATABASE ... UNPLUG, CDB_PDBS.STATUS shows UNPLUGGED. B .False. UNAVAILABLE isn’t a valid status here. C .False. REMOVED isn’t used; UNPLUGGED persists until dropped. D .False. DISABLED isn’t a PDB state in this context.

Question:

What services does the Automatic Workload Repository (AW R) provide for the database self-tuning functionality?

Correct Answer: B
  • B. Simplifies the process of migrating Non-CDB databases to the cloud.
Explanation
A .False. AWR doesn’t create PDBs. B .True. AWR stats aid migration planning (e.g., perfor mance baselines). C .False. AWR doesn’t convert CDB to Non-CDB. D .False. SID management isn’t AWR’s role.
All Study Guides
Practice This Topic Take a Test