Wednesday, 5 September 2012

The following command is issued: LOAD FROM staff.ixf OF IXF REPLACE INTO staff What locks are help during the execution of this load?

A. Share lock on table STAFF
B. Exclusive lock on table STAFF
C. Exclusive lock on all table spaces holding components of the STAFF table
D. Exclusive lock only on table space holding data component of the STAFF table

Ans : B

No comments: