This preview shows page 1. Sign up to view the full content.
Unformatted text preview: llback segments provide read consistency.
Actualtests.com - 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
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 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.
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09