Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

• A.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.
• B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.
• C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.
• D.This cannot be done due to the lack of a clean restore point.
• E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

• A.By default, the transported database will use Oracle Managed Files (OMF)
• B.Data files can be converted on the destination system.
• C.Data files can be converted on the source system.
• D.A new DBID is automatically created for the transported database.
• E.Databases can be transported between systems with different endian formats.
• F.The password file is automatically converted by RMAN.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.PDB1 and PDB2 are in MOUNT state.
• B.PDB1 and PDB2 are in READ ONLY state.
• C.CDB$ROOT is in MOUNT state.
• D.PDB$SEED is in READ ONLY state.
• E.Redo logs are opened.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

• A.It requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks.
• B.It requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks.
• C.It requires the operating system ORACLE_BASDE environment variable to be predefined before installation.
• D.It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.
• E.It creates one disk group during installation.
• F.Automatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived.
Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABSE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABSE OPEN
10.ALTER DATABASE OPEB RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

• A.1, 3, 5, 8, 6, 10
• B.1, 3, 5, 6, 9
• C.1, 3, 5, 7, 10
• D.1, 3, 5, 6, 10
• E.1, 2, 5, 7, 4, 10

Comment: *

Name: *

Email: *

Verification: *