Day 13
Quiz
| 1: | From where is the system date and time for a relational database normally derived? |
| A1: | The system date is derived from the current date and time of the operating system on the host machine. |
| 2: | List the standard internal elements of a DATETIME value. |
| A2: | YEAR, MONTH, DAY, HOUR, MINUTE, SECOND. |
| 3: | What could be a major factor concerning the representation and comparison of date and time values if your company is an international organization? |
| A3: | The awareness of time zones may be a concern. |
| 4: | Why is it not a good idea to store an individual's age in a database? |
| A4: | An individual's age changes from day to day and with every second of every day. It is better to store more constant values in a database if possible, such as an individual's ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth 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.
