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: 23
  • 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.

Be the first to start discuss.

Related MCQs on MySQL

Q. What will be the output of the following MySQL command? SELECT * FROM person WHERE emp_id IS NULL;

Q. How is a delimited-text data file reloaded?

Q. What is abc in the following MySQL statement? SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject, subject_value. Intern_id = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} Subject_value = {0, 0, 1, 1, 2, 2, 3, 3} 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 IN (SELECT subject FROM db_name WHERE subject_value = 3);

Q. Find the error in the following MySQL statement? SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;

Q. What returns a string containing an error message?

Q. To execute the contents of a query file 'exec.sql' by feeding it to mysql, which command is used?

Q. To convert a string to an int, the function is . . . . . . . .

Q. The place where the server stores its databases and status files is called “data”?

Q. Which clause is used to "filter out unwanted Groups"?

Learn All MySQL MCQs

Question analytics