Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 61:

  Which of the following are correct about block media recovery? (Choose all that apply.)

  A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.
  B. Logical corruptions are repairable by BMR.
  C. Physical corruptions are repairable by BMR.
  D. RMAN can use any backup for a BMR restore.
  E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore.
  A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.
  C. Physical corruptions are repairable by BMR.

• Question 62:

  You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)

  A. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
  B. The KEEP option overrides the configured retention policy.
  C. The backup contains only data files and archived redo log files.
  D. The KEEP option is an attribute of an individual backup piece.
  A. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
  B. The KEEP option overrides the configured retention policy.

• Question 63:

  You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the

  DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

  ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';

  To which disks in the disk group will the new value be applicable?

  A. all disks in the disk group
  B. all disks that are currently in OFFLINE mode
  C. all disks that are not currently in OFFLINE mode
  D. all disks in the disk group only if all of them are ONLINE
  C. all disks that are not currently in OFFLINE mode

• Question 64:

  Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

  A. The user has dropped an important table that needs to be recovered.
  B. The database files are corrupted when the database is open.
  C. You are not able to start up the database instance because the required database files are missing.
  D. The archived log files are missing for which backup is not available.
  B. The database files are corrupted when the database is open.
  C. You are not able to start up the database instance because the required database files are missing.

• Question 65:

  Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

  A. Segment Advisor
  B. SQL Access Advisor
  C. Optimizer statistics gathering
  D. Automatic SQL Tuning Advisor
  E. Automatic Database Diagnostics Monitor
  A. Segment Advisor
  C. Optimizer statistics gathering
  D. Automatic SQL Tuning Advisor

• Question 66:

  Examine the following RMAN command:

  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which prerequisite must be met before accomplishing the backup?

  A. Provide a password for the encryption
  B. Set up an Oracle wallet for the encryption
  C. No setup is required as it is a default encryption method
  D. Both Oracle wallet and password must be set up for the encryption
  B. Set up an Oracle wallet for the encryption

• Question 67:

  In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.)

  A. Ensure that database is running with version 10.1 compatibility.
  B. Enable Flashback Logging.
  C. Enable Supplemental Logging.
  D. Ensure that the database is running with version 10.0 compatibility.
  E. Ensure that the database is in ARCHIVELOG mode
  C. Enable Supplemental Logging.
  D. Ensure that the database is running with version 10.0 compatibility.

• Question 68:

  Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?

  

  A. B. C. D. E.
  E

• Question 69:

  What are the advantages of variable extent size support for large ASM files? (Choose two.)

  A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
  B. It improves performance in the extended cluster configuration by reading from a local copy of an extent.
  C. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
  D. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.
  C. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.
  D. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

• Question 70:

  The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.

  How would you achieve this?

  A. Implement a profile for the users.
  B. Implement external roles for the users.
  C. Set the threshold for the undo tablespace.
  D. Implement a Database Resource Manager plan.
  B. Implement external roles for the users.