Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 141:

  

  View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN session:

  RMAN> BACKUP DATABASE FILESPERSET 2;

  The database has seven data files. Why is the value of %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?

  A. Because the progress is reported for each data file
  B. Because the progress is reported for each backup set
  C. Because other RMAN sessions have issued the same BACKUP command
  D. Because new data files have been added to the database while the RMAN backup is in progress
  B. Because the progress is reported for each backup set

• Question 142:

  You are managing a 24*7 database. The backup strategy for the database is to perform user- managedbackups.

  Identify two prerequisites to perform the backups. (Choose two.)

  A. The database must be opened in restricted mode.
  B. The database must be configured to run in ARCHIVELOG mode.
  C. The tablespaces are required to be in backup mode before taking the backup.
  D. The tablespaces are required to be in read-only mode before taking the backup
  B. The database must be configured to run in ARCHIVELOG mode.
  C. The tablespaces are required to be in backup mode before taking the backup.

• Question 143:

  The EMP table exists in your schema. You want to execute the following query:

  SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN';

  What are the minimum requirements for the statement to execute successfully? (Choose all that apply)

  A. ARCHIVELOG mode must be enabled
  B. Row Movement must be enabled for the table
  C. FLASHBACK must be set to ON for the database
  D. The UNDO_MANAGEMENT parameter must be set to AUTO
  E. The UNDO_RETENTION parameter must be set appropriately
  D. The UNDO_MANAGEMENT parameter must be set to AUTO
  E. The UNDO_RETENTION parameter must be set appropriately

• Question 144:

  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.
  B. The changes made to the table are not committed.

• Question 145:

  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
  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

• Question 146:

  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
  A. SORT_AREA_SIZE
  B. HASH_AREA_SIZE
  C. BITMAP_MERGE_AREA_SIZE
  D. CREATE_BITMAP_AREA_SIZE

• Question 147:

  You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true?

  A. You must ensure that the SALES database is mounted or open.
  B. You must restore a backup control file to perform a block media recovery.
  C. You must take the tools01.dbf data file offline before you start a block media recovery.
  D. You must put the database in NOARCHIVELOG mode to perform a block media recovery.
  E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.
  A. You must ensure that the SALES database is mounted or open.
  E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.

• Question 148:

  Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

  A. It is a copy or a subset of the target database.
  B. It is opened in RESTRICT mode after a duplicating operation.
  C. It is created by using backups and archived redo log files from the target database.
  D. It is created with the same database identifier (DBID) as that of target database.
  A. It is a copy or a subset of the target database.
  C. It is created by using backups and archived redo log files from the target database.