Q. Mysql support different character sets, which command is used to display all character sets?

View solution

Q. Which one is the correct declaration for choosing the character set other than default?

View solution

Q. Which “text type” has the maximum number of bytes?

View solution

Q. Which among the following have the maximum bytes?

View solution

Q. What will happen if the data being loaded into a text column exceeds the maximum size of that type?

View solution

Q. Which data type is more suitable for storing “small notes” in Mysql?

View solution

Q. Which data type is more suitable for storing “documents” in Mysql?

View solution

Q. “Numeric Data” is used to store ____________

View solution

Q. Which Numeric Data type has the largest range?

View solution

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