[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 141-150

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 141 – (Topic 3)

You can back up the RMAN recovery catalog with RMAN.

  1. True

  2. False

Answer: A Explanation:

When backing up the recovery catalog database, you can use RMAN to make the backups. Refer to here.

Question No: 142 – (Topic 3)

Identify two options that Oracle recommends while configuring the backup and recovery

environment for your recovery catalog. (Choose two.)

  1. configuring control file autobackup to be ON

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

  3. running the recovery catalog database in NOARCHIVELOG mode.

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

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

Answer: A,D Explanation: 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 No: 143 – (Topic 3)

Given the script

create script db_backup_datafile_script

{backup datafile and 1, and2 plus archivelog delete input;}

What is the result of running this command?

Run {execute script db_backup_datafile_script using 2;}

  1. The script will fail since you instructed RMAN to back up only one datafile rather than two.

  2. The script will successfully back up datafile 3 without error.

  3. The script will fail since it uses a substitution variable which is not supported.

  4. The execute script command will prompt for the value of and2 since it#39;s not included in the command.

  5. The script will fail because you cannot use the plus archivelog command when backing up database datafiles.

Answer: D

Question No: 144 – (Topic 3)

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

  1. Make backups faster

  2. Store RMAN metadata

  3. Store RMAN scripts

  4. Provide the ability to do centralized backup reporting.

  5. Make recovery faster

Answer: B,C,D 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: 145 – (Topic 3)

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

  1. You can use RMAN stored scripts.

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

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

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

Answer: A,C

Question No: 146 – (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 commands:

RMANgt; CONNECT CATALOG rco11/password@catdb


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

  1. They import all metadata from the RCAT10 catalog.

  2. They unregister the database from the RCAT10 catalog.

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

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

Answer: A,D Explanation:

Latesttests 2018 PDF and VCE


Question No: 147 – (Topic 3)

Which statement about using RMAN stored scripts is true?

  1. To create and execute an RMAN stored script, you must use a recovery catalog.

  2. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.

  3. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

  4. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

Answer: A Explanation:

About Stored Scripts

You can use a stored script as an alternative to a command file for managing frequently used sequences of RMAN commands. The script is stored in the recovery catalog rather than on the file system.

Stored scripts can be local or global. A local script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to that target database. A global stored script can be run against any database registered in the recovery catalog, if the RMAN client is connected to the recovery catalog and a target database.

The commands allowable within the brackets of the CREATE SCRIPT command are the same commands supported within a RUN block. Any command that is legal within a RUN command is permitted in the stored script. The following commands are not legal within stored scripts: RUN, @, and @@.

When specifying a script name, RMAN permits but generally does not require that you use quotes around the name of a stored script. If the name begins with a digit or is an RMAN reserved word, however, then you must put quotes around the name to use it as a stored

script name. Consider avoiding stored script names that begin with nonalphabetic characters or that are the same as RMAN reserved words.

Question No: 148 – (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.

Given below are some of the commands required to achieve this:

1.SQLgt; GRANT recovery_catalog_owner TO vpc1; 2.RMANgt; CONNECT CATALOG vpc1/password@catdb;


  2. RMANgt; CONNECT CATALOG catowner/password@catdb; 5.RMANgt; CREATE VIRTUAL CATALOG;

What is the correct sequence in which the commands have to be executed?

A. 1, 4, 5, 2, 3

B. 1, 4, 3, 2, 5

C. 4, 5, 2, 3, 1

D. 2, 3, 4, 5, 1

E. 1, 4, 2, 3, 5

Answer: B Explanation: Refer to here

The basic steps for creating a virtual private catalog are as follows:

  1. Create the database user who will own the virtual private catalog (if this user does not exist) and grant this user access privileges.

    1. Start SQL*Plus and connect to the recovery catalog database with administrator privileges.

    2. If the user that will own the virtual private catalog does not exist, then create the user.


    3. Grant the RECOVERY_CATALOG_OWNER role to the database user that will own the virtual private catalog, and then exit SQL*Plus.

      SQLgt; GRANT recovery_catalog_owner TO vpc1;

    4. Start RMAN and connect to the recovery catalog database as the base recovery catalog owner

      (not the virtual private catalog owner).

      RMANgt; CONNECT CATALOG catowner@catdb;

    5. Grant desired privileges to the virtual private catalog owner. RMANgt; GRANT CATALOG FOR DATABASE prod1 TO vpc1;

      You can also use a DBID rather than a database name. The virtual private catalog user does not have access to the metadata for any other databases registered in the recovery catalog.

      You can also grant the user the ability to register new target databases in the recovery catalog. For example:


  2. Create the virtual private catalog.

    1. Start RMAN and connect to the recovery catalog database as the virtual private catalog owner (not the base recovery catalog owner).

      RMANgt; CONNECT CATALOG vpc1@catdb;

    2. Create the virtual private catalog. RMANgt; CREATE VIRTUAL CATALOG;

If you intend to use a 10.2 or earlier release of RMAN with this virtual private catalog, then execute the following PL/SQL procedure (where base_catalog_owner is the database user who owns the base recovery catalog):


Topic 4, Configuring Backup Specifications

Question No: 149 – (Topic 4)

Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN. (choose all that apply)

  1. Limiting the input/output (I/O) bandwidth consumption

  2. Specifying the size of backup sets and backup pieces

  3. Specifying vendor-specific information for a media manager

  4. Specifying the parallelism for backup and restore operations

Answer: A,C Explanation:

->For Limiting the I/O bandwith: CONFIGURE [| ALLOCATE] CHANNEL….RATE

->For limiting backup pieces: CONFIGURE [| ALLOCATE] CHANNEL….MAXPIECESIZE

->For backup sets, you need to use BACKUP..MAXSETSIZE command to limit!

->For parallelism, either to use CONFIGURE DEVICE TYPE..PARALLELISM or to allocate multiple channels during job. NOT to be done with CONFIGURE CHANNEL.

Link to here: Configuring Advanced Channel Options

Latesttests 2018 PDF and VCE


Question No: 150 – (Topic 4)

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:

LOG_ARCHIVE_DEST_1 = #39;LOCATION = /disk1/archive#39; LOG_ARCHIVE_DEST_2 = #39;SERVICE = stdb1#39;

DB_RECOVERY_FILE_DEST = #39;/u01/oradata#39;

Examine the following RMAN command issued to set the deletion policy for archived log files:



Which statement is true regarding what this command accomplishes?

  1. All archived redo log files backed up at least twice to tape are deleted.

  2. All archived redo log files backed up at least once to tape are eligible for deletion.

  3. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

  4. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

Answer: D

100% Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-053 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE