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 the query was initiated, also known as "snapshot too old"?
a. ORA-00060
b. ORA-00600
c. ORA-1555
d. ORA-2306
Q 5. Which of the following is not a valid database parameter related to the usage of undo data?
a. undo_management
b. undo_segments
c. undo_retention...
