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?
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
Q 3. Which type of statement does not write change vectors to the log buffer?
Q 4. Which Oracle error is raised in situations where a query encounters an undo block that had been overwritten since ...