Question No. 1

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?

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

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

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

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

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

Show Answer

Correct Answer: C, E

Question No. 2

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

ADATE

BTIMESTAMP

CINTERVAL YEAR TO MONTH

DINTERVAL DAY TO SECOND

ETIMESTAMP WITH LOCAL TIME ZONE

Show Answer

Correct Answer: B, E

http://docs.oracle.com/database/121/NLSPG/ch3globenv.htm#i1007084

Question No. 3

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.

From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.

What could be the reason for this?

AThe event parameter was not set.

BThe sql_trace parameter is set to false.

CEnterprise Manager was not used.

DThe statistics_level parameter is set to basic.

EThe t:kid_statistics parameter is set to false.

Show Answer

Correct Answer: D

To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to TYPICAL or ALL.

References:

http://www.dba-oracle.com/t_dbms_server_alert.htm

Question No. 4

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.)

Aassigned to a class with rights to browse all directories and catalogs

Bassigned to a class with rights to back up or restore Oracle database

COSB encryption for data in transport and on tape

DRMAN preauthorization on the host

Ematching the OS user identity of the Oracle instance associated with the database username

Fscheduling of the RMAN backup to occur automatically at user-defined intervals

Show Answer

Correct Answer: B, D, E

Question No. 5

Which two statements are true about a multitenant architecture?

AEach pluggable database (PDB) has its own initialization parameter file.

BA PDB can have a private undo tablespace.

CLog switches occur only at the container database level.

DA PDB can have a private temporary tablespace.

EEach PDB has a private control file.

Show Answer

Correct Answer: C, D

You are only able to switch the archived logs when you connect to the root of a CDB, but you cannot switch archived redo logs when connected to a PDB. You can able to create a PDB without temporary tablespace but not able to make it use the temporary tablespace of CDB.

Free Oracle 1Z0-067 Exam Actual Questions

The questions for 1Z0-067 were last updated On Nov 4, 2024