1. 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.

---

2. 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

---

---

3. 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’),

---

4. Which among the following is the correct syntax for defining “Constraint Check” in Mysql?
   

1. 1. gender char (1) check,

   
   
   

   2. gender char (1) check ( gender ),

   
   
   

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

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Check constraint constrains the allowable values for a particular column.

---

---

5. 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.

---