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

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 331 – (Topic 9)

Which command is used to begin a tablespace point-in-time recovery?

  1. Restore tablespace

  2. Recover tablespace

  3. Tablespace recover

  4. Recover to time

  5. recover datafile

Answer: B

Question No: 332 – (Topic 9)

True or false: tablespace point-in-time recovery is possible only with RMAN.

  1. True

  2. False

Answer: B

Question No: 333 – (Topic 9)

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is true?

  1. You cannot perform the TSPITR with the constraints enabled.

  2. You must perform the TSPITR recovery of both tablespaces for it to be successful.

  3. You can perform TSPITR only on the USERS tablespace.

  4. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.

  5. The TSPITR will only be successful if the constraint is enabled.

Answer: B

Question No: 334 – (Topic 9)

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.

Which two actions will permit the TSPITR to work? (Choose two.)

  1. Taking the MASTERTBS tablespace offline

  2. Dropping the relationship between the tables

  3. Adding the MASTERTBS tablespace to the recovery set

  4. Putting the MASTERTBS tablespace in read-only mode

Answer: B,C

Topic 10, Monitoring and Tuning RMAN

Question No: 335 – (Topic 10)

You perform a backup using the following BACKUP command: RMANgt; BACKUP AS COMPRESSED BACKUPSET DATABASE;

Which statement is true of this command?

  1. A different procedure is required to restore a database from compressed backups

  2. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

  3. Using this command to create backups minimizes the bandwidth consumed

  4. Using this command to create backups improves the performance of the backup process

Answer: C

Question No: 336 – (Topic 10)

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.

Which method would accomplish the task quickly and efficiently?

  1. parallel image copy backup

  2. backup with MAXPIECESIZE configured for the channel

  3. parallel backup with MAXPIECESIZE configured for the channel

  4. intrafile parallel backup

Answer: D Explanation:

The MAXPIECESIZE option is to limit the size of backup piece. not to split the big file into pieces.

Configuring the Maximum Size of Backup Pieces

Backup piece size is an issue when it exceeds the maximum file size permitted by the file system or media management software. You can use the MAXPIECESIZE parameter of the CONFIGURE CHANNEL or ALLOCATE CHANNEL command to limit the size of backup pieces.

For example, to limit the backup piece size to 2 gigabytes or less, you can configure the

automatic DISK channel as follows and then run BACKUP DATABASE:

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G; BACKUP DATABASE;

We should use the SECTION SIZE option to split the big file into sections to the multiple backup devices. SECTION SIZE sizeSpec Specifies the size of each backup section produced during a data file backup.

By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy.

File sections enable RMAN to create multiple steps for the backup of a single large data file. RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set.

If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections.

Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job.

Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL 1.

Question No: 337 – (Topic 10)

You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.

Which type of backup should you perform?

  1. standard backup set

  2. image copy

  3. compressed backup

  4. user-managed backup

Answer: C

Question No: 338 – (Topic 10)

You issued the following RMAN command to back up the database:

RMANgt; RUN{

ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE

TAG quarterly KEEP FOREVER

RESTORE POINT FY06Q4;

}

Which two statements are true regarding the backup performed? (Choose two.)

  1. Archived redo log files are backed up along with data files.

  2. Only data files are backed up and a restore point named FY06Q4 is created.

  3. Archived log files are backed up along with data files, and the archived log files are deleted.

  4. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

Answer: A,D

Explanation: Section: Monitoring and Tuning RMAN Explanation

Refer to here. keepOption

Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26.

You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy.

Note: You cannot use KEEP with BACKUP BACKUPSET.

With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery catalog when you specify KEEP FOREVER.

Note: You can use CHANGE to alter the status of a backup generated with KEEP. See Also: keepOption for more information about backups made with the KEEP option Creating a Consistent Database Backup for Archival Purposes

This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only those archived redo log files needed to restore the data file backup to a consistent state. The BACKUP command also creates a restore point to match the SCN at which this backup is consistent. The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.

BACKUP DATABASE

FORMAT #39;/disk1/archival_backups/db_%U.bck#39; TAG quarterly

KEEP UNTIL TIME #39;SYSDATE 365#39; RESTORE POINT Q1FY06;

Question No: 339 – (Topic 10)

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

  1. The tape I/O performed is asynchronous

  2. The tape buffer is allocated from the System Global Area (SGA)

  3. The tape buffer is allocated from the Program Global Area (PGA)

  4. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

Answer: C Explanation: Tape I/O Slaves

RMAN allocates the tape buffers in the System Global Area (SGA) or the Program Global Area (PGA), depending on whether I/O slaves are used. If you set the initialization

parameter

BACKUP_TAPE_IO_SLAVES=true, then RMAN allocates tape buffers from the SGA. Tape devices can only be accessed by one process at a time, so RMAN starts as many slaves as necessary for the number of tape devices. If the LARGE_POOL_SIZE initialization parameter is also set, then RMAN allocates buffers from the large pool. If you set BACKUP_TAPE_IO_SLAVES=false, then RMAN allocates the buffers from the PGA.

If you use I/O slaves, then set the LARGE_POOL_SIZE initialization parameter to dedicate SGA memory to holding these large memory allocations. This parameter prevents RMAN I/O buffers from competing with the library cache for SGA memory. If I/O slaves for tape I/O were requested but there is not enough space in the SGA for them, slaves are not used, and a message appears in the alert log.

The parameter BACKUP_TAPE_IO_SLAVES specifies whether RMAN uses slave processes rather than the number of slave processes. Tape devices can only be accessed by one process at a time, and RMAN uses the number of slaves necessary for the number of tape devices.

Question No: 340 – (Topic 10)

Examine the following command for RMAN backup:

RMANgt; RUN {

ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP

INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3);

SQL #39;ALTER SYSTEM ARCHIVE LOG CURRENT#39;;

}

Which statement Is true regarding the approach in the command?

  1. The RMAN multiplexing level is 4.

  2. It is the use of asynchronous I/O by RMAN.

  3. It is a case of parallelization of the backup set.

  4. It is an implementation of a multisection backup.

Answer: C

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
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE