Answers to practice exam questions
A1: | Answer: D. Temporary tables are useful for sorts or queries of large intermediate result tables when only a subset of the rows needs to be stored. The types of tables in the other options are not particularly suited for this situation. |
A2: | Answer: B. The reasons in options A and C justify use of a null value in the MGRNO column. The situation in option B does not justify use of a null value. For example, a new department might be created and a manager assigned. The MGRNO number would hold the ID of the manager, regardless of whether any employees are assigned to the department. |
A3: | Answer: A. EMPNO is the best candidate for a unique key because the Employee table is likely to have multiple rows with the same ... |
Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.