[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-053 Dumps with VCE and PDF 131-140

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 131 – (Topic 3)

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

  1. It must be used because all RMAN-related backup and recovery metadata information is contained in it.

  2. It provides a convenient, optional, repository of backup- and recovery-related metadata.

  3. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.

  4. It provides a means of storing all RMAN backup sets physically in an Oracle database server.

  5. It provides the ability to store backup records for more than a year.

Answer: B,C,E Explanation:

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 No: 132 – (Topic 3)

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.

The RVPC user can do which of the following? (Choose all that apply.)

  1. Register databases if granted the register database privilege

  2. See all databases in the recovery-catalog schema

  3. See all database-related metadata in the recovery catalog if they are granted access to that database

  4. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command

  5. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

Answer: A,C

Question No: 133 – (Topic 3)

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?

  1. A base catalog exists

  2. The recovery catalog is empty

  3. The base recovery catalog must be dropped

  4. A target database is registered in the recovery catalog

Answer: A

Question No: 134 – (Topic 3)

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?

  1. Issue the grant command from the SYS user (or equivalent) of the target database.

  2. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.

  3. Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

  4. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

  5. Issue the grant command from RMAN when connected to the target database.

Answer: D

Question No: 135 – (Topic 3)

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:

Ensurepass 2018 PDF and VCE

Which statement is true about the outcome?

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

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

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

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

Answer: A

Question No: 136 – (Topic 3)

If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

  1. The next time you back up the database when you are also connected to the recovery catalog and the target database

  2. The next time you are connected to the target database and the recovery catalog database and issue the resync command

  3. The next time you connect RMAN to just the recovery catalog

  4. The next time you connect to the recovery catalog and the target database with RMAN

  5. Connecting to the recovery catalog and issuing the resync all databases command

Answer: A,B Explanation:

Deciding When to Resynchronize the Recovery Catalog

RMAN automatically resynchronizes the recovery catalog when

->RMAN is connected to a target database and recovery catalog

->And you have executed RMAN commands.

Thus, you should not need to manually run the RESYNC CATALOG command very often.

Question No: 137 – (Topic 3)

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:

RMANgt; CONNECT CATALOG rco11/password@catdb RMANgt; IMPORT CATALOG rcat10/oracle@inst1;

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

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

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

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

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

Answer: A,B,C

Question No: 138 – (Topic 3)

What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)


  2. DBA




    Answer: A,C

    Question No: 139 – (Topic 3)

    In what order would you execute the following steps to create a recovery catalog?

    1. Issue the create catalog command.

    2. Create the recovery-catalog database.

    3. Create the recovery-catalog user.

    4. Grant the recovery_catalog_owner privilege to the recovery-catalog user.

    5. Issue the register database command from the target database.

      1. a, b, c, d, e

      2. b, a, d, c, e

      3. b, c, d, a, e

      4. b, c, d, e, a

      5. b, d, c, a, e

Answer: C

Question No: 140 – (Topic 3)

You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?

  1. synch catalog

  2. resync catalog

  3. replicate catalog

  4. update catalog

  5. restore catalog

    Answer: B Explanation:

    Manually Resynchronizing the Recovery Catalog

    Use RESYNC CATALOG to force a full resynchronization of the recovery catalog with a target database control file. You can specify a database unique name with RESYNC FROM DB_UNIQUE_NAME or ALL, depending on whether you want to resynchronize a specific database or all databases in the Data Guard environment.

    Typically, you would perform this operation after you have run the CONFIGURE command for a standby database, but have not yet connected to this standby database.

    1. Start RMAN and connect to a target database and recovery catalog.

    2. Mount or open the target database: RMANgt; STARTUP MOUNT;

    3. Resynchronize the recovery catalog. RMANgt; RESYNC CATALOG;

      100% Ensurepass Free Download!
      Download Free Demo:1z0-053 Demo PDF
      100% Ensurepass Free Guaranteed!
      1z0-053 Dumps

      EnsurePass ExamCollection Testking
      Lowest Price Guarantee Yes No No
      Up-to-Dated Yes No No
      Real Questions Yes No No
      Explanation Yes No No
      PDF VCE Yes No No
      Free VCE Simulator Yes No No
      Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.