1. Which of the following functions are not performed by “ALTER” clause?
   

1. 1. Change name of the column

   
   
   

   2. Change the name of the table

   
   
   

   3. Drop a column

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   All of above

---

2. Which among the following is the correct syntax for modifying the definition of an existing table?
   

1. 1. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT;

   
   
   

   2. ALTER TABLE person

   
   
   

   3. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

   
   
   

   4. ALTER TABLE person MODIFY person_id ;

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT;

---

---

3. Which statement makes changes to the database’s global attributes?
   

1. 1. ALTERNATE

   
   
   

   2. UPDATE

   
   
   

   3. CHANGE

   
   
   

   4. ALTER

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   The ‘ALTER TABLE’ statement is used to make changes to a database’s global attributes. This statement is followed by the name of the database, character set and collation.

---