Data Value Categories MCQ

Test your knowledge with important Data Value Categories MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Data Value Categories MCQs at Bissoy

• Which character set variable indicates the character set used for storing identifiers?
  ক

  character_set_system

  খ

  character_set_server

  গ

  collation_server

  ঘ

  character_set_database
• To measure the length of a string in bytes, the operator used is __________
  ক

  CHAR_LENGTH()

  খ

  LENGTH()

  গ

  LEN()

  ঘ

  SIZE()
• What is used to produce a new string from an old string in the desired character set?
  ক

  Introducers

  খ

  CONVERT()

  গ

  CONVERTER()

  ঘ

  CONVERTS()
• A binary string is not associated with a character set.
  ক

  True

  খ

  False
• The number of legal hexadecimal values among 0x0a, 0x0A, 0X0a and 0X0A is ___________
  ক

  1

  খ

  2

  গ

  3

  ঘ

  4
• X’61626364′ and X’61626364′ are respectively __________
  ক

  abcd and 1633837924

  খ

  abcd and 4297383361

  গ

  dcba and 1633837924

  ঘ

  dcba and 4297383361
• x’ffff’ in decimal is ___________
  ক

  65534

  খ

  66535

  গ

  65536

  ঘ

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

  NO_ESCAPES_SLASH

  খ

  NO_ESCAPES_BACKSLASH

  গ

  NO_BACKSLASH_ESCAPES

  ঘ

  NO_BACKSLASH_ESCAPE
• The escape sequence for carriage return is ___________
  ক

  ‘\c’

  খ

  ‘\r’

  গ

  ‘\b’

  ঘ

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

  True

  খ

  False
• If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________
  ক

  identifier-quoting character

  খ

  string-quoting character

  গ

  hexadecimal

  ঘ

  string
• ‘2341’ is a ____________
  ক

  integer

  খ

  floating point

  গ

  hexadecimal

  ঘ

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

  True

  খ

  False
• The bit-field values are prefixed with __________
  ক

  0b

  খ

  0bit

  গ

  bit-

  ঘ

  ‘bit’
• If a string is to be converted to a number, it is converted into a _____________
  ক

  double precision floating point

  খ

  single precision floating point

  গ

  decimal integer

  ঘ

  hexadecimal integer
• The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________
  ক

  32

  খ

  64

  গ

  65

  ঘ

  16
• The BIGINT precision is of bit _________
  ক

  32

  খ

  64

  গ

  128

  ঘ

  16
• The mantissa in -1.58E5 is __________
  ক

  -1.58

  খ

  1.58

  গ

  E

  ঘ

  5
• Hexadecimal numbers cannot be used in scientific notation.
  ক

  True

  খ

  False
• Numbers prefixed with ‘0x’ are in base __________
  ক

  8

  খ

  16

  গ

  32

  ঘ

  64