Architecture and Administration Q013

If you are updating one row in a table using the ROWID in the WHERE clause, assuming that the row is not already in the buffer cache, what will be the minimum amount of information read to the buffer cache?



1. The entire table is copied to the buffer cache.
2. The extent is copied to the buffer cache.
3. The block is copied to the buffer cache.
4. The row is copied to the buffer cache.



Answer 3 - The block is the smallest unit that can be copied to the buffer cache.