Q. If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________

View solution

Q. The NUL (‘\0’) is same as the SQL NULL value.

View solution

Q. The escape sequence for carriage return is ___________

View solution

Q. Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?

View solution

Q. x’ffff’ in decimal is ___________

View solution

Q. X’61626364′ and X’61626364′ are respectively __________

View solution

Q. The number of legal hexadecimal values among 0x0a, 0x0A, 0X0a and 0X0A is ___________

View solution

Q. A binary string is not associated with a character set.

View solution

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