Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 11:

  Which two statements are true about a job chain? (Choose two.)

  A. A job chain can contain a nested chain of jobs.

  B. The jobs in a job chain cannot have more than one dependency.

  C. A job of the CHAIN type can be run using event-based or time-based schedules.

  D. The jobs in a job chain can be executed only by using the events generated by the Scheduler

  Correct Answer: AC

• Question 12:

  Examine the following RMAN script:

  RMAN> run {

  debug on;

  allocate channel c1 type disk;

  backup datafile 5;

  }

  Which statement describes the purpose of the script?

  A. The data file is checked for physical corruption and backed up if found clean.

  B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

  C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

  D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

  Correct Answer: D

• Question 13:

  During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?

  A. The installation terminates with an error.

  B. The installation proceeds with the default value without warnings and errors.

  C. The installation proceeds with the default value but it would not be an OFA-compliant database.

  D. The installation proceeds with the default value but a message would be generated in the alert log file.

  Correct Answer: D

• Question 14:

  You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.

  One of the disks in the disk group becomes unavailable because of power failure. You issued the following

  command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

  ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';

  To which disks in the disk group will the new value be applicable?

  A. all disks in the disk group

  B. all disks that are currently in OFFLINE mode

  C. all disks that are not currently in OFFLINE mode

  D. all disks in the disk group only if all of them are ONLINE

  Correct Answer: C

• Question 15:

  You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>'group1', COMMENT => 'New Group'); This command errors out displaying the following message: ERROR at line 1: ORA-29371: pending area is not active ORA-06512: at "SYS.DBMS_RMIN", line 115 ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1 What action would you take to overcome this error?

  A. activate the Pending Area before creating the consumer group

  B. create the Pending Area before creating the consumer group

  C. increase the size of the database buffer cache to accommodate the Pending Area

  D. increase the size of the shared pool to accommodate the Pending Area

  E. increase the size of the large pool to accommodate the Pending Area

  Correct Answer: B

• Question 16:

  Which three file types are managed by Data Pump jobs?

  A. out files

  B. log files

  C. alert files

  D. SQL files

  E. error files

  F. dump files

  Correct Answer: BDF

• Question 17:

  You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

  A. Its entries are specific to a single database.

  B. It contains file systems that have been mounted by Direct NFS.

  C. It is globally available to all Oracle 11g databases on the machine.

  D. It contains file systems that have been mounted by the kernel NFS system.

  Correct Answer: CD

• Question 18:

  UNDO__RETENTION is set to 1000 and retention is not guaranteed. You configure the database with a fixed size undo tablespace. Which is true about undo retention in this configuration?

  A. Undo expires after 1000 seconds and is deleted.

  B. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.

  C. Inactive undo is retained for at least 1000 seconds if free undo space is available.

  D. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSAUX tablespace to provide read consistency.

  Correct Answer: C

• Question 19:

  Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

  A. It bypasses the OS file system cache.

  B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.

  C. It uses the operating system kernel NFS layer for user tasks and network communication modules.

  D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.

  E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.

  Correct Answer: AE

• Question 20:

  Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

  A. configuring control file autobackup to be ON

  B. backing up data filed only and not the archived redo log files

  C. running the recovery catalog database in NOARCHIVELOG mode.

  D. setting the retention policy to a REDUNDANCY value greater than 1

  E. backing up the recovery catalog to the same disk as that of the target database

  Correct Answer: AD