Question discussion

Which of the following statements correctly updates the Bill column in the Customer table by applying a 10% discount only for customers who…

359406Medium DSSSB TGT Computer Science 0 replies 0 views
0
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?
  • AMODIFY Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';
  • BUPDATE Customer SET Bill = Bill / 1.1;
  • CUPDATE Customer SET Bill = Bill / 1.1 WHERE Account = 'High privilege';
  • DUPDATE Customer (Bill) VALUES (Bill / 1.1) WHERE Account = 'High privilege';
Correct answer: C

Explanation

UPDATE with a WHERE clause on Account = 'High privilege' changes only those customers' bills. MODIFY is not an SQL command.

Discussion 0

Nobody has replied yet. Start the discussion!