Online Access Free 1z0-067 Exam Questions

Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN RUN block execution?

• A.The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
• B.The script is executed and both DC1 and CH1 channels are used for script execution.
• C.The execution of the script fails because multiple channels cannot exist simultaneously.
• D.The new channel, CH1, is ignored because a channel has been configured already.

Which two statements are true about dropping a pluggable database (PDB)?

• A.The data files associated with a PDB are automatically removed from disk.
• B.A PDB must be in mount state or it must be unplugged.
• C.A PDB must have been opened at least once after creation.
• D.A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
• E.The backups associated with a PDB are removed.
• F.A PDB must be in closed state.

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

• A.If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
• B.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
• C.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
• D.If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• E.In a PDB plan, subplans may be used with up to eight consumer groups.

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods are performed the truncated table data? (Choose two.)

• A.Tablespace Point-in-Time Recovery
• B.Flashback Transaction Backout
• C.Database Point-in-Time Recovery
• D.Table Point-in-Time Recovery.
• E.Flashback Database

Which two statements are true about unified auditing?

• A.Unified auditing is enabled by setting the audit_trail parameter to db, extended.
• B.Audit records are created for all users except sys.
• C.Audit records are created only for the DML and DDL operations performed on database objects.
• D.Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
• E.A unified audit trail captures audit information from unified audit policies and audit settings.
• F.A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.