Hour 2, "Defining Data Structures"

Quiz Answers

1: True or false: An individual's Social Security number can be any of the following data types: constant-length character, varying-length character, numeric.
A1: True, as long as the precision is the correct length.
2: True or false: The scale of a numeric value is the total length allowed for values.
A2: False. The precision is the total length, where the scale represents the number of places reserved to the right of a decimal point.
3: Do all implementations use the same data types?
A3: No. Most implementations differ in their use of data types. The data types prescribed by ANSI are adhered to, but may differ between implementations according to storage precautions taken by each vendor.
4: What are ...

Get Sams Teach Yourself SQL in 24 Hours, Second 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.