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 logs the before and after value of every column it modifies.

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

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

D.
The UPDATE statement modifies the values of specified columns in the rows of a table, view,
or underlying table(s) of a specified fullselect.

Explanation:


Leave a Reply