Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 161:

  You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up.

  What command would you use?

  A. alter tablespace MY_DATA begin backup;

  B. alter tablespace MY_DATA start backup;

  C. alter tablespace MY_DATA backup begin;

  D. alter MY_DATA begin backup;

  E. You cannot back up individual tablespaces.

  Correct Answer: A

• Question 162:

  You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.

  Which of the following actions would ensure that the changes could be recovered using the 8

  A. m. backup?

  B. Create a manual incremental online database backup.

  C. Back up all the archived redo logs generated since the 8 a.m. backup.

  D. Create a brand-new backup after all the changes have been applied.

  E. There is no way to make the changes recoverable based on the 8 a.m. backup.

  F. Perform an online backup of the tablespace(s) that contained changed data.

  Correct Answer: B

• Question 163:

  When performing an online backup, what is the proper order of the following steps?

  a: Issue the ALTER DATABASE END BACKUP command.

  b: Back up the archived redo logs.

  c: Issue the ALTER DATABASE BEGIN BACKUP command.

  d: Back up the database files.

  e: Determine the beginning log sequence number.

  f: Determine the ending log sequence number.

  g:

  Force a log switch with the ALTER SYSTEM SWITCH LOGFILE command.

  A.

  a, b, c, d, e, f, g

  B.

  c, d, a, b, e, g, f

  C.

  f, d, b, g, a, c, e

  D.

  e, c, d, a, g, f, b

  E.

  a, f, b, g, e, c, d

  Correct Answer: D

  There are two big steps to complete the online database backup:

  1.

  Enclose with BEGIN BACKUP and END BACKUP options to use O/S file copy command to backup data files; Which is e, c, d, a

  2.

  Use SWITCH LOGFILE command to archive all the online redo log. backup all the archived redo log file. Which is g, f, b

  According to Oracle document, after online backup done, you must archive the online redo log, otherwise you will have no chance to recover the database with consistence.

• Question 164:

  The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two)

  A. Control files

  B. Password files

  C. Inactive online redo log file

  D. Archived log files required to perform recovery

  E. Newly created tablespace which is not backed up

  Correct Answer: AD

  The RESETLOGS options is required in:

  1.

  Imcomplete Recovery

  2.

  Change of control file

  So that, the control file and archived redo logs are required.

• Question 165:

  Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they don't want you to shut down the database to perform the backup.

  What options are available to you?

  A. Put the database in hot backup mode and perform an online backup, including backing up the archived redo logs.

  B. Just back up the database datafiles without shutting down the database.

  C. You will have to wait until you can shut down the database to perform the backup.

  D. Mark each datafile as backup in progress, back them up individually, and then mark them as backup not in progress. No archived redo logs will need to be backed up.

  E. Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing, you can shut down the database and back up the datafiles the user changed during the course of the remaining backup

  Correct Answer: C

• Question 166:

  Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.

  The steps to recover the damaged data files are follows:

  1.

  Mount the database

  2.

  Open the database

  3.

  Recover the data file

  4.

  Restore the data file

  5.

  Make the data file offline

  6.

  Make the data file online

  Which option identifies the correct sequence that you must use to recover the data files?

  A. 2, 4, 3

  B. 1, 4, 3, 2

  C. 2, 5, 4, 3, 6

  D. 5, 2, 4, 3, 6

  E. 1, 5, 4, 3, 6, 2

  Correct Answer: D

• Question 167:

  The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.

  One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:

  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

  Which action should you perform immediately after using this command?

  A. You should perform a log switch

  B. You should make a backup of the database

  C. You should switch the database to the NOARCHIVELOG mode

  D. You should shut down the database instance and perform a complete database recovery

  Correct Answer: B

• Question 168:

  You want to migrate your database to ASM, so you have done a clean shutdown, made a closed backup of the entire database. You noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?

  1.

  STARTUP NOMOUNT

  2.

  ALTER DATABASE OPEN RESETLOGS

  3.

  SQL "ALTER DATABASE RENAME 'logfile1' path TO '+dgrp4'" # plus all other logfiles

  4.

  SWITCH DATABASE TO COPY

  5.

  BACKUP AS COPY DATABASE FORMAT '+dgrp4'

  6.

  ALTER DATABASE MOUNT

  7.

  RESTORE CONTROLFILE FROM 'controlfile_location'

  A. 2, 5, 3, 1, 7, 6, 4

  B. 1, 7, 6, 5, 4, 3, 2

  C. 5, 1, 2, 7, 4, 6, 3

  D. 7, 3, 1, 5, 6, 2, 4

  Correct Answer: B

• Question 169:

  In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file.

  Which option must you consider for this task?

  A. using only the RMAN SWITCH command to set the new location for the data file

  B. placing the database in the MOUNT state for the restore and recovery operations.

  C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

  D. configuring two channels: one for the restore operation and the other for the recovery operation

  Correct Answer: C

• Question 170:

  To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP;

  While copying the file to the backup destination a power outage caused the instance to terminate abnormally.

  Which statement is true about the next database startup and the USERS tablespace?

  A. The database will open, and the tablespace automatically comes out of the backup mode.

  B. The database will be mounted, and recovery must be performed on the USERS tablespace.

  C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

  D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

  Correct Answer: C