Oracle DB 23ai Admin Practice Questions - Oracle Database 23ai Administrator Professional Exam

Access More Questions

A DBA needs to create a PDB by cloning an existing PDB named HRPDB while it remains open. Which SQL statement accomplishes this?

CREATE PLUGGABLE DATABASE HRPDB_CLONE FROM HRPDB; CREATE PLUGGABLE DATABASE HRPDB_CLONE FROM HRPDB SNAPSHOT COPY; CREATE PLUGGABLE DATABASE HRPDB_CLONE FROM HRPDB FILE_NAME_CONVERT=('/hrpdb/','/hrpdb_clone/'); CREATE PLUGGABLE DATABASE HRPDB_CLONE CLONE FROM HRPDB OPEN RESTRICTED;

Correct Answer:

CREATE PLUGGABLE DATABASE HRPDB_CLONE FROM HRPDB FILE_NAME_CONVERT=('/hrpdb/','/hrpdb_clone/');

Access more questions from this quiz

Continue to Oracle DB 23ai Admin Practice Questions - Oracle Database 23ai Administrator Professional Exam for more practice questions and the full quiz experience.

Access More Questions