1. What is the primary purpose of working with dates and times in MySQL?

2. Which MySQL data type is suitable for representing a specific moment in time, including date and time components?

3. What does the DATE data type store in MySQL?

4. Which MySQL data type is used to store time values with precision up to fractions of a second?

5. What is the primary purpose of the DATETIME data type in MySQL?

6. Which of the following MySQL data types is sensitive to time zone changes?

7. What does the YEAR data type store in MySQL?

8. Which MySQL function returns the current date and time?

9. What does the DATE_FORMAT() function in MySQL allow you to do?

10. Which function can be used to calculate the difference between two date or time values in MySQL?

11. In MySQL, which function extracts the date part from a DATETIME or TIMESTAMP value?

12. How can you improve the performance of date and time calculations in MySQL?

13. What is the primary advantage of storing timestamps in UTC format in MySQL?

14. Which SQL statement allows you to convert date and time values from one time zone to another in MySQL?

15. What is a typical use case for the TIMESTAMP data type in MySQL?

16. In MySQL, can you directly insert data into a TIMESTAMP data type column?

17. What is a common use case for the YEAR data type in MySQL?

18. How does the CURTIME() function in MySQL differ from the NOW() function?

19. What should you consider when working with dates and times in MySQL to ensure data accuracy?

20. Which of the following is not a common use case for working with dates and times in MySQL?

21. What is the purpose of using aliases in a DATE_FORMAT() function in MySQL?

22. In MySQL, which SQL statement allows you to modify an existing date and time value?

23. What does the TIMESTAMPDIFF() function in MySQL calculate?

24. Which MySQL function allows you to format date and time values as strings according to a specified format?

25. What is the primary benefit of working with dates and times efficiently in MySQL?