R

Ram Avtar Sharma • 4.50K Points
Extraordinary 

Q. The date and time datatype that stores time value in 'hh:mm:ss' format is . . . . . . . .

  • (A) DATE
  • (B) 1.58
  • (C) DATETIME
  • (D) TIMESTAMP
  • Correct Answer - Option(B)
  • Views: 12
  • Filed under category MySQL
Explanation by: Ram Avtar Sharma 
This question is about different data types in MySQL that store time values. We need to find the data type that specifically stores time in the format 'hh:mm:ss'.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. What is data in a MySQL database organized into?

Q. What is the work of CREATE command?

Q. Which is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?

Q. '2341' is a . . . . . . . .

Q. The function used to convert a string to an int is . . . . . . . .

Q. Can "SELECT" clause be used without the clause "FROM"?

Q. The value of event_scheduler that enables checking status but not changing it at runtime is . . . . . . . .

Q. Hexadecimal numbers cannot be used in scientific notation.

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++);

Q. SQL can be used to

Learn All MySQL MCQs

Question analytics