DB2 expert Kent Milligan provides advice to Search400.com's members on a regular basis. Do you feel you're also a DB2 guru? Test your knowledge against some of Kent's recent Q&As below. Mark each question with either a True or False. Jot down your answer on a piece of paper, and then click over to the answer sheet to see if you agree with Kent's answer. If not, shoot us and e-mail and sound off and we'll post your response to the original question.
1. _____ Dynamic join means that the criteria is not applied until the query is actually run.
View Kent's answer
2. _____ SQL triggers require that journaling be in operation.
View Kent's answer
3. _____ There is a major difference between DB2/400 and DB2 UDB for the iSeries.
View Kent's answer
4. _____ It is possible to change the length of a field in a physical file without recompiling it.
View Kent's answer
5. _____ SQL views cannot be indexed.
View Kent's answer
6. _____ Multiple stream files can be copied into one DB2 file using wildcard (*) at the CPYFRMSTMF command.
View Kent's answer
7. _____ Row number is not supported on DB2, and as of this time there are no workarounds.
View Kent's answer
8. _____ "Internal index" means that if DB2 creates an index for the enforcement of a constraint, the index is hidden from the user/administrator.
View Kent's answer
If you enjoyed this puzzle, check out Search400.com's other games and puzzles.
This was first published in August 2004