Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 81:

  You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:

  RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1; Then you issue the following commands:

  RMAN> CONNECT CATALOG vpc1/oracle@catdb;

  RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"

  What is the outcome of the above commands?

  A. They execute and create a virtual catalog for pre-Oracle 11g clients.

  B. They produce an error because PROD1 and PROD2 databases belong to the older version.

  C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

  D. They produce an error because you need to connect to the target database to execute this packaged procedure.

  Correct Answer: A

• Question 82:

  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 commands:

  RMAN> CONNECT CATALOG rco11/password@catdb

  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;

  Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

  A. They import all metadata from the RCAT10 catalog.

  B. They unregister the database from the RCAT10 catalog.

  C. They do not register the databases registered in the RCAT10 catalog.

  D. They register all databases registered in the RCAT10 catalog.

  Correct Answer: AD

  

• Question 83:

  What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

  A. Make backups faster

  B. Store RMAN metadata

  C. Store RMAN scripts

  D. Provide the ability to do centralized backup reporting.

  E. Make recovery faster

  Correct Answer: BCD

  A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. Typically, you store the catalog in a dedicated database. A recovery catalog provides the following benefits:

  A recovery catalog creates redundancy for the RMAN repository stored in the control file of each target database. The recovery catalog serves as a secondary metadata repository. If the target control file and all backups are lost, then the

  RMAN metadata still exists in the recovery catalog.

  A recovery catalog centralizes metadata for all your target databases. Storing the metadata in a single place makes reporting and administration tasks easier to perform.

  A recovery catalog can store metadata history much longer than the control file. This capability is useful if you must do a recovery that goes further back in time than the history in the control file. The added complexity of managing a recovery

  catalog database can be offset by the convenience of having the extended backup history available.

  Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the

  target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.

  A recovery catalog is required when you use RMAN in a Data Guard environment. By storing backup metadata for all primary and standby databases, the catalog enables you to offload backup tasks to one standby database while enabling

  you to restore backups on other databases in the environment.

• Question 84:

  You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command: RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS; After configuring the recovery window, you performed the database backup as follows:

  A. Backup RB1 at log sequence number 12871 on 5th Jan

  B. Backup RB2 at log sequence number 15622 on 12th Jan

  C. Backup RB3 at log sequence 16721 on 15th Jan

  D. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all archived redo log files to date.

  Correct Answer: D

• Question 85:

  You issue the following RMAN command to set a retention policy on a database:

  RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

  What will be the outcome of issuing this command?

  A. After two days, a backup will be marked obsolete

  B. After two days, a backup will be deleted from the media

  C. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

  D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

  Correct Answer: D

• Question 86:

  Examine the following RMAN command:

  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which prerequisite must be met before accomplishing the backup?

  A. Provide a password for the encryption

  B. Set up an Oracle wallet for the encryption

  C. No setup is required as it is a default encryption method

  D. Both Oracle wallet and password must be set up for the encryption

  Correct Answer: B

• Question 87:

  Given below are RMAN commands to enable backup optimization and set the retention policy:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  RMAN> CONFIGURE BACKUP OPTIMIZATION ON;

  RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

  The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday.

  View the Exhibit to examine the operations performed by using RMAN.

  Which two statements are true about the backup of the USERS tablespace? (Choose two.)

  Exhibit:

  

  A. It will be backed up as a part of database backup on Friday.

  B. It will be backed up as a part of database backup on Tuesday.

  C. It will not be backed up as a part of database backup on Wednesday.

  D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

  Correct Answer: BD

  Refer to here.

  Backup Optimization for SBT Backups With Redundancy Retention Policy

• Question 88:

  You issued the following commands to configure setting in RMAN;

  RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

  RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

  Then you issued the following command to take the backup:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which statement is true about the execution of the above command?

  A. The backup will terminate because the FORMAT clause was not configured for the channel

  B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

  C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

  D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

  Correct Answer: D

• Question 89:

  Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

  A. Backup retention policy

  B. Default backup device type

  C. Default destinations for backups

  D. Multiple backup device types for single backup

  E. Default section size for backups

  Correct Answer: ABC

  SECTION SIZE cannot be configured through CONFIGURE command.

• Question 90:

  Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?

  A. Configure backup optimization

  B. Configure the channel to increase MAXOPENFILES

  C. Configure the channel to increase the capacity with the RATE parameter

  D. Configure the channel to adjust the tape buffer size with the BLKSIZE option

  Correct Answer: C