Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 31:

  You are trying to recover your database. During the recovery process, you receive the following error:

  ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1 ORA-00289:

  suggestion: /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 / o1_mf_1_11_%u_.arc ORA-00280: change 5033391 for thread 1 is in sequence #11 ORA-00278: log file '/oracle01/flash_recovery_area/ORCL/

  archivelog/2008_08_17 / o1_mf_1_10_4bj6wnqm_.arc' no longer needed for this recovery Specify log:

  {=suggested | filename | AUTO | CANCEL}

  ORA-00308: cannot open archived log '/oracle01/flash_recovery_area/ORCL/ archivelog/2008_08_17 /o1_mf_1_11_%u_.arc'

  ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3

  How do you respond to this error? (Choose two.)

  A. Restore the archived redo log that is missing and attempt recovery again.
  B. Recovery is complete and you can open the database.
  C. Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.
  D. Recover the entire database and apply all archived redo logs again.
  E. Recovery is not possible because an archived redo log has been lost.
  A. Restore the archived redo log that is missing and attempt recovery again.
  C. Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.

• Question 32:

  You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value.

  Which of these actions is appropriate?

  A. Abort the session, fix the space problem, then resubmit the transaction.
  B. Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend the time-out for the session while you fix the problem.
  C. Do nothing, let the transaction fail, then fix the problem.
  D. Use Segment Shrink to clean up the table.
  E. Use the DBMS_RESUMABLE.SET_TIMEOUT procedure to extend the time-out for the session while you fix the problem.
  B. Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend the time-out for the session while you fix the problem.

• Question 33:

  Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:

  RESTORE CONTROLFILE FROM AUTOBACKUP;

  Which of the following statements is true? (Choose all that apply.)

  A. The command restores only the missing control file.
  B. The command restores all the control files.
  C. The command fails because the database is running.
  D. This is the correct way to address this problem.
  E. This is not the correct way to address this problem.
  C. The command fails because the database is running.
  E. This is not the correct way to address this problem.

• Question 34:

  You issued the following RMAN command to back up the database:

  RMAN> RUN{ ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE TAG quarterly KEEP FOREVER RESTORE POINT FY06Q4; }

  Which two statements are true regarding the backup performed? (Choose two.)

  A. Archived redo log files are backed up along with data files.
  B. Only data files are backed up and a restore point named FY06Q4 is created.
  C. Archived log files are backed up along with data files, and the archived log files are deleted.
  D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
  A. Archived redo log files are backed up along with data files.
  D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

• Question 35:

  View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

  What is the reason for this error?

  Exhibit:

  

  A. Another repair session is running concurrently.
  B. The failure ID has not been mentioned in the command for data file 5.
  C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
  D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
  A. Another repair session is running concurrently.

• Question 36:

  What methods are available to recover lost control files? (Choose all that apply.)

  A. Backup control file.
  B. Emergency control file.
  C. The create controlfile command.
  D. The restore controlfile SQL*Plus command.
  E. No backup is required. The database will re-create the control file when it is discovered to be lost.
  A. Backup control file.
  C. The create controlfile command.

• Question 37:

  The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.

  One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:

  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

  Which action should you perform immediately after using this command?

  A. You should perform a log switch
  B. You should make a backup of the database
  C. You should switch the database to the NOARCHIVELOG mode
  D. You should shut down the database instance and perform a complete database recovery
  B. You should make a backup of the database

• Question 38:

  In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?

  A. VARCHAR2
  B. CHAR
  C. NVARCHAR2
  D. CLOB
  E. LONG
  C. NVARCHAR2

• Question 39:

  You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.

  Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

  A. Change the RMAN archived log deletion policy.
  B. Use the RMAN CROSSCHECK command to reclaim the archived log space.
  C. Change the RMAN retention policy to retain backups for a shorter period of time.
  D. Use OS command to move files from the flash recovery area to some other location
  B. Use the RMAN CROSSCHECK command to reclaim the archived log space.
  D. Use OS command to move files from the flash recovery area to some other location

• Question 40:

  Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?

  A. Workload capture is per instance.
  B. You only need to restart one instance to begin workload capture.
  C. Specifically in RAC, you shut down all instances, restart them individually, and begin workload capture with the last instance started.
  D. RAC does not support workload capture, but it does support workload replay.
  E. None of the above.
  E. None of the above.