> > >

MySQL MCQs

What is true regarding the TIMESTAMP data type?

For one TIMESTAMP column in a table, you can assign the current timestamp as the default value and the auto-update value

TIMESTAMP columns are NOT NULL by default, cannot contain NULL values, and assigning NULL assigns the current timestamp

When the server runs with the MAXDB SQL mode enabled, TIMESTAMP is identical with DATETIME

A TIMESTAMP column cannot have a default value

None of the above is true

Answer

Correct Answer: When the server runs with the MAXDB SQL mode enabled, TIMESTAMP is identical with DATETIME

Explanation:

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it