Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 201:

  A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following Error message:

  

  Which is the recommended sequence of operations you need to perform for the query successfully?

  A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.

  B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.

  C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

  D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

  Correct Answer: C

  It supposed to none of answer is correct.

• Question 202:

  You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:

  1.

  Put the tablespaces in backup mode.

  2.

  Back up the datafiles for all tablespaces.

  3.

  Take the tablespaces out of backup mode.

  4.

  Back up all archived redo logs.

  Your colleague asks for you to comment on his plan. Which response would be correct?

  A. The plan will work as is.

  B. The plan needs to be modified to allow for an archive-log switch after step 3.

  C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.

  D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.

  E. The plan cannot work as presented.

  Correct Answer: B

  Without command ALTER SYSTEM SWITCH LOGFILE, the backup of archive redo logs will be useless.

• Question 203:

  Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?

  A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode.

  B. Datafiles are not written to during hot backups.

  C. Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

  D. The datafile headers are not updated during the backup.

  E. The way data is written to the online redo logs is unchanged during the backup.

  Correct Answer: D

• Question 204:

  You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?

  1.

  Take the datafiles that were lost offline.

  2.

  startup mount the database

  3.

  Issue the alter database open command.

  4.

  Restore the datafiles that were lost

  5.

  Recover the datafiles with the recover datafile command.

  6.

  Bring the datafiles back online.

  7.

  Recover the database with the recover database command.

  A. 2, 1, 3, 4, 5, 6

  B. 2, 4, 5, 3

  C. 4, 7, 3

  D. 2, 4, 7, 3

  E. 2, 7, 3

  Correct Answer: B

• Question 205:

  You executed the following commands in an RMAN session for your database instance that has failures:

  RMAN> LIST FAILURE;

  After some time, you executed the following command in the same session:

  RMAN> ADVISE FAILURE;

  But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command.

  Which statement is true for the above ADVISE FAILURE command in this scenario?

  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

  B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

  C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

  D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

  Correct Answer: A

• Question 206:

  You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog.

  You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.

  So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

  

  A. B. C. D.

  Correct Answer: A

• Question 207:

  In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this:

  1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy

  Which two options illustrate the correct sequence of steps that you could follow? (Choose two.)

  A. 2, 6, 4, 5, 3

  B. 1, 2, 4, 5, 3, 6

  C. 1, 2, 4, 6, 3

  D. 1, 2, 7, 5, 3, 6

  Correct Answer: BD

• Question 208:

  Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member.

  When you attempt to start the database, you receive the following errors:

  ORA-00313: open failed for members of log group 1 of thread 1

  ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'

  You discover that the online redo log file of the current redo group is corrupted.

  Which statement should you use to resolve this issue?

  A. ALTER DATABASE DROP LOGFILE GROUP 1;

  B. ALTER DATABASE CLEAR LOGFILE GROUP 1;

  C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

  D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';

  Correct Answer: C

• Question 209:

  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.

  Correct Answer: BC

• Question 210:

  Which components are needed for successful and most efficient recovery.

  A. The backup RB3 and the current online redo log files

  B. the backup RB2 and the archived redo log files after the log sequence number 15622

  C. Backup R81 and the archived redo log hies after the log sequence number 12871

  D. The backup RB3 and the archived redo log files after the log sequence number 16721

  Correct Answer: A