MySQL Questions and Answers – Table Creation

This set of MySQL Multiple Choice Questions & Answers (MCQs) focuses on “Table Creation”.

1. Which among the following is the correct syntax for creating table?
a) CREATE TABLE name;
b) CREATE name;
c) CREATE TABLE
d) All of the mentioned
View Answer

2. What is the role of “CONSTRAINS” in defining a table in Mysql?
a) Declaring primary key
b) Declaring Foreign Key
c) Restrictions on columns
d) All of the mentioned
View Answer

3. Which command is used for the table definition in Mysql?
a) DESC table_name;
b) DESC table_name
c) DESC
d) None of the mentioned
View Answer

4. Which among the following is the correct syntax for defining “Constraint Check” in Mysql?
a) gender char(1) check( gender IN (‘M’, ‘F’)),
b) gender char (1) check,
c) gender char (1) check ( gender ),
d) none of the mentioned
View Answer

5. Which data type character merge the “Check Constraint” into a data type definition?
a) ENUM
b) ENUM1
c) ENUM2
d) None of the mentioned
View Answer

6. Which among the following is the correct syntax for defining “ENUM” in Mysql?
a) gender ENUM (‘M’, ‘F’),
b) gender ENUM,
c) gender ENUM ( ),
d) none of the mentioned
View Answer

7. Which among the following are the correct definitions for “NULL” in Mysql?
a) Absence of value
b) Unknown
c) Empty set
d) All of the mentioned
View Answer

8. Find out the logical error in the following query?

   CREATE TABLE person
   ( person_id VARCHAR(20),
    Name VARCHAR (20),
    Address VARCHAR (20),
    Mobile_no  SMALLINT 
    );

a) Lesser number of columns
b) Incorrect definition
c) Primary key is missing
d) None of the mentioned
View Answer

9. What is meaning of “REFERENCES” in table definition?
a) Primary key
b) NULL
c) Foreign Key
d) A ”foreign Key” belong to this particular table
View Answer

10. What default value gets stored in columns of the table?
a) NULL
b) 0
c) 1
d) -1
View Answer

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.