C the rollback segment records the after image of the

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: image of the changes to the data block. D. If the data and rollback blocks are not already in the buffer cache, oracle will terminate the SQL statement. Actualtests.com - The Power of Knowing 1Z0-023 Answer: B Explanation: Answer B is correct. Oracle server places shared locks on the rows that are to be able modified. With shared locks other transactions can access the same rows for data retrieval. Incorrect Answers: A: This statement is not correct about DML SQL statement. C: The rollback segment records the before-image, not after-image for read consistency. D: If the data and rollback segment blocks are not already in the buffer cache, the Oracle process will load data blocks from disk to buffer cache. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 369-372 Chapter 8: Managing Database Objects I QUESTION 107: You issue the following command: orapwd file=orapwORCL password=secure entries=5 What is the effect? A. A new password file is created. B. An existing password file is updated. C....
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online