UTpaper

Free mock tests & test series

Question 2Asked in DSSSB TGT Computer Science (Technical), 13 Sep 2025, Shift 3 (5:00 PM)

Which of the following statements correctly updates the Bill column in the Customer table by

Which of the following statements correctly updates the Bill column in the Customer table by applying a 10% discount only for customers who belong to the 'High privilege' account?
  1. AMODIFY Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';
  2. BUPDATE Customer SET Bill = Bill / 1.1;
  3. CUPDATE Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';
  4. DUPDATE Customer (Bill) VALUES (Bill / 1.1) WHERE Account = 'High privilege';
Show answerHide answer

Correct answer: (C) UPDATE Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';

Explanation

UPDATE ... SET ... WHERE changes only the rows that match. Dividing by 1.1 gives the discounted bill, and the WHERE clause limits it to 'High privilege' accounts. MODIFY is not DML, and B has no WHERE.

From DSSSB TGT Computer Science PYQ (Technical), 13 Sep 2025, Shift 3 (5:00 PM)

This is question 2 of DSSSB TGT Computer Science PYQ (Technical), 13 Sep 2025, Shift 3 (5:00 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.