Question No. 1

Examine the command to back up the ASM metadata:

ASMCMD>md_backup /backup/ASM_backup

In which three situations can you use the backup?

Awhen one or more disks in an ASM disk group are lost

Bwhen the data file on an ASM disk group gets corrupted

Cwhen one of the disks in a disk group is accidentally unplugged

Dwhen one or more file directory paths are accidentally deleted from an ASM disk group

Ewhen all the ASM disk groups for the ASM instance are lost

Show Answer

Correct Answer: A, D, E

The md_backup command creates a backup file containing metadata for one or more disk groups. i By default all the mounted disk groups are included in the backup file which is saved in the current working directory.

The md_backup command creates a backup file containing metadata for one or more disk groups.

References: http://www.hhutzler.de/blog/asm-backup-and-restore-dg-metadata/

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_util004.htm#OSTMG94578

Question No. 2

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

AA base recovery catalog should exist.

BThe owner of VPC cannot own recovery catalog.

CAt least one target database should be registered in the recovery catalog.

DThe register database privilege should be granted to the virtual catalog owner.

EThe DBA role should be granted to the virtual catalog owner.

Show Answer

Correct Answer: A, D, E

Question No. 3

You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).

You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.

What is the easiest way to perform capacity planning for consolidation?

Acapturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

Bcapturing the workload on the production system and replaying the workload for one PDB at a time on the test system

Ccapturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

Dcapturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Show Answer

Correct Answer: C

https://docs.oracle.com/database/121/RATUG/GUID-29988B63-F974-46EF-9AAD-3D04AF774337.htm#RATUG4122

Question No. 4

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

Which three statements are true about Oracle Restart?

AIt can be configured to automatically attempt to restart various components after a hardware or software failure.

BWhile starting any components, it automatically attempts to start all dependencies first and in proper order.

CIt can be configured to automatically restart a database in case of normal shutdown of the database instance.

DIt can be used to only start Oracle components.

EIt runs periodic check operations to monitor the health of Oracle components.

Show Answer

Correct Answer: A, B, E

A is correct: Oracle Restart improves the availability of your Oracle database. When you install Oracle Restart, various Oracle components can be automatically restarted after a hardware or software failure or whenever your database host computer restarts E is correct: Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted. B is also true About Startup Dependencies Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.

References: http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

Free Oracle 1Z0-067 Exam Actual Questions

The questions for 1Z0-067 were last updated On Jan 13, 2025