Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 161:

  Your database is running in archivelog mode and regular nightly backups are taken. Due to a media

  failure, the current online redo log group, which has one member, is lost and the instance is aborted.

  Examine the steps to recover the online redo log group and move it to a new location.

  1.Restore the corrupted redo log group.

  2.Restore the database from the most recent database backup.

  3.Perform an incomplete recovery.

  4.Relocate the member of the damaged online redo log group to a new location.

  5.Open the database with the resetlogs option.

  6. Issue a checkpoint and clear the log.

  Identify the required steps in the correct order.

  A. 1, 3, 4, 5

  B. 6, 3, 4, 5

  C. 2, 3, 4, 5

  D. 6, 4, 3, 5

  Correct Answer: C

  If the group is Current Then it is the log that the database is currently writing to And you should Attempt to clear the log; if impossible, then you must restore a backup and perform incomplete recovery up to the most recent available redo log. Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/recoscen.htm#i1006437

• Question 162:

  Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

  A. A job is specified as part of a program definition.

  B. A program can be used in the definition of multiple jobs.

  C. A program and job can be specified as part of a schedule definition.

  D. A program and schedule can be specified as part of a job definition.

  E. A program and window can be specified as part of a job definition.

  Correct Answer: BDE

  References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN13371

• Question 163:

  Which two statements describe the relationship between a window, a resource plan, and a job class?

  A. A window specifies a resource plan that will be activated when that window becomes active.

  B. A window specifies a job class that will be activated when that window becomes active.

  C. A job class specifies a window that will be open when that job class becomes active.

  D. A window in association with a resource plan controls a job class allocation.

  E. A window in association with a job class controls a resource allocation.

  Correct Answer: AE

  Windows work with job classes to control resource allocation. Each window specifies the resource plan to activate when the window opens (becomes active), and each job class specifies a resource consumer group or specifies a database service, which can map to a consumer group. A job that runs within a window, therefore, has resources allocated to it according to the consumer group of its job class and the resource plan of the window. Reference: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12366

• Question 164:

  Which two are prerequisites for creating a backup-based duplicate database?

  A. connecting to the target database and a recovery catalog to execute the duplicate command

  B. creating a password file for an auxiliary instance

  C. connecting to an auxiliary instance

  D. matching the database identifier (DBID) of the source database and the duplicate database

  E. creating an SPFILE for the target database

  Correct Answer: BC

  References: http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDEDFFH

• Question 165:

  Which three statements are true about Oracle Secure Backup (OSB)?

  A. It can encrypt client data written to tape.

  B. It can be used to take image copy backups to tape.

  C. It can be used to manage tape backup and restore operations for multiple databases.

  D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.

  E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

  Correct Answer: ACE

  File system backups may be performed at the file, directory, file system or raw partition level with full,

  incremental and offsite backup scheduling. As backup needs grow requiring more tape drives and

  centralized backup management of multiple servers, Oracle Secure Backup XE can be easily upgraded to

  the Oracle Secure Backup edition.

  Reference:

  http://www.oracle.com/technetwork/products/secure-backup/learnmore/osb-xe-10-130649.pdf

• Question 166:

  Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.

  LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/arch MANDATORY'

  Identify the statement that correctly describes these settings.

  A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.

  B. Optional destinations cannot use the fast recovery area.

  C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.

  D. These settings work only if log__archive_min_succeed_dest is set to a value of 4.

  Correct Answer: C

  SQL> show parameter log_archive_min_succeed_dest NAME TYPE VALUE ------------------------------?------------------- log_archive_min_succeed_dest integer 1 SQ>; References: https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11346

• Question 167:

  Identify three benefits of unified auditing.

  A. It helps to reduce disk space used to store an audit trail in a database.

  B. It guarantees zero-loss auditing.

  C. It reduces overhead on a database caused by auditing, by having a single audit trail.

  D. An audit trail cannot be modified because it is read-only.

  E. It automatically audits Recovery Manager (RMAN) events.

  Correct Answer: CDE

• Question 168:

  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. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

  B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

  C. full database backup on Sunday, level 0 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 differential incremental level 1 backup on all the other days

  Correct Answer: A

  Multilevel Incremental Backups RMAN can create multilevel incremental backups. Each incremental level is denoted by a value of 0 or 1. A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing data. You can create a level 0 database backup as backup sets or image copies. The only difference between a level 0 incremental backup and a full backup is that a full backup is never included in an incremental strategy. Thus, an incremental level 0 backup is a full backup that happens to be the parent of incremental backups whose level is greater than 0. A level 1 incremental backup can be either of the following types: A differential incremental backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0. A cumulative incremental backup, which backs up all blocks changed after the most recent incremental backup at level 0. Incremental backups are differential by default.

• Question 169:

  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?

  A. capturing 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

  B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

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

  D. capturing 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

  Correct Answer: C

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

• Question 170:

  You are administering a multitenant container database (CDB) cdb1.

  Examine the command and its output:

  SQL>show parameterfile

  NAMETYPEVALUE

  db_create_file_deststring

  db_file_name_convertstring

  db_filesinteger200

  You verify that sufficient disk space is available and that no file currently exists in the `/u0l/app/oracle/

  oradata/cdb1/salesdb' location.

  You plan to create a new pluggable database (PDB) by using the command:

  SQL>CREATEPLUGGABLEDATABASESALESPDB

  ADMINUSERsalesadmIDENTIFIED 3Y password

  ROLES=(dba)

  DEFAULTTABLESPACEsales

  DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf'SIZE 250M AUTOEXTEND ON

  FILE_NAME_CONVERT=(`/u01/app/oracle/oradata/cdb1/pdbseed/',

  '/u01/app/oracle/oradata/cdb1/salesdb/')

  STORAGE(MAXSIZE2G)

  PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';

  Which statement is true?

  A. SALESPDB is created and is in mount state.

  B. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.

  C. SALESPDB is created and is in read/write mode.

  D. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

  Correct Answer: A

  We need seed tablespace to create new plugable db. Reference: /u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/orcl/pdbseed/system01.dbf By default. Seed has two tbs.