DB2/400 DB2 UDB Fact or Fiction?

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. If not, shoot us and

    Requires Free Membership to View

    Login

    Register today to access targeted resources from our editorial writers and independent industry experts including news, tips, and advice to help you do your job more efficiently and effectively. Stay informed on the hottest topics and biggest challenges faced by IT professionals working with iSeries products and services.

    By submitting your registration information to Search400.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of Search400.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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