1. In the following query how many rows will be updated?
   

   UPDATE person
   SET Lname=’Gupta’,
   Fname=’Ajit’,
   WHERE person_id < 10;
   /* person_id is a primary key */
   

1. 1. 1-6

   
   
   

   2. No row

   
   
   

   3. 0-9

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   0-9

---

2. In the following query how many rows will be updated?
   

   UPDATE Employee
   SET Lname=’Gupta’,
   Fname = ’Ajit’,
   WHERE Emp_id = 101;
      /* person_id is a primary key */
   

1. 1. Double row

   
   
   

   2. No row

   
   
   

   3. Single row

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Single row

---

---

3. Which statement is used to delete an existing row from the table?
   

1. 1. WHERE

   
   
   

   2. MODIFY

   
   
   

   3. DELETE

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   DELETE

---

4. Which statement is used for updating existing information in the table?
   

1. 1. ALTER

   
   
   

   2. MODIFY

   
   
   

   3. WHERE

   
   
   

   4. UPDATE

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   UPDATE

---

---

5. Which keyword in the UPDATE statement is used to assign values to columns?
   

1. 1. MARK

   
   
   

   2. GET

   
   
   

   3. ASSIGN

   
   
   

   4. SET

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   The ‘UPDATE’ statement in MySQL has its own syntax. The ‘SET’ keyword is followed by an assignment list which indicates the set of columns whose value needs to be updated with a specified value.

---