Multiple Choice
What is the result of the following SQL statement?
UPDATE employee
SET salary = 50000
WHERE salary < 50000;
A) The statement sets the salary for each employee to below 50,000
B) The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000
C) The statement increases salary to 50,000 for each employee whose salary is below 50,000
D) The statement sets the salary of each employee to 50,000
Correct Answer:

Verified
Correct Answer:
Verified
Q62: VEHICLE<br>Observe the table VEHICLE that contains
Q63: HAPPY INSURANCE<br>Observe the HAPPY INSURANCE DATABASE:<br>CLIENT<br>
Q64: What is a nested query?
Q65: HAPPY INSURANCE<br>Observe the HAPPY INSURANCE DATABASE:<br>CLIENT<br>
Q66: What is the purpose of the UPDATE
Q68: DCL commands are used to manage database
Q69: What is the purpose of the HAVING
Q70: HAPPY INSURANCE<br>Observe the HAPPY INSURANCE DATABASE:<br>CLIENT<br>
Q71: HAPPY INSURANCE<br>Observe the HAPPY INSURANCE DATABASE:<br>CLIENT<br>
Q72: What is the result of the following