PrepAway - Latest Free Exam Questions & Answers

Which statement about UPDATE processing is FALSE?

Which statement about UPDATE processing is FALSE?

PrepAway - Latest Free Exam Questions & Answers

A.
The UPDATE statement modifies the values of specified columns in the rows of a table,

view, or underlying table(s) of a specified fullselect.

B.
The UPDATE statement logs the before and after value of every column it modifies.

C.
A searched UPDATE is used to update one or more rows and a positioned UPDATE is
used to update exactly one row.

D.
When the UPDATE statement modifies parent key columns, the value of corresponding
foreign key columns are also modified.


Leave a Reply