Oracle Database 11g Administration II Version: 3.1 (Course: 1z0-053 Exam) Part-III

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Write Down the your Full Name? *

Write Down the your Mobile Number? *

QUESTION NO: 201 Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file auto backups enabled? *

1 point

A. e

B. a, b, a, c

C. d

D. b, a, c

E. b, a, c, d, e

QUESTION NO: 202 Which of the following statements are true about the BACKUP command? (Choose all that apply.) *

1 point

A. The BACKUP command can not be used to make image copies of a datafile.

B. The BACKUP command can improve performance by multiplexing backup files.

C. The BACKUP can take advantage of the block-change tracking capability.

D. The BACKUP command cannot store data in incremental backups.

E. The BACKUP command can store data in cumulative incremental backups only.

Required

QUESTION NO: 203 Which two statements are true about encrypting RMAN backup? (Choose two.) *

1 point

A. The transparent encryption of backups uses the encryption wallet

B. The database uses the same encryption key for every encrypted backup

C. The password encryption of backups only uses the password while creating and restoring backup

D. If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.

Required

QUESTION NO: 204 You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two). *

1 point

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database

Required

QUESTION NO: 205 View the Exhibit and examine the output. *

1 point

A. 4

B. 8

C. 7

D. 0

QUESTION NO: 206 You want to take a complete database backup using RMAN. The backup should consist of only the used blocks from your database. Which two statements are true about this backup operation? (Choose two.) *

1 point

A. Backup compression should be enabled

B. Parallelism for the channel should be set to 2

C. All the files must be backed up as backup sets

D. The backup may be stored either on disk or on media with media manager

Required

QUESTION NO: 207 Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified? *

1 point

A. only the control file, the current SPFILE, and data files

B. only the current SPFILE and data files if autobackup is disabled

C. only the data files and the archived redo logs

D. the control file, current SPFILE file, data files, and archived redo logs

QUESTION NO: 208 Using the LIST command in Recovery Manager (RMAN), Which two pieces of information in the RMAN repository can be listed? (Choose two.) *

1 point

A. stored scripts in the recovery catalog

B. backups that can be deleted from disk

C. backup sets and image copies are obsolete

D. backups that do not have the AVAILABLE status in the RMAN repository

QUESTION NO: 209 Examine the following set of RMAN commands: *

1 point

A. The execution of the script fails because multiple channels cannot coexist.

B. The script is executed and both the channels are used for the script execution.

C. The new channel 'CHI' is Ignored because a channel has been configured already.

D. configuration parameter dc1 is overridden because a new channel is allocated in RMAN RUN block.

QUESTION NO: 210 Examine the following RMAN script: *

1 point

A. The data file is checked for physical corruption and backed up if found clean.

B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report

Forms