Which of the following SQL command will help in incrementing values of FEES…

Key idea: To increase FEES by 10%, multiply the current value by 1.1 (100% + 10% = 110% = 1.1).

• Correct SQL to update all rows:

• UPDATE STUDENT SET FEES = FEES * 1.1;

• If you only want to change some rows, add a WHERE clause, for example: UPDATE STUDENT SET FEES = FEES * 1.1 WHERE <condition>;

Why the other statements are incorrect:

• Using ASSIGN is not valid SQL for UPDATE; the proper keyword is SET to assign an expression to a column.

• Writing FEES * 10% is invalid: the percent sign is not a numeric literal in SQL (and % can mean modulo in some dialects). To add 10% use FEES * 1.1 or FEES + FEES * 0.10.

• The fragment SET FEES 10% is syntactically incomplete and missing the '=' and a valid expression; it should be SET FEES = FEES * 1.1.