Question

State true or false: We cannot write a where clause under an update command

(a) True

(b) False

I have been asked this question by my school teacher while I was bunking the class.

This interesting question is from Modification of Database in section Introduction to Relational Model and Sql of RDBMS

Answer 1

The correct answer is (b) False

To elaborate: Writing a where clause under the update statement enables us to specify a condition for the selection of tuples whose values need to be updated.