11. What default value gets stored in columns of the table?
    

1. 1. -1

   
   
   

   2. 1

   
   
   

   3. 0

   
   
   

   4. NULL

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   NULL is the default value as it stands for “Absence of value”.

---

12. In the following query, what does “person” stands for:
    

    INSERT INTO Student
        (id, fname, lname) 
        VALUES (1,’Ajit’,’Gupta’);
    

1. 1. Multivalued attributes

   
   
   

   2. Table name

   
   
   

   3. Composite attributes

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   Table name

---

---

13. In the following query, what does “person_id” stands for?
    

     CREATE TABLE Student
       (id SMALLINT UNSIGNED,
       fname VARCHAR(20),
       lname VARCHAR(20) ,
       CONSTRAINT pk_Student PRIMARY KEY (Student_id));
    

1. 1. Primary key

   
   
   

   2. Composite key

   
   
   

   3. Normal attribute of the table

   
   
   

   4. Super key

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   Primary key is also termed as a super key.

---

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

---

---

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

---