Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 151:

  After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?

  A. Opening the database in RESTRICTED mode

  B. Opening the database with the RESETLOGS option

  C. Setting a new DBID for the newly restored database

  D. Restoring the server parameter file (SPFILE) to the new host

  Correct Answer: B

• Question 152:

  Which mode of database shutdown requires an instance recovery at the time of the next database startup?

  A. ABORT

  B. NORMAL

  C. IMMEDIATE

  D. TRANSACTIONAL

  Correct Answer: A

• Question 153:

  Your database has experienced a loss of datafile users_01.dbf, which is associated with a tablespace called USERS. The database is still running.

  Which answer properly describes the order of the steps that you would use to recover from this error?

  1.

  Shut down the database.

  2.

  Take the users_01.dbf datafile offline with the alter database command.

  3.

  Restore the users_01.dbf datafile from backup media with the required archived redo logs.

  4.

  Restore all users tablespace-related datafiles from backup media.

  5.

  Issue the recover tablespace users command.

  6.

  Issue the recover datafile users_01.dbf command.

  7.

  Start up the database.

  8.

  Bring the users_01.dbf datafile online with the alter database command.

  A. 1, 3, 6, 7

  B. 2, 3, 6, 8

  C. 1, 2,3,6,7

  D. 1, 2, 3, 6, 7, 8

  E. 2, 3,6,5,7

  Correct Answer: B

• Question 154:

  You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the database has crashed.

  What would be the appropriate order of operations to correct the situation?

  a.

  Mount the database with the startup mount command.

  b.

  Take the SYSTEM data file offline with the alter database command.

  c.

  Restore the SYSTEM_01.dbf data file from backup media with the required archived redo logs.

  d.

  Restore all SYSTEM tablespace–related datafiles from backup media.

  e.

  Issue the recover tablespace SYSTEM command.

  f.

  Issue the recover data file SYSTEM_01.dbf command.

  g.

  Open the database with the alter database open command.

  h.

  Open the database with the alter database open RESETLOGS command.

  A.

  a, c, f, g

  B.

  b, d, e, h

  C.

  a, b, c, f, g

  D.

  d, a, e, g

  E.

  b, c, f, e, g

  Correct Answer: D

  Because there is NO controlfile damaged, and there is NO PITR recover, you don't need to use RESETLOGS option.

• Question 155:

  Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?

  A. alter tablespace DAVE_TBS backup mode;

  B. alter tablespace DAVE_TBS start backup;

  C. alter tablespace DAVE_TBS begin backup;

  D. alter tablespace DAVE_TBS backup begin;

  E. alter tablespace DAVE_TBS backup;

  Correct Answer: C

• Question 156:

  Which is NOT a valid way of backing up a control file?

  A. Backing up the control file to trace

  B. Copying the existing control file of the database to the backup location during a hot backup

  C. Copying the existing control file of the database to the backup location during a cold backup

  D. Creating a backup control file

  E. Using the create controlfile command

  Correct Answer: B

• Question 157:

  Another DBA issues a shutdown abort command on a database on which you were running an online backup.

  What will happen when you try to restart the database?

  A. Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and then open the database.

  B. Oracle will automatically take the datafile out of hot backup mode and then open the database.

  C. Oracle will generate an error when trying to open the database, indicating that a datafile is in hot backup mode. You will need to correct this error before you can open the database.

  D. The database will open with the file in hot backup mode. You can restart the backup at any time.

  E. The datafile in hot backup mode will be corrupted and you will have to recover it.

  Correct Answer: C

• Question 158:

  You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.

  Which statement about performing user-managed backups in a 24x7 environment is true?

  A. You must have change tracking enabled in your database

  B. Your database must be running in NOARCHIVELOG mode

  C. To back up a tablespace, it must be in backup mode

  D. To back up a tablespace, it must first be taken offline

  Correct Answer: C

• Question 159:

  What is the correct order of steps to perform an online database backup?

  a: alter database begin backup;

  b: alter database end backup;

  c: Back up the database datafiles.

  d: Back up the archive log files.

  e:

  alter system switch logfile;

  A.

  a, b, c, d, e

  B.

  e, d, a, b, c

  C.

  a, c, b, d, e

  D.

  d, b, c, a, e

  E.

  a, c, b, e, d

  Correct Answer: E

  (link)

  To back up online read/write tablespaces in an open database:

  1.

  Use the DBA_DATA_FILES data dictionary view to identify all of the data files in the tablespace.

  2.

  ALTER TABLESPACE users BEGIN BACKUP;

  3.

  Back up the online data files of the online tablespace with operating system commands.

  4.

  ALTER TABLESPACE users END BACKUP;

  5.

  ALTER SYSTEM ARCHIVE LOG CURRENT; Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived.

• Question 160:

  Which command will result in a trace file being created with the create controlfile command contained in it?

  A. alter database backup controlfile;

  B. alter database backup controlfile to trace;

  C. alter database controlfile backup;

  D. alter database controlfile backup to '/ora01/oracle/ctrl_backup.ctl';

  E. alter database begin controlfile backup;

  Correct Answer: B

  ALTER DATABASE BACKUP CONTROLFILE TO TRACE

  Specify TO TRACE if you want Oracle Database to write SQL statements to a trace file rather than making a physical backup of the control file. You can use SQL statements written to the trace file to start up the database, re-create the control file, and recover and open the database appropriately, based on the created control file. If you issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement while block change tracking is enabled, then the resulting trace file will contain a command to reenable block change tracking. The trace file will also include ALTER DATABASE REGISTER LOGFILE statements for existing logfiles that reside in the current archivelog destinations. This will implicitly create database incarnation records for the branches of redo to which the logfiles apply. You can copy the statements from the trace file into a script file, edit the statements as necessary, and use the script if all copies of the control file are lost (or to change the size of the control file).