Q. What is used to produce a new string from an old string in the desired character set?

View solution

Q. To measure the length of a string in bytes, the operator used is __________

View solution

Q. Which character set variable indicates the character set used for storing identifiers?

View solution

Q. Character data can be stored as ______________

View solution

Q. Which declaration represents that “character data will consume the same number of bytes as declared and is right padded”?

View solution

Q. Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?

View solution

Q. The maximum length of the char columns is ____________

View solution

Q. The maximum length of the varchar columns is ____________

View solution

Q. In oracle database variable length column is declared by ____________

View solution

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