Answers to practice exam questions

A1: Answer: D.
A2: Answer: D. The other definitions are incorrect. REAL data consists of single-precision floating-point numbers, which can be less than, equal to, or greater than 21. DOUBLE data consists of double-precision floating-point numbers. SMALLINT data consists of small integers, but they need not be less than 22.
A3: Answer: B and D. The statements in the other options are false. Option A is false because no user-defined settings control how DB2 treats null values. Option C is false because a null value is not equivalent to a blank. Option E is false because a null value is not equivalent to a zero value.
A4: Answer: A. The statements in the other options are true. Option A is false because using an index ...

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.