[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-053 Dumps with VCE and PDF 121-130

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: 121 – (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 also want to deregister them from the catalog after import.

You executed the following commands to achieve this:

RMANgt; CONNECT CATALOG rco11/password@catdb

RMANgt; IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;

What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

  1. The scripts in the RCO11 catalog are overwritten.

  2. RMAN renames the local stored scripts in the RCO11 catalog.

  3. The RMAN session in which the command is executed aborts.

  4. RMAN renames the global scripts that are imported from the RCAT10 catalog.

Answer: D

Question No: 122 – (Topic 3)

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 quot;onquot;

->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?

  1. Setting DBID for the database

  2. Using the RMAN SWITCH command

  3. Using the RMAN SET NEWNAME command

  4. Starting up the database instance in the NOMOUNT state

Answer: D

Question No: 123 – (Topic 3)

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?

  1. register database

  2. recover catalog

  3. load backupset

  4. synch metadata

  5. catalog start with

    Answer: E Explanation:

    Ensurepass 2018 PDF and VCE


    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 #39;string_pattern#39;

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

    While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space.

    However, you have another database where more space is available and you want to move your existing recovery catalog to this database.

    The options that can be considered while moving the recovery catalog are as follows:

    1. Using one of the Oracle expdp utilities to export the catalog data

    2. Creating a recovery catalog user and granting the necessary privileges in the other database

    3. Creating the recovery catalog using the CREATE CATALOG command

    4. Using the corresponding impdp utility to import the catalog data into the other database

    5. Registering the target database in the new catalog database using the REGISTER DATABASE command.

      Identify the option with the correct sequence for moving the recovery catalog.

      A. 2, 3, 5

      B. 1, 2, 4

      C. 1, 2, 4, 5

      D. 1, 2, 3, 4, 5

      Answer: B Explanation:

      The exp/imp tools can export and import the complete data structure and data extents to the destination database, so that you don#39;t need to do create catalog and register database.

      Question No: 125 – (Topic 3)

      Which statement is true regarding virtual private catalogs?

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

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

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

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

Answer: D

Question No: 126 – (Topic 3)

RMAN provides more granular catalog security through which feature?

  1. Virtual private database

  2. Virtual private catalog

  3. RMAN virtual database

  4. RMAN secure catalog

  5. Oracle Database Vault

Answer: B Explanation:

About Virtual Private Catalogs

By default, all of the users of an RMAN recovery catalog have full privileges to insert, update, and delete any metadata in the catalog. For example, if the administrators of two unrelated databases share the same recovery catalog, each administrator could, whether inadvertently or maliciously, destroy catalog data for the other#39;s database. In many enterprises, this situation is tolerated because the same people manage many different databases and also manage the recovery catalog. But in other enterprises where clear separation of duty exists between administrators of various databases, and between the DBA and the administrator of the recovery catalog, you may desire to restrict each

database administrator to modify only backup metadata belonging to those databases that they are responsible for, while still keeping the benefits of a single, centrallymanaged, RMAN recovery catalog. This goal can be achieved by implementing virtual private catalogs.

Question No: 127 – (Topic 3)

Which command do you use to create a recovery-catalog schema?

  1. create recovery catalog

  2. create catalog

  3. build catalog

  4. catalog create

  5. mount catalog

Answer: B Explanation:

Use the CREATE CATALOG command to create a recovery catalog.

The recovery catalog can be a base recovery catalog or a virtual private catalog.

->A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases.

->A virtual private catalog is a set of synonyms and views that enable user access to

a subset of a base recovery catalog.

Ensurepass 2018 PDF and VCE


Question No: 128 – (Topic 3)

Which option is best practice for creating a recovery catalog owner in the catalog database?

  1. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

  2. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

  3. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user

  4. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

    Answer: C Explanation:

    To create the recovery catalog schema in the recovery catalog database:

    1. Start SQL*Plus and connect with administrator privileges to the database containing the recovery catalog. In this example, the database is catdb.

    2. Create a user and schema for the recovery catalog. For example, you could enter the following SQL statement (replacing password with a user-defined password):



    3. Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with all privileges required to maintain and query the recovery catalog. GRANT RECOVERY_CATALOG_OWNER TO rman;

      Question No: 129 – (Topic 3)

      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:

      RMANgt; GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;

      Then you issue the following commands:

      RMANgt; CONNECT CATALOG vpc1/oracle@catdb;

      RMANgt; SQL quot;EXEC catowner.dbms_rcvcat.create_virtual_catalog;quot; What is the outcome of the above commands?

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

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

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

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

Answer: A

Question No: 130 – (Topic 3)

Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. (Choose all that apply.)

  1. rman target=/ catalog=/@rcat

  2. rman target=/ catalog=rcat_own/rcat_own

  3. rman target=/ catalog=rcat_own/rcat_own@RCAT

  4. rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT

  5. You cannot connect to the target database and the recovery catalog at the same time.

Answer: C,D

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
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.