O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required