1z0-067 Free Practice Test

Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

1. A. Oracle Data Pump
2. B. Oracle Recovery Manager (RMAN)
3. C. Oracle Label Security
4. D. Oracle Database Vault
5. E. Oracle Real Application Security

Correct Answer: B
Unlike other Oracle Database components, you do not create a unified audit policy for Oracle
Recovery Manager events. The UNIFIED_AUDIT_TRAIL data dictionary view has a set of fields, whose names begin with RMAN_, that automatically record Recovery Manager-related events. https://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDDHEIA

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

1. A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
2. B. All data files belonging to pdb2_1 are backed up along with the archive log files.
3. C. Only the data files belonging to pdb2_ are backed up.
4. D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Correct Answer: C

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

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

Correct Answer: D
Reference: http://www.dba-oracle.com/t_rman_36_validate_backup.htm

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

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

Correct Answer: ACEF
“The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile’s underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature.”
http://muhammad-asif-dba.blogspot.com.br/2013/11/oracle-12c-database-online-movedatafile. html

Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job’,FORCED_TRACKING=>'Y');
Which two statements are true?

1. A. Database operations will be monitored only when they consume a significant amount of resource.
2. B. Database operations for all sessions will be monitored.
3. C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
4. D. Only DML and DDL statements will be monitored for the session.
5. E. All subsequent statements in the session will be treated as one database operation and will be monitored.

Correct Answer: CE
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and
Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable \'Y\'.
/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable \'N\'.