Incorrect answers a rollback segments provide read

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: llback segments provide read consistency. - The Power of Knowing 1Z0-023 C: Rollback segments also are used to roll back uncommitted transactions. D: Redo logs do not update datafiles of uncommitted transactions. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 324-325 Chapter 7: Managing the Physical Database Structure QUESTION 84: A DBA enters the command: ALTER DATABASE ADD LOGFILE MEMBER '/w01/oracle/DBA/log1b.rdo' TO GROUP 1, '/w02/oracle/DBA/log2b.rdo' TO GROUP 2, How does Oracle size the new redo logs? A. It sizes them at five times the database block size. B. It uses the size of the current members in group 1 and group 2. C. It uses the default size specified during the CREATE DATABASE command. D. It uses the size of the files log1b.rdo and log2b.rdo that already exists. Answer: B Explanation: Answer B is correct. Oracle will size new member in the group 1 as all other members in this group and new member in the group 2 as existing member. Incorrect Answers: A: Red...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online