Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 131:

  The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?

  A. The Oracle database will not perform block checking for any of the data blocks.
  B. The Oracle database will perform block checking for the default permanent tablespace only.
  C. The Oracle database will perform block checking for the data blocks in all user tablespaces.
  D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
  E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
  D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

• Question 132:

  The DB_BLOCK_CHECKING parameter is set to FULL. What checks occur each time the DBWnprocess(es) writes?

  A. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
  B. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
  C. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.
  D. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.
  E. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.
  A. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

• Question 133:

  To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the tablespace in backup mode:

  SQL> ALTER TABLESPACE users BEGIN BACKUP;

  While copying the file to the backup destination a power outage caused the instance to terminate abnormally.

  Which statement is true about the next database startup and the userstablespace?

  A. The database will open, and the tablespace automatically comes out of the backup mode.
  B. The database will be mounted, and recovery must be performed on the USERS tablespace.
  C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
  D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
  C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

• Question 134:

  Examine the following command for RMAN backup:

  RMAN> RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

  BACKUP

  INCREMENTAL LEVEL = 0

  (DATAFILE 1,4,5 CHANNEL c1)

  (DATAFILE 2,3,9 CHANNEL c2)

  (DATAFILE 6,7,8 CHANNEL c3);

  SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

  Which statement is true regarding the approach in the command?

  A. The RMAN multiplexing level is 4.
  B. It is the use of asynchronous I/O by RMAN.
  C. It is a case of parallelization of the backup set.
  D. It is an implementation of a multi section backup.
  C. It is a case of parallelization of the backup set.

• Question 135:

  Which two statements are true about the duplexing of the backups taken by RMAN?

  A. It's only supported for the backups performed on the tape
  B. It is not supported for backup operations that produce image copies
  C. Duplex backups need a parallelism for the device to be equal to number of copies
  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
  B. It is not supported for backup operations that produce image copies
  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

• Question 136:

  You observed the following output for a user session:

  

  What do you infer from the preceding output?

  A. Resumable set for session with sid 18
  B. The user session has entered into a deadlock
  C. The database instance is enabled to use asynchronous commit
  D. The threshold warning limit is exceeded for the tablespace that is used by the user session
  A. Resumable set for session with sid 18

• Question 137:

  memory_target big integer 808M

  pga_aggregate_target big integer 0

  sga_target big integer 0

  SQL> SHOW PARAMETER SGA_MAX_SIZE

  NAME TYPE VALUE

  ------------------------------------------------------------------------------------------------- sga_max_size big integer 808M Which statement is correct about the database?

  A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.
  B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and
  C. SGA_TARGET are set.
  D. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set.
  E. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.
  E. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.

• Question 138:

  You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates. Which tablespace will be the default permanent tablespace for non-system users, excluding DBSNMP and OUTLN?

  A. USERS
  B. SYSTEM
  C. SYSAUX
  D. EXAMPLE
  E. SAMPLE
  A. USERS

• Question 139:

  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
  A. A base catalog exists

• Question 140:

  You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the

  activity.

  How would you achieve this?

  A. Implement job classes
  B. Implement Scheduler windows
  C. Implement the mapping rule for the consumer groups
  D. Set the SWITCH_TIME resource plan directive for both the resource plans
  B. Implement Scheduler windows