Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 31:

  Which steps are mandatory to enable Direct NFS?

  1.

  Mount all required file systems using the kernel NFS driver.

  2.

  Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.

  3.

  Replace the ODM library libodm11.so_stub with libodm11.so.

  A. 2 and 3

  B. 1 and 3

  C. 1 and 2

  D. 1, 2 and 3

  Correct Answer: B

• Question 32:

  Examine the following command that is used to duplicate a database on the same host:

  RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }

  Which two statements describe the effect after the database is duplicated successfully? (Choose two)

  A. The data files of the read-only tablespaces in the target database are not duplicated

  B. The read-only tablespaces in the target database are still defined in new the database

  C. The read-only tablespaces in the target database are changed to online after duplication

  D. The data files of the read-only tablespaces in the target database get duplicated

  E. The read-only tablespaces in the target database are not defined in the new database

  Correct Answer: AB

• Question 33:

  You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.

  What must you set using the RMAN CONFIGURE command to achieve this?

  A. MAXSETSIZE TO 2;

  B. DEVICE TYPE DISK PARALLELISM 2;

  C. RETENTION POLICY TO REDUNDANCY 2;

  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

  Correct Answer: D

• Question 34:

  Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

  A. SORT_AREA_SIZE

  B. HASH_AREA_SIZE

  C. BITMAP_MERGE_AREA_SIZE

  D. CREATE_BITMAP_AREA_SIZE

  E. PGA_AGGREGATE_TARGET

  Correct Answer: ABCD

• Question 35:

  You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.

  Which condition must be met before you create the VPC?

  A. A base catalog exists

  B. The recovery catalog is empty

  C. The base recovery catalog must be dropped

  D. A target database is registered in the recovery catalog

  Correct Answer: A

• Question 36:

  You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:

  1.

  Restore an autobackup of the server parameter file.

  2.

  Restore the control file

  3.

  Start the target database instance

  4.

  Mount the database

  5.

  Restore the data files

  6.

  Open the database with RESETLOGS option

  7.

  Recover the data files

  8.

  Set DBID for the target database

  Which option illustrates the correct sequence that you must use?

  A. 8, 1, 3, 2, 4, 5, 7, 6

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

  C. 1, 3, 4, 2, 8, 5, 6, 7

  D. 1, 3, 2, 4, 6, 5, 7, 8

  Correct Answer: A

• Question 37:

  Which three tasks can be performed using a duplicate database? (Choose three.)

  A. Testing the backup and recovery procedures

  B. Testing the upgrade of an Oracle database to a new release

  C. Testing the effect of an application changes on database performance

  D. Continuously updating archive log files from the target database to support failover

  Correct Answer: ABC

• Question 38:

  Refer to the exhibit.

  

  Examine the Following commands and their output:

  View the Exhibit and examine the Flashback Version Query that was executed after the preceding

  commands.

  What could be the possible cause for the query not displaying any row?

  A. Flashback logging is not enabled for the database.

  B. The changes made to the table are not committed.

  C. Supplemental logging is not enabled for the database.

  D. The database is not configured in ARCHIVELOG mode.

  Correct Answer: B

• Question 39:

  You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.

  Which of these methods would you use to achieve this? (Choose all that apply.)

  A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

  B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

  C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

  D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

  Correct Answer: BCD

• Question 40:

  Which statement is true about a Scheduler-generated event?

  A. It can be generated when a file arrives on the file system.

  B. it indicates state changes that occur within the Scheduler itself.

  C. it is raised by an application that is consumed by the Scheduler to start a job.

  D. it requires jobs to be defined with an event condition and a queue specification.

  Correct Answer: D