Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 91:

  You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:

  1.

  Restore an autobackup of the server parameter file.

  2.

  Restore the control file

  3.

  Start the target database instance

  4.

  Mount the database

  5.

  Restore the data files

  6.

  Open the database with RESETLOGS option

  7.

  Recover the data files

  8.

  Set DBID for the target database

  Which option illustrates the correct sequence that you must use?

  A. 8, 1, 3, 2, 4, 5, 7, 6
  B. 1, 8, 3, 4, 2, 5, 7, 6
  C. 1, 3, 4, 2, 8, 5, 6, 7
  D. 1, 3, 2, 4, 6, 5, 7, 8
  A. 8, 1, 3, 2, 4, 5, 7, 6

• Question 92:

  As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the source database are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.

  Which of the following steps are required to transport a tablespace from the database to the targetdatabase:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Convert data filed by using Recovery Manager (RMAN).

  4.

  Transfer the dump file and data filed to the target machine.

  5.

  Import metadata at the target database.

  6.

  Make the tablespace read/write at the target database. Exhibit:

  

  A. 2, 4, and 5
  B. All the steps
  C. 2, 3, 4 and 5
  D. 1, 2, 4, 5 and 6
  D. 1, 2, 4, 5 and 6

• Question 93:

  Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

  A. The ADR base keeps all diagnostic information in binary format
  B. SQL*Plus provides the ADRI script, which can be used to work with ADR
  C. The ADR can be used for problem diagnosis only when the database is open
  D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
  E. The ADR can be used for problem diagnosis even when the database instance is down
  F. The ADR base is shared across multiple instances
  E. The ADR can be used for problem diagnosis even when the database instance is down
  F. The ADR base is shared across multiple instances

• Question 94:

  Which statement is true about a Scheduler-generated event?

  A. It can be generated when a file arrives on the file system.
  B. it indicates state changes that occur within the Scheduler itself.
  C. it is raised by an application that is consumed by the Scheduler to start a job.
  D. it requires jobs to be defined with an event condition and a queue specification.
  D. it requires jobs to be defined with an event condition and a queue specification.

• Question 95:

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

  What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

  A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
  B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
  C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
  D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space
  C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

• Question 97:

  View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:

  SQL> startup

  ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

  Why did the instance fail to start?

  Exhibit:

  

  A. Because the PGA_AGGREGATE_TARGET parameter is not set
  B. Because the STATISTICS_LEVEL parameter is set to BASIC
  C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
  D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
  B. Because the STATISTICS_LEVEL parameter is set to BASIC

• Question 98:

  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 multisection backup.
  C. It is a case of parallelization of the backup set.

• Question 99:

  Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

  A. configuring control file autobackup to be ON
  B. backing up data filed only and not the archived redo log files
  C. running the recovery catalog database in NOARCHIVELOG mode.
  D. setting the retention policy to a REDUNDANCY value greater than 1
  E. backing up the recovery catalog to the same disk as that of the target database
  A. configuring control file autobackup to be ON
  D. setting the retention policy to a REDUNDANCY value greater than 1

• Question 100:

  You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.

  Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

  A. Change the RMAN archived log deletion policy.
  B. Use the RMAN CROSSCHECK command to reclaim the archived log space.
  C. Change the RMAN retention policy to retain backups for a shorter period of time.
  D. Use OS command to move files from the flash recovery area to some other location
  B. Use the RMAN CROSSCHECK command to reclaim the archived log space.
  D. Use OS command to move files from the flash recovery area to some other location