Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 431:

  What is the purpose of the recover command? (Choose all that apply.)

  A. Recover database datafiles from physical disk backup sets.
  B. Recover required incremental backups from physical disk backup sets.
  C. Recover required archived redo logs from physical disk backup sets.
  D. Apply incremental backups to recover the database.
  E. Apply archived redo logs to recover the database.
  B. Recover required incremental backups from physical disk backup sets.
  C. Recover required archived redo logs from physical disk backup sets.
  D. Apply incremental backups to recover the database.
  E. Apply archived redo logs to recover the database.

• Question 432:

  Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database? (Choose Two)

  A. Creating the control file for the duplicate database
  B. Restoring the target data files to the duplicate database
  C. Performing complete recovery using all available backups
  D. Generating a new, unique DBID for the duplicate database
  E. Copying the online redo log files from the target database to the duplicate database
  C. Performing complete recovery using all available backups
  E. Copying the online redo log files from the target database to the duplicate database

• Question 433:

  Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

  A. The amount of undo retained is user controlled.
  B. SecureFile LOBs can be used only for nonpartitioned tables.
  C. Fragmentation is minimized by using variable-sized chunks dynamically.
  D. SecureFile encryption allows for random reads and writes of the encrypted data.
  E. It automatically detects duplicate LOB data and conserves space by storing only one copy.
  C. Fragmentation is minimized by using variable-sized chunks dynamically.
  D. SecureFile encryption allows for random reads and writes of the encrypted data.
  E. It automatically detects duplicate LOB data and conserves space by storing only one copy.

• Question 434:

  When performing a full database disaster recovery with RMAN, in what order would you execute these steps?

  a.

  Restore the control file from autobackups.

  b.

  Run the RMAN restore and recover command.

  c.

  Restore the database spfile from autobackups.

  d.

  Make the RMAN backup set pieces available.

  e.

  Open the database with the alter database open resetlogs command.

  f.

  Open the database with the alter database open command.

  A. a, b, c, d, e, f
  B. c, d, a, b, f
  C. d, c, a, b, f
  D. d, b, d, c, e
  E. d, c, a, b, e
  E. d, c, a, b, e

• Question 435:

  To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters? (Choose all that apply.)

  A. DB_CACHE_SIZE
  B. SHARED_POOL_SIZE
  C. LARGE_POOL_SIZE
  D. JAVA_POOL_SIZE
  E. SGA_MAX_SIZE
  F. SORT_AREA_SIZE
  A. DB_CACHE_SIZE
  B. SHARED_POOL_SIZE
  C. LARGE_POOL_SIZE
  D. JAVA_POOL_SIZE

• Question 436:

  Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

  A. Only one I/O calibration process can run at a time.
  B. It automates the resource allocation for the Automated Maintenance Tasks.
  C. It improves the performance of the performance-critical sessions while running.
  D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
  E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
  A. Only one I/O calibration process can run at a time.
  D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
  E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

• Question 437:

  Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

  A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
  B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
  C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
  D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
  C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
  D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

• Question 438:

  You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

  A. Edit the automatic maintenance window group configuration.
  B. Set the CURSOR_SHARING parameter to EXACT for the database instance.
  C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.
  D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
  C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.

• Question 439:

  You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.

  Which type of backup should you perform?

  A. standard backup set
  B. image copy
  C. compressed backup
  D. user-managed backup
  C. compressed backup

• Question 440:

  If two windows overlap, which window attribute will determine whether one should be chosen over the other?

  A. WINDOW_PRIORITY
  B. PRIORITY
  C. PRIORITY_LEVEL
  D. WINDOW_PRIORITY_LEVEL
  E. OVERLAP_RULE
  A. WINDOW_PRIORITY