Oracle Oracle Certifications 1Z0-034 Questions & Answers

• Question 1:

  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

  Correct Answer: DE

• Question 2:

  The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between

  10:00

  PM and 11:00 PM does not show this performance problem. What would you suggest to analyze this performance problem for the user?

  A.

  SQL Tuning Advisor

  B.

  SQL Performance Analyzer

  C.

  Active Session History report

  D.

  AWR Compare Periods report

  Correct Answer: C

• Question 3:

  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

  Correct Answer: BD

• Question 4:

  Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:

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

  Which statement is true about the duplicate database in this scenario?

  A. It contains data till the last backup

  B. It contains all data from target database until the current time C. It contains all data from only the committed transactions in the target database

  D. It contains all data except that which is used by the transactions in the current online redo file of target database

  Correct Answer: D

• Question 5:

  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.

  Correct Answer: C

• Question 6:

  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

  Correct Answer: CD

• Question 7:

  You executed the following query:

  SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

  A. The time when the last flashback operation in your database was performed

  B. The time when the first flashback operation in your database was performed

  C. The approximate time and the lowest system change number (SCN) to which you can flash back your database

  D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

  Correct Answer: C

• Question 8:

  You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.

  A. The data file backup is done with multiple channels

  B. The data files is in the read-write mode after being backed up in the read only mode

  C. The backup was taken after the data files was taken offline-normal or is in the read only mode

  D. The data file backup complies with the back retention policy and the backup duplexing feature

  Correct Answer: CD

• Question 9:

  Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production database to anther host, SHOST2, for testing new applications. After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?

  A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files

  B. Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the location

  C. Restoring the server parameter file from the backup by using the recovery catalog to restore,

  D. Restoring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.

  Correct Answer: A

• Question 10:

  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

  Correct Answer: B