Table Creation MCQ

Test your knowledge with important Table Creation MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Table Creation MCQs on Bissoy. Bissoy App

• What default value gets stored in columns of the table?
  ক

  NULL

  খ

  0

  গ

  1

  ঘ

  -1
• What is the meaning of “REFERENCES” in table definition?
  ক

  Primary key

  খ

  NULL

  গ

  Foreign Key

  ঘ

  A ”foreign Key” belong to this particular table
• Which among the following are the correct definitions for “NULL” in Mysql?
  ক

  Absence of value

  খ

  Unknown

  গ

  Empty set

  ঘ

  All of the mentioned
• Which among the following is the correct syntax for defining “ENUM” in Mysql?
  ক

  gender ENUM (‘M’, ‘F’),

  খ

  gender ENUM,

  গ

  gender ENUM ( ),

  ঘ

  none of the mentioned
• Which data type character merges the “Check Constraint” into a data type definition?
  ক

  ENUM

  খ

  ENUM1

  গ

  ENUM2

  ঘ

  None of the mentioned
• Which among the following is the correct syntax for defining “Constraint Check” in Mysql?
  ক

  gender char(1) check( gender IN (‘M’, ‘F’)),

  খ

  gender char (1) check,

  গ

  gender char (1) check ( gender ),

  ঘ

  none of the mentioned
• Which command is used for the table definition in Mysql?
  ক

  DESC table_name;

  খ

  DESC table_name

  গ

  DESC

  ঘ

  None of the mentioned
• What is the role of “CONSTRAINS” in defining a table in Mysql?
  ক

  Declaring primary key

  খ

  Declaring Foreign Key

  গ

  Restrictions on columns

  ঘ

  All of the mentioned
• Which among the following is the correct syntax for creating table?
  ক

  CREATE TABLE name;

  খ

  CREATE name;

  গ

  CREATE TABLE

  ঘ

  All of the mentioned