Which of these has special automatic update behavior?

Solution (By Examveda Team)

This question is about different data types in MySQL and how they behave when you update data.
Let's break down each option:
* Option A: DATE - Stores a date (like '2023-12-18'). Updating a DATE value is simple; you just change the date. * Option B: TIME - Stores a time (like '10:30:00'). Similar to DATE, updating TIME involves changing the time value. * Option C: TIMESTAMP - Stores a timestamp (a combined date and time). This is the special one! Whenever you insert a new row or update a row in a table, MySQL automatically sets the TIMESTAMP column to the current date and time. You don't need to manually update it. * Option D: YEAR - Stores a year (like 2023). Updating a YEAR value is straightforward; you change the year.
So, the answer is Option C: TIMESTAMP.
This is because it has a special automatic update behavior, while the other options do not.