READ Free Dumps For Oracle- 1z0-023
Question ID 8851 | What are two components of Oracle Instance? (Choose two)
|
Option A | The redo logs
|
Option B | The library cache
|
Option C | The control cache
|
Option D | The parameter file
|
Option E | The CKPT process
|
Correct Answer | BE |
Explanation Explanation/Reference: Explanation: Answers B and E are correct. The library cache and the CKPT process are components of Oracle instance. Incorrect Answers: A: The redo logs are components of an Oracle database, not instance. C: There is no the control cache structure in Oracle. D: The parameter file is a components of an Oracle database, not instance. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 257-261 Chapter 6: Basics of the Oracle Database Architecture
Question ID 8852 | Which statement about executing a Data Manipulation Language (DML) SQL statement is true?
|
Option A | The data block is updated to record the new values of the data.
|
Option B | The oracle server places shared locks on the rows that are to be able modified.
|
Option C | The rollback segment records the after-image of the changes to the data block.
|
Option D | If the data and rollback blocks are not already in the buffer cache, oracle will terminate the SQL statement.
|
Correct Answer | B |
Explanation Explanation/Reference: 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