Q. What will be the storage pattern for “float(4,2)” in Mysql?

View solution

Q. Which among the following are the correct representation of “float(4,2)”?

View solution

Q. Which among the following is the correct representation of “float(5,0)”?

View solution

Q. Which among the following is the correct representation of “float(1,1)”?

View solution

Q. Which data type is used to store data and time in Mysql?

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Is “Datetime” and “Timestamp” are same data type?

View solution

Q. Which value will show an error when stored in float(4,2)?

View solution

Q. The datatype for single precision floating point number is ____________

View solution

Q. Which datatype is used for a fixed length binary string?

View solution

Q. Which datatype means a variable length non binary string?

View solution

Q. Which data and time datatype stores time value in ‘hh:mm:ss’ format?

View solution

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

View solution

Q. How many of the following attributes are allowed only for numeric types?

UNSIGNED, ZEROFILL, CHARACTER SET, COLLATE

View solution

Q. A DEFAULT value cannot be supplied to spatial types.

View solution

Q. A DEFAULT value cannot be supplied to TEXT types.

View solution