View Mode
Q: 11

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup istaking too long and suspect a performance bottleneck. Which three are true about diagnosing and tuning these problems? (Choose three.)

Options
Q: 12
Choose two. Which two are true about PDB archive files?
Options
Q: 13
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
Options
Q: 14
Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?
Options
Q: 15
Choose two. In which two situations can you use Database Upgrade Assistant?
Options
Q: 16
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
Options
Q: 17
Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?
Options
Q: 18
A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?
Options
Q: 19

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?

Options
Q: 20

Choose the best. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

Options
Question 11 of 20 · Page 2 / 2

Premium Access Includes

  • Quiz Simulator
  • Exam Mode
  • Progress Tracking
  • Question Saving
  • Flash Cards
  • Drag & Drops
  • 3 Months Access
  • PDF Downloads
Get Premium Access
Scroll to Top

FLASH OFFER

Days
Hours
Minutes
Seconds

avail 10% DISCOUNT on YOUR PURCHASE