Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online 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
  D. The UNDO_MANAGEMENT parameter must be set to AUTO
  E. The UNDO_RETENTION parameter must be set appropriately

• Question 2:

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

  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
  C. Active Session History report

• 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
  D. It contains all data except that which is used by the transactions in the current online redo file of target database

• Question 5:

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

  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 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
  C. The approximate time and the lowest system change number (SCN) to which you can flash back your database

• Question 8:

  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.
  A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files

• Question 9:

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

• Question 10:

  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
  A. A job chain can contain a nested chain of jobs.
  C. A job of the CHAIN type can be run using event-based or time-based schedules.