what does the following update statement do ordertable set orderdiscount orderdiscount1 10what..., ANSI SQL, Databases

Test
- Model Test
Index

Question:What does the following Update statement do?
Update OrderTable set OrderDiscount=OrderDiscount*1.10What does the following Update statement do?


Update OrderTable set OrderDiscount=OrderDiscount*1.10

A Increases OrderDiscount of first row by 10% 
B Increases OrderDiscount of all rows by 10% 
C Does nothing without where clause 
D Gives an error due to lack of where clause

/30

+ AnswerB

+ Report

Descriptive on ANSI SQL Ebook

Total Preview: 893

Question:What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount*1.10

A Increases OrderDiscount of first row by 10%

B Increases OrderDiscount of all rows by 10%

C Does nothing without where clause

D Gives an error due to lack of where clause

B

Question:What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount1.10What does the following Update statement do? Update OrderTable set OrderDiscount=OrderDiscount1.10