Online Access Free 1z0-067 Practice Test

Which four actions are possible during an Online Datafile Move operation?

• A.Executing DML statements on objects stored in the datafile being moved
• B.Creating and dropping tables in the datafile being moved
• C.Performing Block Media Recovery for a data block in the datafile being moved
• D.Performing file shrink of the data file being moved
• E.Querying tables in the datafile being moved
• F.Flashing back the database

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

• A.Undo retention guarantee must be configured for the database
• B.A supplemental log must be enabled for the primary key
• C.Row movement must be enabled
• D.Fast Recovery Area must be enabled for the database
• E.The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package

Which two statements are true about unified auditing?

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

You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created? (Choose the best answer.)

• A.It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).
• B.It is created as a CDB with the CDB$ROOT and PDB$SEED databases.
• C.It is created as a PDB that must be plugged into an existing CDB.
• D.It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1.Start the RMAN client by using the RMAN target / command.
2.Start the RMAN client by using the OSB user.
3.RMAN creates the backup pieces.
4.Run the RMAN backup command with the sbt channels.
5.OSB creates a backup job and assigns a unique identifier.
6.OSB creates a backup job request through the OSB sbt library.
7.OSB stores metadata about RMAN backup pieces in the OSB catalog.
8.OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

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