This preview shows page 1. Sign up to view the full content.
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 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.
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
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.
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09