Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 191:

  Which command is used to open the database after an incomplete recovery?

  A. alter database open

  B. alter database open repairlog

  C. alter database open resetlogs

  D. alter database open resetlog

  E. alter database resetlogs open

  Correct Answer: C

• Question 192:

  While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 m. on September 6, 2008.

  Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?

  

  A. B. C. D. E.

  Correct Answer: C

• Question 193:

  Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:

  ALTER TABLESPACE data1 BEGIN BACKUP;

  While you are performing the backup, an error occurs that causes the instance to terminate abnormally.

  Which statement about the DATA1 tablespace is true?

  A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

  B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

  C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

  D. If you restart the database, the database will not be opened.

  Correct Answer: D

  After database instance failure, the BEGIN BACKUP option would not obtain the tablespace online, it will be OFFLINE mode. so that the instance cannot load the database file online.

• Question 194:

  Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?

  a.

  restore controlfile

  b.

  restore database

  c.

  restore spfile

  d.

  recover database

  e.

  alter database open

  f.

  alter database open resetlogs

  A.

  b, a, c, d, e

  B.

  a, c, b, d, f

  C.

  c, a, b, d, e

  D.

  c, a, b, d, f

  E.

  e, a, b, d, c

  Correct Answer: D

• Question 195:

  If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?

  A. Complete database recovery.

  B. Incomplete database recovery.

  C. Approximate database recovery.

  D. Archived database recovery.

  E. The database could not be recovered with RMAN.

  Correct Answer: B

• Question 196:

  You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?

  a.

  restore controlfile until time '09/30/2008:18:00:00';

  b.

  restore database until time '09/30/2008:18:00:00';

  c.

  restore spfile until time '09/30/2008:18:00:00';

  d.

  recover database until time '09/30/2008:18:00:00';

  e.

  alter database open resetlogs;

  f.

  alter database open;

  A.

  b, d, e

  B.

  b, d, f

  C.

  c, a, b, d, e

  D.

  c, a, b, d, f

  E.

  a, b, d, e

  Correct Answer: A

• Question 197:

  What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?

  a: sql 'alter database datafile 4 online';

  b: restore datafile 4;

  c: recover datafile 4;

  d: sql 'alter database datafile 4 offline';

  e: startup

  f:

  shutdown

  A.

  a, c, b, d

  B.

  d, b, c, a

  C.

  f, d, b, c, a, e

  D.

  c, a, b, d, f

  E.

  a, b, d, e

  Correct Answer: B

• Question 198:

  Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:

  RESTORE CONTROLFILE FROM AUTOBACKUP;

  Which of the following statements is true? (Choose all that apply.)

  A. The command restores only the missing control file.

  B. The command restores all the control files.

  C. The command fails because the database is running.

  D. This is the correct way to address this problem.

  E. This is not the correct way to address this problem.

  Correct Answer: CE

  During the database running, the control files are locked by the database instance, you must shutdown the database and startup at NOMOUNT status to restore a missing control file. And you have to open database with RESETLOGS option, due to control file change.

• Question 199:

  Which statement about recovering from the loss of a redo log group is true?

  A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

  B. If the lost redo log group is CURRENT, you must clear the log file.

  C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

  D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

  Correct Answer: D

• Question 200:

  You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

  A. The archived redo log files will be overwritten.

  B. The archived redo log files are deleted automatically.

  C. The archived redo log files should be moved to some other location.

  D. The archived redo log files are still maintained because the file names are unique.

  Correct Answer: D