Category: IBM DB2

IBM DB2 Interview Questions & Answers part 6 0

IBM DB2 Interview Questions & Answers part 6

Q: – What is the difference between UNION and UNION ALL? "UNION" eliminates duplicates but "UNION ALL" retains duplicates. Q: – How is a schema...

Shares 0
IBM DB2 Interview Questions & Answers part 5 0

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...

Shares 0
IBM DB2 Interview Questions & Answers part 4 0

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. –...

Shares 0
IBM DB2 Interview Questions & Answers part 3 0

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...

Shares 0
IBM DB2 Interview Questions & Answers part 2 0

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....

Shares 0
IBM DB2 Interview Questions & Answers part 1 0

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...

Shares 0