Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 261:

  What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?

  A. TS_CHECK

  B. TPITR_CHECK

  C. TS_PITR_CHECK

  D. CHECK_TSPITR

  E. PITR_TS_CHECK

  Correct Answer: C

• Question 262:

  Which command would correctly start a TSPITR of the USERS tablespace?

  

  A. B. C. D. E.

  Correct Answer: E

• Question 263:

  What RMAN command is used to execute a tablespace point-in-time recovery?

  A. recover

  B. duplicate

  C. restore

  D. copy

  E. None of the above

  Correct Answer: A

• Question 264:

  Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?

  A. New channels for restore and recovery tasks

  B. New name for the data files of the tablespace

  C. Auxiliary name for the data files of the tablespace

  D. Auxiliary destinations for an auxiliary set of data files

  Correct Answer: D

• Question 265:

  In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.

  Which method must you use to recover the lost data?

  A. Complete Recovery with online redo log

  B. Complete Recovery with archived redo log

  C. Tablespace Point-in-Time Recovery (TSPITR)

  D. Incomplete Recovery with system change number (SCN)

  Correct Answer: C

• Question 266:

  Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.

  Which two actions will permit the TSPITR to work? (Choose two.)

  A. Taking the MASTERTBS tablespace offline

  B. Dropping the relationship between the tables

  C. Adding the MASTERTBS tablespace to the recovery set

  D. Putting the MASTERTBS tablespace in read-only mode

  Correct Answer: BC

• Question 267:

  You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)

  A. The source database backup must be copied over the net for test database.

  B. The source database must be run in ARCHIVELOG mode if the database is open.

  C. The source database must be shut down cleanly if the database is in mounted state.

  D. A net service name should be set up and a listener configured with the target as well as the source database.

  Correct Answer: BCD

  To ensure that the source database is in the proper state:

  1.

  If the source database instance is not mounted or open, then mount or open it.

  2.

  If you are performing active database duplication, then ensure that the following additional requirements are met:

  If the source database is open, then archiving must be enabled. If the source database is not open, then the database does not require instance recovery. (Tips: does not require instance recovery, means you cannot shutdown the source database with abort option, you need to shutdown it cleanly.)

  Starting RMAN and Connecting to Databases:

  In this task, you must start the RMAN client and connect to the database instances required by the duplication technique chosen in "Step 1: Choosing a Duplication Technique". The RMAN client can be located on any host so long as it can

  connect to the necessary databases over the network.

• Question 268:

  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.

  Correct Answer: A

• Question 269:

  Examine the following command for RMAN backup:

  RMAN> RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

  BACKUP

  INCREMENTAL LEVEL = 0

  (DATAFILE 1,4,5 CHANNEL c1)

  (DATAFILE 2,3,9 CHANNEL c2)

  (DATAFILE 6,7,8 CHANNEL c3);

  SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

  Which statement Is true regarding the approach in the command?

  A. The RMAN multiplexing level is 4.

  B. It is the use of asynchronous I/O by RMAN.

  C. It is a case of parallelization of the backup set.

  D. It is an implementation of a multisection backup.

  Correct Answer: C

• Question 270:

  You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN): RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

  Identify the statement that correctly describes the implications of this command.

  A. when there are already three backups, for the fourth backup RMAN removes the oldest backup.

  B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

  C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulative backups.

  D. when there are already three backup, one of the existing backups must be removed manually before taking the fourth backup.

  Correct Answer: B

  Configuring a Redundancy-Based Retention Policy

  The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command specifies how many full or level 0 backups of each data file and control file that RMAN should keep. If the number of full or level 0 backups for a specific data file or control file exceeds the REDUNDANCY setting, then RMAN considers the extra backups as obsolete. The default retention policy is REDUNDANCY 1.

  As you produce more backups, RMAN keeps track of which ones to retain and which are obsolete. RMAN retains all archived logs and incremental backups that are needed to recover the nonobsolete backups.

  Assume that you make a full backup of data file 7 on Monday, Tuesday, Wednesday, and Thursday. You now have four full backups of this data file.If REDUNDANCY is 2, then the Monday and Tuesday backups are obsolete. If you make another backup on Friday, then the Wednesday backup of data file 7 becomes obsolete. Assume a different case in which REDUNDANCY is 1. You run a level 0 database backup at noon on Monday, a level 1 cumulative backup at noon on Tuesday and Wednesday, and a level 0 backup at noon on Thursday. Immediately after each daily backup you run the command DELETE OBSOLETE. The Wednesday DELETE command does not remove the Tuesday level 1 backup because this backup is not redundant: the Tuesday level 1 backup could be used to recover the Monday level 0 backup to a time between noon on Tuesday and noon on Wednesday. However, the DELETE command on Thursday removes the previous level 0 and level 1 backups. Run the CONFIGURE RETENTION POLICY command at the RMAN prompt, as in the following example: CONFIGURE RETENTION POLICY TO REDUNDANCY