Your production database is running in ARCHIVELOG mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

• A. by using the RMAN SWITCH command to set the new location for the data files
• B. by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host
• C. by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host
• D. by creating a new database in the new host, and then using the RMAN RECOVER command

Which three statements are true about common roles? (Choose three.)

• A. Only system privileges can be granted to a common role in a container database (CDB).
• B. A common role can be granted only to a common user.
• C. A common role cannot be created by a local user.
• D. A common user that is granted a common role can grant the role to other common and local users in a PDB.
• E. Object privileges can be granted to a common role in a pluggable database (PDB).

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

• A. 1, 3, 6, 2, 5, 4
• B. 1, 3, 2, 5, 6, 4
• C. 1, 3, 5, 6, 2, 4
• D. 1, 3, 5, 2, 6, 4

Your database is running in ARCHIVELOG mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.

• A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations.
• B. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.
• C. Optional destinations cannot use the fast recovery area.
• D. These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4.