Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 221:

  While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.

  Which RMAN command do you use to perform BMR and repair the corrupt block?

  A. RECOVER FILE=1201 BLOCK=1968;

  B. RECOVER CORRUPTION LIST;

  C. RECOVER DATAFILE 1201 BLOCK 1968;

  D. RECOVER BLOCK CORRUPTION LIST;

  E. None of the above

  Correct Answer: BC

• Question 222:

  Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG mode database.

  a: restore database;

  b: recover database;

  c: shutdown immediate

  d: startup

  e: restore archivelog all;

  f:

  alter database open

  A.

  a, b, c, d, e, f

  B.

  c, b, a, d, e, f

  C.

  c, b, a, d, f

  D.

  c, a, b, d

  E.

  c, a, e, b, d, f

  Correct Answer: E

• Question 223:

  Which commands are used for RMAN database recovery? (Choose all that apply.)

  A. restore

  B. repair

  C. copy

  D. recover

  E. replace

  Correct Answer: AD

• Question 224:

  Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?

  A. restore datafiles until time '09/28/2008:21:03:11';

  B. restore database files until time '09/28/2008:18:00:00';

  C. restore database until time '09/28/2008:18:00:00';

  D. recover database until time '09/28/2008:18:00:00';

  E. recover database until timestamp '09/28/2008:18:00:00';

  Correct Answer: C

• Question 225:

  What is the end result of these commands if they are successful?

  RMAN> show retention policy;

  RMAN configuration parameters for database with db_unique_name ORCL are:

  CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default RMAN> backup database tag=gold_copy plus archivelog tag=gold_copy delete input; RMAN> backup database tag=silver_copy plus archivelog tag=silver_copy delete

  input;

  A. Attempting to restore silver_copy will fail.

  B. Attempting to restore gold_copy will fail.

  C. Both backups will be available for restore without question.

  D. Attempting to restore gold_copy may or may not succeed.

  E. You will not be able to restore either gold_copy or silver_copy.

  Correct Answer: D

• Question 226:

  What is the purpose of the until change option of the restore command?

  A. It allows you to select the SCN that you want to restore to.

  B. It allows you to select the log sequence number you want to restore to.

  C. It allows you to select the timestamp you want to restore to.

  D. It allows you to manually stop the restore at any time as online redo logs are applied.

  E. None of the above.

  Correct Answer: A

  The keyword of CHANGE means to point to the system change number (SCN).

• Question 227:

  You are performing incomplete recovery using RMAN. You execute the following RUN block:

  RUN

  {

  SET UNTIL SCN 1107600;

  RESTORE DATABASE;

  RECOVER DATABASE;

  }

  Which statement is true about the result?

  A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600

  B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.

  C. RMAN restores all datafiles and control files from the most recent backup

  D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

  Correct Answer: B

• Question 228:

  Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

  A. It's only supported for the backups performed on the tape

  B. It is not supported for backup operations that produce image copies

  C. Duplex backups need a parallelism for the device to be equal to number of copies

  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

  Correct Answer: BD

• Question 229:

  You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:

  SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE \INITORCL.ORA'

  Using RMAN, how would you respond to this error?

  A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

  B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

  C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

  D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

  E. Issue the restore spfile from autobackup command from the RMAN prompt.

  Correct Answer: C

• Question 230:

  When running the tablespace point-in-time command

  recover tablespace users

  until time '10/06/2008:22:42:00'

  auxiliary destination 'c:\oracle\auxiliary';

  You receive the following error:

  

  What is the likely cause of the error?

  A. The database is in ARCHIVELOG mode.

  B. There is not a current backup of the database available.

  C. The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.

  D. The USERS tablespace is not eligible for TSPITR because it has invalid objects.

  E. The recover tablespace command is incorrect and generates the error.

  Correct Answer: B