Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 111:

  Which of the following statements are true about the BACKUP command? (Choose all that apply.)

  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.

  Correct Answer: BC

• Question 112:

  Which two statements are true about encrypting RMAN backup? (Choose two.)

  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

  Correct Answer: AC

• Question 113:

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

  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

  Correct Answer: AD

• Question 114:

  View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:

  RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; }

  What is the multiplexing level in the preceding backup process?

  A. 4

  B. 8

  C. 7

  D. 0

  Correct Answer: A

• Question 115:

  You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.

  Which two statements are true about this backup operation? (Choose two.)

  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

  Correct Answer: CD

• Question 116:

  Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?

  a.

  backup archivelog all;

  b.

  backup database all;

  c.

  backup controlfile;

  d.

  backup archivelog, database, controlfile delete input;

  e.

  backup database plus archivelog delete input

  A.

  e

  B.

  a, b, a, c

  C.

  d

  D.

  b, a, c

  E.

  b, a, c, d, e

  Correct Answer: A

• Question 117:

  Compressed backups work with which of the following commands?

  A. copy as backup

  B. backup as copy

  C. backup

  D. copy

  Correct Answer: C

  The backup compression only works with backup set, NONE of image copies can work with compression.

• Question 118:

  Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

  A. backup database

  B. backup database and archivelogs

  C. backup database plus archivelogs

  D. backup database plus archivelog delete input

  E. backup database and archivelog delete input

  Correct Answer: D

• Question 119:

  Which backup option defines a user-defined name for a backup?

  A. FORMAT

  B. NAME

  C. TAG

  D. FORMAT U%

  Correct Answer: C

• Question 120:

  Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?

  7.

  shutdown immediate from RMAN

  8.

  Log into RMAN

  9.

  startup mount from RMAN 10.backup database 11.alter database open 12.backup database plus archivelog delete input

  A. 2,3,1,4,5

  B. 2,1,3,6,5

  C. 1,3,5,4

  D. 2,1,3,5,6

  E. 2,1,3,4,5

  Correct Answer: E

  Backing Up a Database in NOARCHIVELOG Mode

  If a database runs in NOARCHIVELOG mode, then the only valid database backup is a consistent backup.

  For the backup to be consistent, the database must be mounted after a consistent shutdown. No recovery is required after restoring the backup.

  To make a consistent database backup:

  1.

  Start RMAN and connect to a target database.

  2.

  Shut down the database consistently and then mount it. For example, enter the following commands to guarantee that the database is in a consistent state for a backup:

  RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP FORCE DBA; RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP MOUNT;

  3.

  Run the BACKUP DATABASE command.

  For example, enter the following command at the RMAN prompt to back up the database to the default backup device:

  RMAN> BACKUP DATABASE;

  The following variation of the command creates image copy backups of all data files in the database: RMAN> BACKUP AS COPY DATABASE;

  4. Open the database and resume normal operations. The following command opens the database: RMAN> ALTER DATABASE OPEN;