String Data Types MCQ

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

• Which is the header that should be included first?
  ক

  my_global.h

  খ

  my_sys.h

  গ

  mysql.h

  ঘ

  my_local.h
• Which is the library file that contains various portability macros and definitions?
  ক

  my_global.h

  খ

  my_sys.h

  গ

  mysql.h

  ঘ

  my_local.h
• What is SBR replication?
  ক

  Statement based

  খ

  Row based

  গ

  Column based

  ঘ

  Table based
• Replication does not enable data from one MySQL database server to be copied to one or more MySQL database servers.
  ক

  True

  খ

  False
• What is used to reload a delimited text data file?
  ক

  mysqldump

  খ

  mysqld

  গ

  mysqlimport

  ঘ

  mysqlnaive
• For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option?
  ক

  –multiple-transaction

  খ

  –single-transaction

  গ

  –double-transaction

  ঘ

  –no-transaction
• What is the minimum value stored by signed TINYINT?
  ক

  -256

  খ

  -128

  গ

  0

  ঘ

  128
• Which mode does not remove trailing spaces when CHAR values are retrieved?
  ক

  PAD_CHAR_TO_FULL_LENGTH

  খ

  TO_FULL_LENGTH_CHAR_PAD

  গ

  CHAR_PAD_TO_FULL_LENGTH

  ঘ

  PAD_CHAR_TO_LENGTH
• The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________
  ক

  1

  খ

  3

  গ

  5

  ঘ

  8
• The maximum value that can be specified to the size of VARCHAR is _____________
  ক

  0

  খ

  127

  গ

  1023

  ঘ

  65535