Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 51:

  The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?

  A. The Oracle database will perform block checking for the index blocks only

  B. The Oracle database will not perform block checking for any of the data blocks

  C. The Oracle database will perform block checking for the default permanent tablespace only

  D. The Oracle database will perform block checking for the data blocks in all user tablespaces

  E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

  Correct Answer: E

• Question 52:

  In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:

  

  Which statement is true about the outcome?

  A. Only one channel is allocated and the backup is created in the flash recovery area

  B. Only one channel is allocated and the backup is created in the destination specified for channel

  C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

  D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

  Correct Answer: A

• Question 53:

  Which statement is true regarding virtual private catalogs?

  A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.

  B. The virtual private catalog owner cannot create and modify the stored scripts.

  C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

  D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

  Correct Answer: D

• Question 54:

  You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?

  A. A base catalog exists

  B. The recovery catalog is empty

  C. The base recovery catalog must be dropped

  D. A target database is registered in the recovery catalog

  Correct Answer: A

• Question 55:

  You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.

  You executed the following RMAN commands:

  RMAN> CONNECT CATALOG rco11/password@catdb

  RMAN> IMPORT CATALOG rcat10/oracle@inst1;

  What happens when you execute the above commands? (Choose all that apply.)

  A. They deregister all databases registered in the RCAT10 catalog.

  B. They import metadata for all registered databases in the RCAT10 database.

  C. They register all the RCAT10-catalog registered databases in the RCO11 catalog.

  D. They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.

  Correct Answer: ABC

• Question 56:

  Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

  A. configuring control file autobackup to be ON

  B. backing up data filed only and not the archived redo log files

  C. running the recovery catalog database in NOARCHIVELOG mode.

  D. setting the retention policy to a REDUNDANCY value greater than 1

  E. backing up the recovery catalog to the same disk as that of the target database

  Correct Answer: AD

  Refer to here.

  Configuring the Recovery Catalog Database

  When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog.

  Decide which database you will use to install the recovery catalog schema, and also how you will back up this database. Also, decide whether to operate the catalog database in ARCHIVELOG mode, which is recommended.

  Note: Do not use the target database to be backed up as the database for the recovery catalog. The recovery catalog must be protected if the target database is lost.

• Question 57:

  In your production database, you: Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals Set the control file autobackup to "on" Are maintaining image copies of the database files

  You have lost the server parameter file (SPFILE) and the control file.

  Which option must you consider before restoring the SPFILE and the control file by using the control file autobackup?

  A. Setting DBID for the database

  B. Using the RMAN SWITCH command

  C. Using the RMAN SET NEWNAME command

  D. Starting up the database instance in the NOMOUNT state

  Correct Answer: D

• Question 58:

  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

  Correct Answer: BD

• Question 59:

  You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape. What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?

  A. register database

  B. recover catalog

  C. load backupset

  D. synch metadata

  E. catalog start with

  Correct Answer: E

  

  Use the CATALOG command to do the following:

  Add backup pieces and image copies on disk to the RMAN repository Record a data file copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy START WITH

  'string_pattern' Catalogs all valid backup sets, data file and control file copies, and archived redo log files whose name start with string_pattern. The string pattern can be an ASM disk group, Oracle-managed files directory, or part of a file

  name (see Example 2-32). RMAN reports any files in the disk location that it cannot catalog. RMAN must be connected to a mounted target database.

  If the string pattern specifies a file name, then it matches the left part of the file name pattern. For example, / tmp/arc matches everything in directory /tmp/arc_dest and /tmp/archive/january as well as file /tmp/arc.cpy. Note: You cannot use

  wildcard characters in the string pattern, only a strict prefix.

• Question 60:

  Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN). (Choose two.)

  A. You can use RMAN stored scripts.

  B. Recovery is faster if data is stored in catalog in addition to the control file.

  C. You can store backup Information of all registered databases in one place.

  D. Database backups are automatically deleted when they are older than the specified time period.

  Correct Answer: AC