Answers to practice exam questions
| A1: | Answer: C. The statements in the other options are true. Option C is false because DB2 records the definition of a base table in the DB2 catalog, not in the DB2 directory. |
| A2: | Answer: C. Option A is not valid because it is missing a closing parenthesis after (EMPNO). Both option A and option B are not valid because VARCHAR is spelled incorrectly as VAR CHAR. Option D is not valid because the CREATE TABLE syntax includes “NAME,” which is not a valid keyword. |
| A3: | Answer: B. VARCHAR is the best data type of people's last names because they are character data of varying lengths. |
| A4: | Answer: B. Option B is the only INSERT statement that has a part cost ($45.99) that exceeds the product cost ($42.99). |
| A5: | Answer: C. ... |
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.
