1Z0-067 Online Practice Questions and Answers

For which three pieces of information can you use the RMAN list command?

A. stored scripts in the recovery catalog

B. available archived redo log files

C. backup sets and image copies that are obsolete

D. backups of tablespaces

E. backups that are marked obsolete according to the current retention policy

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Examine the table definition:

create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time);

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A. The valid time columns employee_time_start and employee_time_end are automatically created.

B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C. The valid time columns are not populated by the Oracle Server automatically.

D. The valid time columns are visible by default when the table is described.

E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

A. Use the DBMS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.

B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.

C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

D. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

E. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

A. tracking the most recent read time for a table segment in a user tablespace

B. tracking the most recent write time for a table segment in a user tablespace

C. tracking insert time by row for table rows

D. tracking the most recent write time for each block in a table segment

E. tracking the most recent read time for a table segment in the sysauxtablespace

F. tracking the most recent write time for a table segment in the sysauxtablespace

Examine the command used to perform an incremental level-0 backup:

RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;

To enable block change tracking, after the incremental level 0 backup, you issue the command:

SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE'/mydir/rman_change_track.f';

To perform an incremental level-1 cumulative backup, you issue the command:

RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;

Which two statements are true in the preceding situation?

A. The block change tracking data is used only from the next incremental backup.

B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.

D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

You are required to migrate your 11.2.0.3 database to an Oracle 12c database.

Examine the list of steps that might be used to accomplish this task:

1.Place all user-defined tablespaces in read-only mode on the source database.

2.Use the RMAN convert command to convert data files to the target platform's endian format, if required.

3.Perform a full transportable export on the source database with the parameters

VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.

4.

Transport the data files for all the user-defined tablespaces.

5.

Transport the export dump file to the target database.

6.

Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.

7.

Perform an import on the target database by using the full and transportable_datafiles parameters.

Identify the required steps in the correct order.

A. 1, 3, 5, 4, 2, and 7

B. 1, 2, 4, 6, 5, 3, and 7

C. 1, 2,4, and 7

D. 2, 4, 5, 6, and 7

Examine the command to back up the ASM metadata:

ASMCMD>md_backup /backup/ASM_backup

In which three situations can you use the backup?

A. when one or more disks in an ASM disk group are lost

B. when the data file on an ASM disk group gets corrupted

C. when one of the disks in a disk group is accidentally unplugged

D. when one or more file directory paths are accidentally deleted from an ASM disk group

E. when all the ASM disk groups for the ASM instance are lost

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).

Which two are prerequisites for performing this operation? (Choose two.)

A. You must take the tools01.dbf data file offline.

B. You must ensure that the database is mounted or open.

C. You must use an incremental level-1 backup to restore blocks.

D. You must configure a block change tracking file.

E. You must have full or level-0 backups to restore blocks.

A redaction policy was added to the SAL column of the SCOTT.EMP table:

BEGIN

DBMS_REDACT.ADD_POLICY(

OBJECT_SCHEMA => `SCOTT',

OBJECT_NAME => `EMP',

POLICY_NAME => `SCOTT_EMP',

COLUMN_NAME => `SAL',

EXPRESSION => `SYS_CONTEXT (``SYS_SESSION_ROLES'', ``MGR'') = ``FALSE''');

END;

/

All users have their default set of system privileges.

For which three situations will data not be redacted? (Choose three.)

A. SCOTT sessions, because he is the owner of the table

B. SCOTT sessions, only if the MGR role is granted to SCOTT

C. SCOTT sessions, only if the MGR role is set in the session

D. SYS sessions, regardless of the roles that are set in the session

E. SYSTEM sessions, regardless of the roles that are set in the session

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

A. assigned to a class with rights to browse all directories and catalogs

B. assigned to a class with rights to back up or restore Oracle database

C. OSB encryption for data in transport and on tape

D. RMAN preauthorization on the host

E. matching the OS user identity of the Oracle instance associated with the database username

F. scheduling of the RMAN backup to occur automatically at user-defined intervals