IBM DB2 Interview Questions & Answers part 5
Q: - What is an index key?
It is a column or set of columns in a table used to determine the order of index...
IBM DB2 Interview Questions & Answers part 4
Q: - When you use "create database" command than by default which table spaces creates?
The create database command creates three default table spaces.
- SYSCATSPACE
-...
IBM DB2 Interview Questions & Answers part 3
Q: - Which of the following is NOT a characteristic of a data warehouse?
A. Summarized queries that perform aggregations and joins
B. Heterogeneous data sources
C....
IBM DB2 Interview Questions & Answers part 2
Q: - Which of the following is NOT a valid method of authentication that can be used by DB2 9?
A. SERVER
B. SERVER_ENCRYPT
C. CLIENT
D. DCS
The...
IBM DB2 Interview Questions & Answers part 1
Q: - Which of the following DB2 objects is NOT considered executable using SQL?
A. Routine
B. Function
C. Procedure
D. Trigger
The correct answer is D. Routines are...