Which of the following SQL command will help in incrementing values of FEES…
2023
Which of the following SQL command will help in incrementing values of FEES column in STUDENT table by 10% ?
- A.
UPDATE STUDENT ASSIGN FEES FEES 1.1; / UPDATE STUDENT ASSIGN FEES FEES 1.1;
- B.
UPDATE STUDENT SET FEES = FEES * 1.1; / UPDATE STUDENT SET FEES = FEES 1.1;
- C.
UPDATE STUDENT SET FEES = FEES 10%; / UPDATE STUDENT SET FEES = FEES *10%;
- D.
UPDATE STUDENT SET FEES = 10%; / UPDATE STUDENT SET FEES = 10%;
Attempted by 1425 students.
Show answer & explanation
Correct answer: B
Correct Answer: UPDATE STUDENT SET FEES = FEES * 1.1; Explanation: To increase the FEES column by 10%, we multiply the existing FEES value by 1.1. This updates every student’s FEES with a 10% increment. Hindi Explanation: STUDENT