-
What is an intent lock?
An intent lock is at the table level for a segmented tablespace or at the tablespace level for a nonsegmented tablespace. They indicate at the table or tablespace level the kinds of locks at lower levels.
-
-
Explain the EXPLAIN statement ?
The explain statement provides information about the optimizer's choice of access path of the sql.
-
What is referential integrity?
Referential integrity refers to the consistency that must be maintained between primary and foreign keys, ie every foreign key value must have a corresponding primary key value.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
DB2 Interview Questions
Ans