SQL Data Types MCQ

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

• What is the default size of n in a column that has the datatype VARCHAR(n)?
  ক

  0

  খ

  NULL

  গ

  1

  ঘ

  Size of value entered
• Which of the following datatype is used for storing a maximum of one element from a predefined list consisting a maximum of 65535 elements?
  ক

  STORE

  খ

  LIST

  গ

  SET

  ঘ

  ENUM
• In SQL, if a value is entered in CHAR datatype which does not occupy all the length spaces then the remaining spaces will be occupied with blank spaces.
  ক

  True

  খ

  False
• In SQL, which of the following datatypes has a maximum length of 255 characters?
  ক

  TEXT

  খ

  TINYTEXT

  গ

  SMALLTEXT

  ঘ

  CHAR
• Which of the following datatype is used to display a combination of date and time information?
  ক

  DATETIME

  খ

  DATE

  গ

  TIME

  ঘ

  TIMESTAMP
• Which of the following command can be used to create a user defined datatype in SQL?
  ক

  CREATE DATA

  খ

  CREATE TYPE

  গ

  CREATE DATATYPE

  ঘ

  CREATE DATA TYPE
• What is the maximum value that can be stored in the datatype DECIMAL (5,2)?
  ক

  9999999

  খ

  99.99999

  গ

  999.99

  ঘ

  99999.99