Choose two You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?

• A.Copy the password file from a sample file in the DBS dierectory
• B.Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• C.Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
• D.Re-create or migrate the password file to the Oracle Database 12c format

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1was 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 SQL while connected to PDB1.
• C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.
• D.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.
• E.This cannot be done due to the lack of a clean restore point.

Comment: *

Name: *

Email: *

Verification: *

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

• A.a group called dba
• B.an operating system account called grid
• C.an operating system user to own this installation
• D.the Oracle Inventory group oinstall
• E.the installation of Oracle ASMLIB

Comment: *

Name: *

Email: *

Verification: *

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

• A.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• B.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• C.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.
• D.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• E.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• F.The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• G.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• H.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

• A.Using the Data Recovery Advisor LIST FAILUREcommand always requires that the database for which failures are to be listed is in MOUNTstate.
• B.A failure can be closed only when it has been repaired.
• C.Data Recovery Advisor can be used if a database is closed.
• D.The Data Recovery Advisor CHANGE FAILUREcommand can be used only to change failure priorities.
• E.Data Recovery Advisor can proactively check for failures.

Comment: *

Name: *

Email: *

Verification: *