DB2-UDB-V7-1-Family-Fundamentals-(000-512).pdf - IBM...

000-512
IBM
DB2 UDB V7.1 Family Fundamentals

Answer: E
QUESTION: 98
Given the following: A table containing a list of all seats on an airplane. A seat consists of a seat
number and whether or not it is assigned. An airline agent lists all the unassigned seats on the
plane. When the agent refreshes the list from the table, it should only change if another agent
unassigns a currently assigned seat. Which of the following isolation levels should be used for this
application?
A. Read stability
B. Repeatable read
C. Cursor stability
D. Uncommitted read
Answer: A
QUESTION: 99
Which of the following isolation levels will lock only the rows returned in the result set?
QUESTION: 100
Given the following table with a primary key on empid:
Give the following statement in an embedded SQL program bound with Repeatable Read:
Select * from Emp where empid < 55
40