O'Reilly logo
  • francis shey thinks this is interesting:

Test your knowledge

Q 1. User A executes only the following statements in a table with 100 rows:

INSERT of 50 rows
COMMIT
INSERT of 10 rows
DELETE of 20 rows

If User B logs in and executes a SELECT statement that returns every row in the table, how many rows will User B see?

a. 140

b. 150

c. 160

d. 180

Q 2. What is the term that states that Oracle maintains multiple versions of the same database block at different points in time to ensure read consistency?

a. Transaction control

b. Multiplexing

c. Multiversion...