Workshop
The quiz and exercises are provided to help you solidify your understanding of the material covered today. Try to understand the quiz and exercise answers before continuing to tomorrow's lesson.
Quiz
| 1: | If you want to represent integer numbers from 0 up to 2,147,483,647, what column type would you use? |
| A1: | INT (signed or unsigned). |
| 2: | If you have a column of type SMALLINT with the attribute AUTO_INCREMENT, and existing rows contain the values 1, 4, 5, and 6, what value would be inserted into the column if a new row of data was added? |
| A2: | 7. |
| 3: | True or False: The maximum value of a TIME column is 23:59:59. |
| A3: | False. Values can range from -838:59:59 to 838:59:59. |
| 4: | True or False: When performing comparisons and sorting operations on data in ... |
Get Sams Teach Yourself MySQL in 21 Days, 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.
