You as a DBA, has to perform the maintenance activity on PDBDATA. As part of the activity, you need to first restart the pluggable database PDBDATA.

Which of the below statement(s) can be executed to perform the restart when connected to root container?

  1. SQL> ALTER PLUGGABLE DATABASE PDBDATA CLOSE;

SQL> ALTER PLUGGABLE DATABASE PDBDATA OPEN;

ii. SQL> ALTER PLUGGABLE DATABASE PDBDATA OPEN FORCE;

Only (i)

Only (ii)

Neither (i) nor (ii)

Either (i) or (ii)

Verified Answer
Correct Option - d

To get all Infosys Certified Oracle 12c Administration Associate Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram