IBM 000-556 training materials

3.Which Committed Read isolation level statement is correct? 

A. It locks all rows examined. 

B. It does not check for locks. 

C. It checks for locks after returning a row. 

D. It checks for locks before returning a row. 

Answer: D 

4.Which two values can be used for connection type field from sqlhosts file when using Distributed 
Relational Database Architecture (DRDA) protocol? (Choose two.) 

A. ontlitcp 

B. onipcshm 

C. onsoctcp 

D. drtlitcp 
E. drsoctcp 

Answer: D,E 

5.Which type of isolation level results in a lock on every row a query examines in order to retrieve any row 
from the result set? 

A. DIRTY READ 

B. COMMITTED READ 

C. CURSOR STABILITY 

D. REPEATABLE READ 

Answer: D