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?
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
- Test your knowledge
- from OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
- Publisher: Packt Publishing
- Released: February 2013