Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 561:

  The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task.

  What is the reason for this?

  A. to prevent the creation of an excessive number of scheduler job classes
  B. to allow the Automated Maintenance Tasks to use system resources without any restriction
  C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
  D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
  D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

• Question 562:

  You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape. What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?

  A. register database
  B. recover catalog
  C. load backupset
  D. synch metadata
  E. catalog start with
  E. catalog start with

• Question 563:

  Which RMAN backup command is used to create the block-change tracking file?

  A. alter database create block change tracking file
  B. alter database enable block change file
  C. alter database enable block change tracking using file '/ora01/opt/block_change_tracking.fil'
  D. alter system enable block change tracking using file '/ora01/opt/block_ change_tracking.fil'
  E. alter system block change tracking on
  C. alter database enable block change tracking using file '/ora01/opt/block_change_tracking.fil'

• Question 564:

  The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. The RVPC user can do which of the following? (Choose all that apply.)

  A. Register databases if granted the register database privilege
  B. See all databases in the recovery-catalog schema
  C. See all database-related metadata in the recovery catalog if they are granted access to that database
  D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command
  E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
  A. Register databases if granted the register database privilege
  C. See all database-related metadata in the recovery catalog if they are granted access to that database

• Question 565:

  View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

  RMAN> REPAIR FAILURE;

  Which statement describes the consequence of the command?

  Exhibit:

  

  A. The command performs the recovery and closes the failures.
  B. The command only displays the advice and the RMAN script required for repair.
  C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
  D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
  C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

• Question 566:

  Performance divergence indicated in the Workload Replay report is most likely due to what?

  A. DML and SQL statement results that do not match between the capture and replay systems
  B. When errors that occur in the capture system don't occur in the replay system
  C. Top SQL statements
  D. Infrastructure or system-configuration differences
  E. Time-of-day differences between capture and replay systems
  D. Infrastructure or system-configuration differences

• Question 567:

  Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

  A. Differential incremental backup
  B. Different incremental backup
  C. Cumulative backup
  D. Cumulative incremental backup
  A. Differential incremental backup

• Question 568:

  View the Exhibit to examine the replay settings for replay parameters.

  What is the implication for setting the values for replay parameters? (Choose all that apply.)

  Exhibit:

  

  A. The COMMIT order in the captured workload is preserved during replay.
  B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
  E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
  A. The COMMIT order in the captured workload is preserved during replay.
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

• Question 569:

  You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch.

  What do you do?

  A. Take the whole disk group offline and wait for the controller card to be installed. Once it's installed, bring the disk group online again.
  B. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced, reset the parameter to its original value.
  C. You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.
  D. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group, you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.
  E. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
  E. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

• Question 570:

  Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they don't want you to shut down the database to perform the backup. What options are available to you?

  A. Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.
  B. Just back up the database datafiles without shutting down the database.
  C. You will have to wait until you can shut down the database to perform the backup.
  D. Mark each datafile as backup in progress, back them up individually, and then mark them as backup not in progress. No archived redo logs will need to be backed up.
  E. Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing, you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
  C. You will have to wait until you can shut down the database to perform the backup.