ExamQuestions.com

Register
Login
Upgrade to Oracle Database 12c Exam Questions

Oracle

Upgrade to Oracle Database 12c

6 / 125

Question 6:

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to is corrupted. ACCOUNTS_PDB - What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB? 

Answer options:

A. Place CDB1 in the mount stage and then take the USERDATA tablespace offline in ACCOUNTS_PDB.B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb OPEN RESTRICTED command.
D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.