Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

• A.SPFILE backups can be created while connected to an application root PDB.
• B.The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.
• C.Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
• D.The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
• E.The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. The orcl database data files are in Automatic Storage Management (Oracle ASM) disk group +data.
2. orcl uses disk group +fra for the Fast Recovery Area.
3. listener is the listener for orcl.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:
$ srvctl start database -d ORCL
What is the outcome?

• A.The ORCL database, the Oracle ASM instances, the +data and +fra disk groups, and the listener are started.
• B.Only the orcl database instance, the Oracle ASM instance, and the +data and +fra disk groups are started.
• C.Only the orcl database instance is started.
• D.Only the orcl database instance and the +data and +fra disk groups are started.
• E.Only the orcl database and the ASM instances are started.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle instance recovery? (Choose three.)

• A.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• B.Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• C.Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
• D.Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
• E.Recovery begins from the beginning of the CURRENT redo log group.
• F.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

• A.It analyzes a period of time corresponding to the last day of activity.
• B.It runs automatically after each AWR snapshot.
• C.It analyzes a period of time corresponding to the 12 hours of activity.
• D.Results are written to the alert log.
• E.A DBA can run it manually.

Comment: *

Name: *

Email: *

Verification: *

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:
Which table or set of tables will exist after the Flashback operation has completed?

• A.CDB1_TAB and APP_ROOT_TAB
• B.none of the tables, because all three tables will be dropped
• C.CDB1_TAB only
• D.CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
• E.CDB1_TAB and APP_PDB1_TAB

Comment: *

Name: *

Email: *

Verification: *