Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

DB2/400 DB2 UDB Fact or Fiction?

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.

Kent Milligan

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.

Dig Deeper on DB2 UDB (universal databases)

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close