Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 461:

  Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

  

  A. Implement RMAN multiplexing
  B. Set the DEBUG ON in the RMAN script
  C. Specify the command ID in the RMAN script
  D. Use a tag with the RMAN BACKUP command
  C. Specify the command ID in the RMAN script

• Question 462:

  Which of the following is a benefit of ASM fast disk resync?

  A. Failed disks are taken offline immediately but are not dropped.
  B. Disk data is never lost.
  C. By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
  D. The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
  E. Hot spare disks are automatically configured and added to the disk group.
  A. Failed disks are taken offline immediately but are not dropped.

• Question 463:

  Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.

  Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

  A. Define the POWER option while adding or removing the disks.
  B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
  C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
  D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.
  A. Define the POWER option while adding or removing the disks.
  B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

• Question 464:

  What is the impact of the results of the output of the following command?

  RMAN> report unrecoverable database; Report of files that need backup due to unrecoverable operations File Type of Backup Required Name ---- ----------------------- ----------------------------------- 4 full or incremental C:\ORACLE\ORADATA\ORCL \USERS01.DBF

  A. There are no backup sets with any backups of the users01.dbf datafile.
  B. The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
  C. The users01.dbf datafile is corrupted.
  D. The users01.dbf datafile backup exceeds the retention criteria.
  E. The last backup of the users01.dbf datafile failed and must be rerun.
  D. The users01.dbf datafile backup exceeds the retention criteria.

• Question 465:

  Which of the following is not a configurable attribute for an individual disk group?

  A. AU_SIZE
  B. COMPATIBLE.RDBMS
  C. COMPATIBLE.ASM
  D. DISK_REPAIR_TIME
  E. DG_DROP_TIME
  E. DG_DROP_TIME

• Question 466:

  Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?

  A. RSTLNE
  B. NLSRTL
  C. LISTENER
  D. NLSSORT
  E. Linguistic sorts
  B. NLSRTL

• Question 467:

  What does the output on this report indicate?

  

  A. The my_data_01.dbf datafile is corrupted and needs to be restored.
  B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
  C. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
  D. The my_data_01.dbf datafile no longer meets the retention criteria for backups.
  E. Datafile 5 is missing.
  B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.

• Question 468:

  You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?

  A. You must have change tracking enabled in your database
  B. Your database must be running in NOARCHIVELOG mode
  C. To back up a tablespace, it must be in backup mode
  D. To back up a tablespace, it must first be taken offline
  C. To back up a tablespace, it must be in backup mode

• Question 469:

  You are managing a 24*7 database. The backup strategy for the database is to perform user- managed backups. Identify two prerequisites to perform the backups. (Choose two.)

  A. The database must be opened in restricted mode.
  B. The database must be configured to run in ARCHIVELOG mode.
  C. The tablespaces are required to be in backup mode before taking the backup.
  D. The tablespaces are required to be in read-only mode before taking the backup
  B. The database must be configured to run in ARCHIVELOG mode.
  C. The tablespaces are required to be in backup mode before taking the backup.

• Question 470:

  Which is NOT a valid way of backing up a control file?

  A. Backing up the control file to trace
  B. Copying the existing control file of the database to the backup location during a hot backup
  C. Copying the existing control file of the database to the backup location during a cold backup
  D. Creating a backup control file
  E. Using the create controlfile command
  B. Copying the existing control file of the database to the backup location during a hot backup