S

Shiva Ram • 30.44K Points
Instructor I 

Q. What is the default format for "Timestamp" data type?

  • (A) YYYY-MM-DD HH:MI:SS
  • (B) MM-YYYY-DD HH:MI:SS
  • (C) DD-YYYY-MM MI:HH:SS
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 16
  • Filed under category MySQL
Explanation by: Shiva Ram 
This question is about how MySQL stores dates and times.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. The variable used to set table alias names as non case sensitive is . . . . . . . .

Q. The bit-field values are prefixed with . . . . . . . .

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject. Intern_id = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} If these are one to one relation then what will be the output of the following MySQL statement? SELECT intern_id FROM db_name WHERE subject NOT IN (c, c++, oop);

Q. Which spatial datatype is used to store a curve?

Q. Which of these returns a string containing an error message?

Q. Which mode is used to turn on strict mode and all of the additional restrictions?

Q. The following MySQL statement is valid. SELECT abc, xyz FROM table1 UNION abc, def FROM table2;

Q. How many files does each end of a client/server connection including SSL support use to set up secure communications?

Q. Varrays are a good choice when

Q. In MYSQL, can we write keywords in any letter case?

Learn All MySQL MCQs

Question analytics