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…
Full set: 286 questionsChoose 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?
The command FLASHBACK PLUGGABLE DATABASE approot TO SCN 2074756 reverts the application root approot to the state it was in at the specified SCN. A critical rule is that when an application root is flashed back, all of its associated application PDBs are also flashed back to the same point in time. In this scenario, both APPROOTTAB and APPPDB1TAB were created after SCN 2074756. Therefore, the flashback operation will remove both of these tables. The table CDB1TAB, created in CDB$ROOT, is outside the scope of this PDB-level flashback and remains unaffected.
A. APPROOTTAB and APPPDB1TAB will be dropped by the flashback operation because they were created after the target SCN.
B. APPPDB1TAB will be dropped because its container, apppdb1, is flashed back along with the application root approot.
C. APPROOTTAB will be dropped by the flashback operation as it was created in approot after the target SCN.
E. CDB1TAB will not be dropped because the flashback operation was performed on the PDB approot, not on the CDB$ROOT container.
Oracle Database Backup and Recovery User's Guide 19c, "Performing Flashback and Database Point-in-Time Recovery", Section 17.4.1 "About Flashback Pluggable Database". It states, "When you perform a flashback operation on an application root, all of its application PDBs are also flashed back."
Oracle Database SQL Language Reference 19c, "FLASHBACK PLUGGABLE DATABASE". The documentation confirms the command reverts the data files of the specified PDB to a past point in time.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
