6. Which data type character merge the “Check Constraint” into a data type definition?
   

1. 1. ENUM1

   
   
   

   2. ENUM2

   
   
   

   3. ENUM

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   ENUM

---

7. Which among the following is the correct syntax for defining “ENUM” in Mysql?
   

1. 1. gender ENUM,

   
   
   

   2. gender ENUM ( ),

   
   
   

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

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

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

---

---

8. Which among the following are the correct definitions for “NULL” in Mysql?
   

1. 1. Empty set

   
   
   

   2. Absence of value

   
   
   

   3. Unknown

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   Empty set, Absence of value and Unknown are the following are the correct definitions for “NULL” in Mysql.

---

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

   CREATE TABLE Employee
      ( Emp_id VARCHAR(50),
       Emp_Name VARCHAR (50),
       Emp_Address VARCHAR (50),
       Emp_Mobile_no  SMALLINT 
       );
   

1. 1. Primary key is missing

   
   
   

   2. Lesser number of columns

   
   
   

   3. Incorrect definition

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   Primary key is an essential attribute for each table declared in Mysql.

---

---

10. What is the default value of column?
    

1. 1. 0

   
   
   

   2. -1

   
   
   

   3. Undefined

   
   
   

   4. NULL

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   When table is defined in Mysql then each column related to table will contain NULL Value as default.

---