Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 11:

  As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?

  A. Shut down the database

  B. Clear the online redo log

  C. Back up the database

  D. Checkpoint the database

  E. Call Oracle support

  Correct Answer: D

• Question 12:

  You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?

  A. Enable the flash recovery area and specify it as the archived redo log destination.

  B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

  C. Enable the flash recovery area but do not specify it as the archived redo log destination.

  D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

  Correct Answer: A

• Question 13:

  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

  Correct Answer: BCE

• Question 14:

  While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.

  A. An entry is created in the alert log file and the database instance continues to function normally

  B. The log switch hangs occur for transactions until free space is available in the flash recovery area

  C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area

  D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

  Correct Answer: BC

• Question 15:

  View the Exhibit and examine the Data Pump architecture. Identify the numbered components.

  

  A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API

  B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader

  C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump

  D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump

  Correct Answer: A

• Question 16:

  The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.

  Which option of Data Pump Import would you use to accomplish this?

  A. owner

  B. touser

  C. attach

  D. remap_schema

  Correct Answer: D

• Question 17:

  The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted.

  What steps should you take to recover from this tempfile loss in an efficient manner?

  A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

  B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

  C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

  D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

  Correct Answer: D

• Question 18:

  To enable faster incremental backups, you enabled block change tracking for the database.

  Which two statements are true about the block change tracking file? (Choose two.)

  A. Multiple change tracking files can be created for a database.

  B. The change tracking file must be created after the first level 0 backup.

  C. RMAN does not support backup and recovery of the change tracking file.

  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

  Correct Answer: CD

• Question 19:

  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

  Correct Answer: CD

• Question 20:

  Which statement is true regarding the VALIDATE DATABASE command?

  A. It checks the database for intrablock corruptions only.

  B. It checks for block corruption in the valid backups of the database.

  C. It checks the database for both intrablock and interblock corruptions.

  D. It checks for only those corrupted blocks that are associated with data files.

  Correct Answer: A

  interblock corruption

  A type of block corruption in which the corruption occurs between blocks rather than within the block itself.

  This type of corruption can only be logical corruption. intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption