Q. The mantissa in -1.58E5 is __________

View solution

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