To which of the following resources can a lock NOT be applied?
A. Table spaces
B. Buffer pools
C. Tables
D. Rows
2 Comments on “which of the following resources can a lock NOT be applied?”
rasays:
B.
Buffer pools
0
0
Chow, Kenneth KYsays:
Partition, table space, and table lock modes
When a page or row is locked, the table, partition, or table space that contains it is also locked. This intent lock indicates the plan that the application process has for accessing the data. In that case, the table, partition, or table space lock has one of the intent modes: either IS for intent share, IX for intent exclusive, or SIX for share with intent exclusive.
B.
Buffer pools
0
0
Partition, table space, and table lock modes
When a page or row is locked, the table, partition, or table space that contains it is also locked. This intent lock indicates the plan that the application process has for accessing the data. In that case, the table, partition, or table space lock has one of the intent modes: either IS for intent share, IX for intent exclusive, or SIX for share with intent exclusive.
0
0