1Z0-083 practice question 22 of 35

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT isan application root in CDB1. 3. APP_PDB1 is an…

Choose your answer, then check it against the explanation.

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is

an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK

DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL>

SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE

TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root;

Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER

SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1

NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE

app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO

SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback

operation has completed?

Answer options
Question 22 of 35

Keep practicing

Take the free 1Z0-083 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test

More questions

Other 1Z0-083 practice questions

Scroll to Top