OCA-15-Using Backup and Recovery

Question 1 of 20

1

1. Among the failure events, which is the most serious and may cause data loss?

Select one or more of the following:

A. The loss of an entire redo log-file group but no loss in any other group
B. The loss of one member of each redo log-file group
C. The failure of the ARCn background process
D. The failure of the LGWR background process

Explanation

Question 2 of 20

1

2. When the database is in ARCHIVELOG mode, database recovery is possible up to which
event or time?

Select one or more of the following:

A. The last redo log file switch
B. The last checkpoint position
C. The last commit
D. The last incremental backup using RMAN

Explanation

Question 3 of 20

1

3. Which is a true statement regarding image copies and backup sets.

Select one or more of the following:

A. An image copy stores one data file per image copy, and a backup set can store
many data files in a single file.
B. An image copy stores one data file per image copy, and a backup set consists of
one file per data file backed up.
C. Both image copies and backup sets use a single file to store all objects to be
backed up.
D. A backup set stores each data file in its own backup file, but an image copy places
all data files into a single output file.

Explanation

Question 4 of 20

1

4. Which of the following is not a step in configuring your database to archive redo
log files?

Select one or more of the following:

A. Place the database in ARCHIVELOG mode.
B. Multiplex the online redo log files.
C. Specify a destination for archived redo log files.
D. Specify a naming convention for your archived redo log files.

Explanation

Question 5 of 20

1

5. Why are online backups known as inconsistent backups?

Select one or more of the following:

A. Because not all control files are synchronized to the same SCN until the database
is shut down
B. Because both committed and uncommitted transactions are included in a backup
when the database is online
C. Because a database failure while an online backup is in progress can leave the
database in an inconsistent state
D. Because online backups make copies of data files while they are not consistent
with the control file

Explanation

Question 6 of 20

1

6. Which of the following initialization parameters specifies the location where the
control file trace backup is sent?

Select one or more of the following:

A. DIAGNOSTIC_DEST
B. BACKGROUND_DUMP_DEST
C. LOG_ARCHIVE_DEST
D. CORE_DUMP_DEST

Explanation

Question 7 of 20

1

7. Which of the following pieces of information is not available in the control file?

Select one or more of the following:

A. Instance name
B. Database name
C. Tablespace names
D. Log sequence number

Explanation

Question 8 of 20

1

8. Which statement adds a member /logs/redo22.log to redo log-file group 2?

Select one or more of the following:

A. ALTER DATABASE ADD LOGFILE '/logs/redo22.log' TO GROUP 2;
B. ALTER DATABASE ADD LOGFILE MEMBER '/logs/redo22.log' TO GROUP 2;
C. ALTER DATABASE ADD MEMBER '/logs/redo22.log' TO GROUP 2;
D. ALTER DATABASE ADD LOGFILE '/logs/redo22.log';

Explanation

Question 9 of 20

1

9. To place the database into ARCHIVELOG mode, in which state must you start the
database?

Select one or more of the following:

A. MOUNT
B. NOMOUNT
C. OPEN
D. SHUTDOWN
E. Any of the above

Explanation

Question 10 of 20

1

10. Which of the following substitution-variable formats are always required for specifying
the names of the archived redo log files? Choose all that apply.

Select one or more of the following:

A. %d
B. %s
C. %r
D. %t

Explanation

Question 11 of 20

1

11. Which of the following initialization parameters controls the mean time to recover the
database, in seconds, after an instance failure?

Select one or more of the following:

A. FAST_START_IO_TARGET
B. LOG_CHECKPOINT_TIMEOUT
C. FAST_START_MTTR_TARGET
D. MTTR_TARGET_ADVICE
E. FAST_START_TARGET_MTTR

Explanation

Question 12 of 20

1

12. Identify the statement that is not true regarding the loss of a control file.

Select one or more of the following:

A. A damaged control file can be repaired by using one of the remaining undamaged
control files, assuming there are at least two copies of the control file.
B. The missing or damaged control file can be replaced while the instance is still active.
C. You can temporarily run the instance with one fewer control file, as long as you
remove one of the references to the missing control file in the spfile or init.ora file.
D. An instance typically fails when one of the multiplexed control files is lost or
damaged.

Explanation

Question 13 of 20

1

13. Which failures can be detected by the Data Recovery Advisor, which then provides
repair recommendations? Choose all that apply.

Select one or more of the following:

A. Instance failure
B. Accidental deletion of a data file
C. Disk containing one redo log member is offline
D. User accidentally dropped a table

Explanation

Question 14 of 20

1

14. The instance can still be started even if some data files are missing; this rule does not
apply to which tablespaces? (Choose all that apply.)

Select one or more of the following:

A. USERS
B. SYSTEM
C. TEMP
D. SYSAUX
E. UNDO

Explanation

Question 15 of 20

1

15. Select the statement that is not true regarding media failure. A media failure occurs when:

Select one or more of the following:

A. The network card on the server fails.
B. The DBA accidentally deletes one of the data files for the SYSTEM tablespace.
C. There is a head crash on all physical drives in the RAID controller box.
D. A corrupted track on a CD containing a read-only tablespace causes a query to fail.

Explanation

Question 16 of 20

1

16. Choose the correct statement about the Data Recovery Advisor.

Select one or more of the following:

A. The Data Recovery Advisor is a standalone tool.
B. The Data Recovery Advisor does not support RAC databases.
C. The CHANGE FAILURE command can be used in a SQL*Plus session.
D. The REPAIR FAILURE command works only after LIST FAILURE .

Explanation

Question 17 of 20

1

17. Place the following events or actions leading up to and during instance recovery in the
correct order.
1. The database is opened and available.
2. Oracle uses undo segments in the undo tablespace to roll back uncommitted trans-
actions.
3. The DBA issues the STARTUP command at the SQL*Plus prompt.
4. Oracle applies the information in the online redo log files to the data files.

Select one or more of the following:

A. 4, 3, 2, 1
B. 3, 4, 1, 2
C. 2, 1, 3, 4
D. 2, 1, 4, 3
E. 3, 2, 4, 1
F. 3, 4, 2, 1

Explanation

Question 18 of 20

1

18. You’ve noticed that when an instance crashes, it takes a long time to start up the data-
base. Which advisor can be used to tune this situation?

Select one or more of the following:

A. The Undo Advisor
B. The SQL Tuning Advisor
C. The Database Tuning Advisor
D. The MTTR Advisor
E. The Instance Tuning Advisor

Explanation

Question 19 of 20

1

19. In ARCHIVELOG mode, the loss of a data file for any tablespace other than the SYSTEM or
UNDO tablespace affects which objects in the database?

Select one or more of the following:

A. The loss affects only objects whose extents reside in the lost data file.
B. The loss affects only the objects in the affected tablespace, and work can continue
in other tablespaces.
C. The loss will not abort the instance but will prevent other transactions in any
tablespace other than SYSTEM or UNDO until the affected tablespace is recovered.
D. The loss affects only those users whose default tablespace contains the lost or
damaged data file.

Explanation

Question 20 of 20

1

20. Which of the following conditions prevents the instance from progressing through the
NOMOUNT , MOUNT , and OPEN states?

Select one or more of the following:

A. One of the redo log-file groups is missing a member.
B. The instance was previously shut down uncleanly with SHUTDOWN ABORT .
C. Either the spfile or init.ora file is missing.
D. One of the five multiplexed control files is damaged.
E. The USERS tablespace is offline, with one of its data files deleted.

	Created by Jamonero Blanco almost 8 years ago

OCA OCA Quiz on OCA-15-Using Backup and Recovery, created by Jamonero Blanco on 30/01/2017.

OCA-15-Using Backup and Recovery

Question 1 of 20

1. Among the failure events, which is the most serious and may cause data loss?

Select one or more of the following:

Explanation

Question 2 of 20

2. When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?

Select one or more of the following:

Explanation

Question 3 of 20

3. Which is a true statement regarding image copies and backup sets.

Select one or more of the following:

Explanation

Question 4 of 20

4. Which of the following is not a step in configuring your database to archive redo log files?

Select one or more of the following:

Explanation

Question 5 of 20

5. Why are online backups known as inconsistent backups?

Select one or more of the following:

Explanation

Question 6 of 20

6. Which of the following initialization parameters specifies the location where the control file trace backup is sent?

Select one or more of the following:

Explanation

Question 7 of 20

7. Which of the following pieces of information is not available in the control file?

Select one or more of the following:

Explanation

Question 8 of 20

8. Which statement adds a member /logs/redo22.log to redo log-file group 2?

Select one or more of the following:

Explanation

Question 9 of 20

9. To place the database into ARCHIVELOG mode, in which state must you start the database?

Select one or more of the following:

Explanation

Question 10 of 20

10. Which of the following substitution-variable formats are always required for specifying the names of the archived redo log files? Choose all that apply.

Select one or more of the following:

Explanation

Question 11 of 20

11. Which of the following initialization parameters controls the mean time to recover the database, in seconds, after an instance failure?

Select one or more of the following:

Explanation

Question 12 of 20

12. Identify the statement that is not true regarding the loss of a control file.

Select one or more of the following:

Explanation

Question 13 of 20

13. Which failures can be detected by the Data Recovery Advisor, which then provides repair recommendations? Choose all that apply.

Select one or more of the following:

Explanation

Question 14 of 20

14. The instance can still be started even if some data files are missing; this rule does not apply to which tablespaces? (Choose all that apply.)

Select one or more of the following:

Explanation

Question 15 of 20

15. Select the statement that is not true regarding media failure. A media failure occurs when:

Select one or more of the following:

Explanation

Question 16 of 20

16. Choose the correct statement about the Data Recovery Advisor.

Select one or more of the following:

Explanation

Question 17 of 20

Select one or more of the following:

Explanation

Question 18 of 20

18. You’ve noticed that when an instance crashes, it takes a long time to start up the data- base. Which advisor can be used to tune this situation?

Select one or more of the following:

Explanation

Question 19 of 20

19. In ARCHIVELOG mode, the loss of a data file for any tablespace other than the SYSTEM or UNDO tablespace affects which objects in the database?

Select one or more of the following:

Explanation

Question 20 of 20

20. Which of the following conditions prevents the instance from progressing through the NOMOUNT , MOUNT , and OPEN states?

Select one or more of the following:

2. When the database is in ARCHIVELOG mode, database recovery is possible up to which
event or time?

4. Which of the following is not a step in configuring your database to archive redo
log files?

6. Which of the following initialization parameters specifies the location where the
control file trace backup is sent?

9. To place the database into ARCHIVELOG mode, in which state must you start the
database?

10. Which of the following substitution-variable formats are always required for specifying
the names of the archived redo log files? Choose all that apply.

11. Which of the following initialization parameters controls the mean time to recover the
database, in seconds, after an instance failure?

13. Which failures can be detected by the Data Recovery Advisor, which then provides
repair recommendations? Choose all that apply.

14. The instance can still be started even if some data files are missing; this rule does not
apply to which tablespaces? (Choose all that apply.)

18. You’ve noticed that when an instance crashes, it takes a long time to start up the data-
base. Which advisor can be used to tune this situation?

19. In ARCHIVELOG mode, the loss of a data file for any tablespace other than the SYSTEM or
UNDO tablespace affects which objects in the database?

20. Which of the following conditions prevents the instance from progressing through the
NOMOUNT , MOUNT , and OPEN states?