-
Which DB2 components allows references to Oracle and DB2 databases in a single query?
Which of the following DB2 components allows references to Oracle and DB2 databases in a single query? A. DB2 Query Patroller B. DB2 Warehouse Manager C. DB2 Relational Connect D. DB2 Connect Enterprise Edition
-
Generate DDL?
If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.
-
DB2 generate ddl
If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table is in LOAD PENDING. D. The table is a replicated table. E. The table was created by a different user.
-
Call DSN8CC in COBOL
How will you call DSN8CC in a COBOL program and why it is used.
-
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