Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 51:

  View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.

  Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?

  ASM-disk-group-1 (exhibit):

  

  ASM-disk-group-2 (exhibit):

  

  A. Because the disk group is created with NORMAL redundancy
  B. Because the disk repair time attribute is set to a nonzero value
  C. Because the mirrored extents cannot be rebalanced across the other three disks
  D. Because the other three disks have 60% free space, the disk rebalancing is delayed
  B. Because the disk repair time attribute is set to a nonzero value

• Question 52:

  To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

  A. Multiple change tracking files can be created for a database.
  B. The change tracking file must be created after the first level 0 backup.
  C. RMAN does not support backup and recovery of the change tracking file.
  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
  C. RMAN does not support backup and recovery of the change tracking file.
  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

• Question 53:

  View the Exhibit to observe the error.

  

  You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance. What can you do to reduce the chance of this error in the future?

  A. Increase the value of SGA_MAX_SIZE
  B. Enable automatic memory management
  C. Set the PRE_PAGE_SGA parameter to true
  D. Lock the System Global Area (SGA) in memory
  B. Enable automatic memory management

• Question 54:

  Identify three key features of Oracle Data Pump (Choose three.)

  A. Data Pump can stop a running job and resume it later
  B. Data Pump can perform import using database link
  C. Data Pump uses absolute path instead of relative path
  D. Data Pump uses relative path instead of absolute path
  E. Data Pump can perform incremental and cumulative exports
  A. Data Pump can stop a running job and resume it later
  B. Data Pump can perform import using database link
  D. Data Pump uses relative path instead of absolute path

• Question 55:

  Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

  A. flashback query
  B. distributed transactions
  C. logging in and logging out of sessions
  D. all DDL statements having bind variables
  E. direct path load of data from external files
  C. logging in and logging out of sessions
  D. all DDL statements having bind variables

• Question 56:

  Examine the following RMAN command:

  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which perquisite must be met before accomplishing the backup?

  A. Provide a password for the encryption.
  B. Set up an Oracle wallet for the encryption.
  C. No setup is required as it is a default encryption method.
  D. Both Oracle wallet and password must be set up for the encryption.
  B. Set up an Oracle wallet for the encryption.

• Question 57:

  You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

  A. DATE
  B. TIMESTAMP
  C. INTERVAL YEAR TO MONTH
  D. INTERVAL DAY TO SECOND
  E. TIMESTAMP WITH LOCAL TIME ZONE
  B. TIMESTAMP
  E. TIMESTAMP WITH LOCAL TIME ZONE

• Question 58:

  Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

  A. Flash recovery area must be defined
  B. Undo retention guarantee must be enabled.
  C. Database must be running in archivelog mode.
  D. Automatic undo management must be enabled.
  E. The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).
  D. Automatic undo management must be enabled.
  E. The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).

• Question 59:

  In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?

  A. to change a unique index into a non-unique index
  B. to change index storage options
  C. to enable index monitoring
  D. to move the index to another tablespace
  E. to improve performance of an INDEX CLUSTER
  B. to change index storage options
  D. to move the index to another tablespace

• Question 60:

  Before a Flashback Table operation, you execute the following command:

  ALTER TABLE employees ENABLE ROW MOVEMENT;

  Why would you need this to be executed?

  A. Because row IDs may change during the flashback operation
  B. Because the object number changes after the flashback operation
  C. Because the rows are retrieved from the recycle bin during the flashback operation
  D. Because the table is moved forward and back to a temporary during the flashback opertion
  A. Because row IDs may change during the flashback operation