Is "Datetime" and "Timestamp" are same data type?
A. Yes
B. No
C. Depends
D. None of the mentioned
Answer: Option A
Solution (By Examveda Team)
This question asks about the relationship between "Datetime" and "Timestamp" data types in MySQL.Let's break it down:
* Datetime: Stores a date and time value. It can represent dates from January 1, 1970, to December 31, 9999.
* Timestamp: Also stores a date and time value, but it has some unique features:
* It usually takes up less storage space than "Datetime".
* It can be automatically updated when a row is modified. This makes it useful for tracking changes in data.
So, are they the same? No! They have different storage requirements and behavior.
The correct answer is Option B: No.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion