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

---

2. Will this query produce any error?
   

   INSERT INTO Employee
   (Emp_id, fname,lname)
   VALUES (101,’Sujit’,'Gupta'),
   VALUES (102,’Ajit’,’Gupta’);
   /* where person_id is a primary key */
   

1. 1. No Error

   
   
   

   2. Error

   
   
   

   3. Depends

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   No Error

---

3. Will this query produce any error?
   

   INSERT INTO Employee
     (Emp_id, fname,lname)
     VALUES (101,’Sujit’,’Gupta’),
     VALUES (101,’Ajit’,’Gupta’);
    /* where person_id is a primary key */
   

1. 1. Depends

   
   
   

   2. Error

   
   
   

   3. No Error

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   Emp_id declared as a primary key therefore it never contain same value.

---

4. Which feature is used for automatic increment of the column?
   

1. 1. AUTO

   
   
   

   2. INCREMENT

   
   
   

   3. AUTO_INCREMENT

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   AUTO_INCREMENT

---

5. Which statement can be used for modifying the definition for an existing table?
   

1. 1. FROM

   
   
   

   2. SELECT

   
   
   

   3. Modified

   
   
   

   4. ALTER

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   ALTER

---