V

Vishal Gupta • 7.73K Points
Tutor III 

Q. What is the default format for the data type “Year”?

  • (A) YYYY
  • (B) YYYY-DD-MM
  • (C) MM-YYYY-DD
  • (D) None of the above

Correct answer: Option(A)

MySQL Share
Explanation by: Vishal Gupta 
The default format for the data type “Year” is YYYY.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. Which statement is not true?

Q. The number of rows in the table is 10. Suppose all rows are deleted. The new row starts with sequence number . . . . . . . .

Q. Which one of the syntaxes given below is of Binary Operator?

Q. The DECIMAL used for expressions containing only exact values with fractional part is of digit precision . . . . . . . .

Q. What is xyz in the following statement?

Q. ‘x’ in the following statement is

Q. How many of the following does not return a value?

Q. How many of the following can be used in stored procedures? PREPARE, EXECUTE, DEALLOCATE PREPARE

Q. The variables or expressions passed from the calling subprogram are

Q. SIGNTYPE lets you restrict an integer variable to the values -1, 0, and 1, which is useful in programming tri-state logic.

Learn All MySQL MCQs