Online Access Free 1z0-067 Exam Questions

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?

• A.RMAN Media Management Library
• B.Oracle Secure Backup
• C.RMAN recovery catalog
• D.Enterprise Manager Database Express
• E.Enterprise Manager Cloud Control

You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

• A.Corrupted blocks in the data files are checked and repaired before performing the database backup.
• B.The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
• C.Corrupted blocks, if any, are repaired in the backup created.
• D.Only those data files that have corrupted blocks are backed up.

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1.Determine which backup contains the table that needs to be recovered.
2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.
3.Import the Data Pump export dump file into the auxiliary instance.
4.Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.

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

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:
RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c
RMAN> IMPORT CATALOG rc11/pwdcat11@ract11
Which two tasks are performed as part of the import? (Choose two.)

• A.Imported databases are unregistered from the RC11 catalog.
• B.Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
• C.Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
• D.Recovery catalog is resynchronized with the control files of the registered databases.
• E.All databases registered in the RC11 catalog are registered in the RC12C catalog.

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

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