Q. The BIGINT precision is of bit _________

View solution

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

View solution

Q. If a string is to be converted to a number, it is converted into a _____________

View solution

Q. The bit-field values are prefixed with __________

View solution

Q. A BIT value in a result set is displayed as a binary string.

View solution

Q. ‘2341’ is a ____________

View solution

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