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. Multiversioning
d. Atomicity
Q 3. Which type of statement does not write change vectors to the log buffer?
a. SELECT
b. INSERT
c. UPDATE
d. DELETE
Q 4. Which Oracle error is raised in situations where a query encounters an undo block that had been overwritten since ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
