Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 121:

  Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).

  A. You can use RMAN stored scripts.
  B. Recovery is faster if data is stored in catalog in addition to the control file.
  C. You can store backup information of all registered databases in one place.
  D. Database backups are automatically deleted when they are older than the specified time period.
  A. You can use RMAN stored scripts.
  C. You can store backup information of all registered databases in one place.

• Question 122:

  Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

  A. Alert log file
  B. Archived redo log files
  C. Control file autobackups
  D. Server Parameter file (SPFILE)
  E. Recovery Manager (RMAN) backup piece
  B. Archived redo log files
  C. Control file autobackups
  E. Recovery Manager (RMAN) backup piece

• Question 123:

  You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were

  asked to change the retention from 5 years to 3 years.

  To accomplish this, you issued the following command:

  ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR; What is the implication of this command?

  A. The command produces an error because the retention time cannot be reduced.
  B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
  C. All historical data is purged and the new flashback data archives are maintained for three years.
  D. All historical data older than three years is purged from the flashback archive FLA1.
  D. All historical data older than three years is purged from the flashback archive FLA1.

• Question 124:

  During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?

  A. The installation terminates with an error.
  B. The installation proceeds with the default value without warnings and errors.
  C. The installation proceeds with the default value but it would not be an OFA-compliant database.
  D. The installation proceeds with the default value but a message would be generated in the alert log file.
  D. The installation proceeds with the default value but a message would be generated in the alert log file.

• Question 125:

  You execute these RMAN commands:

  BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?

  A. create a backup of the database and recover all corrupted blocks found in the backup
  B. perform a backup validation and list all logically and physically corrupt blocks in the database
  C. perform a backup validation and populate the memory structure used by the vscopy_corruption view with details of any corrupt blocks found
  D. perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks
  E. create an image copy of the database and recover all corrupted blocks found in the image copy
  D. perform a backup validation and populate the memory structure used by the vsDATABASE_BLOCK_CORRUPTION view, then recover any corrupt blocks

• Question 126:

  You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

  A. The backup as copy can only be taken to disk
  B. The backup as copy can only be taken to tape
  C. Backup can be performed only when the instance is shutdown
  D. Backup will constitute all used and unused blocks in the database
  A. The backup as copy can only be taken to disk
  D. Backup will constitute all used and unused blocks in the database

• Question 127:

  Given below are RMAN commands to enable backup optimization and set the retention policy:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  RMAN> CONFIGURE BACKUP OPTIMIZATION ON;

  RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

  The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday. Viewthe Exhibit to examine the operations performed by using RMAN.

  Which two statements are true about the backup of the USERS tablespace? (Choose two.)

  

  A. It will be backed up as a part of database backup on Friday.
  B. It will be backed up as a part of database backup on Tuesday.
  C. It will not be backed up as a part of database backup on Wednesday.
  D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.
  B. It will be backed up as a part of database backup on Tuesday.
  D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

• Question 128:

  Which data dictionary view would you query to find the name of the default permanent tablespace of the database?

  A. DICTIONARY
  B. DBA_TABLESPACES
  C. DBA_DIRECTORIES
  D. DBA_STORED_SETTINGS
  E. DATABASE_PROPERTIES
  F. DBA_TABLESPACE_GROUPS
  E. DATABASE_PROPERTIES

• Question 129:

  Given below is a list of scenarios:

  1) A user terminates his session abnormally.

  2) The connection between the server and the client application terminates because of a network failure.

  3) A schema is accidentally dropped.

  4) The tablespace is accidentally dropped from the database.

  5) The hard disk gets corrupted and the data files in the disk are lost.

  6) The database instance abnormally shuts down because of power failure.

  Which scenarios require DBA intervention to perform recovery?

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

• Question 130:

  What two are the prerequisites for enabling Flashback Database?

  A. The database must be in ARCHIVELOG mode
  B. The database must be in MOUNT EXCLUSIVE mode
  C. The database must be opened in RESTRICTED mode
  D. The database instance must be started in the NOMOUNT state
  E. The database instance must have the keep buffer pool defined
  A. The database must be in ARCHIVELOG mode
  B. The database must be in MOUNT EXCLUSIVE mode