Free Oracle 1z0-067 Exam Dumps Questions & Answers

Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to seven days in RMAN.
-The most recent backup to disk for the tools tablespace was taken on March 1, 2015.
-The tools tablespace is read-only since March 2, 2015.
On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.
Which statement is true about the backup of the tools tablespace?

• A.RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
• B.RMAN skips the backup of the tools tablespace because backup optimization is enabled.
• C.The RMAN backup fails because the tools tablespace is read-only.
• D.RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Which two statements are true when row-archival management is enabled?

• A.The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• B.The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.
• C.Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
• D.The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• E.The row archival visibility session parameter defaults to all rows.

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?

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

Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.

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

Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?

• A.full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• B.level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
• C.level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
• D.full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days