C adds a redo log to group 1 and a redo log to group

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: to group 1 and a redo log to group 2. D. Creates two new redo log groups with one member each. Answer: B Explanation: Answer B is correct. This statement will create a new redo log group with two members. Incorrect Answers: A: This command will not add online redo logs to the current group. C: This statement does not add a redo log member to group 1 and a redo log member to group 2. D: This statement does not create two new redo log groups. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 330-333 Chapter 7: Managing the Physical Database Structure QUESTION 40: In Oracle8i, what does the FAST_START_IO_TARGET parameter do? A. It allows faster access to database files. B. It sets targets for maximum IO on any database file. C. It allows the database to distribute IO over many disks. D. It improves the performance of crash and instance recovery. Answer: D Explanation: Answer D is correct. To improve the performance of crash and instance recovery you need to set FAST_START_IO_TARGET parameter in initSID.ora file. This para...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online