Question

To change a value in a tuple without changing all the values in the tuple, we use the _____ statement

(a) insert

(b) insert some

(c) update

(d) alter

I have been asked this question in an interview for job.

I'd like to ask this question from Modification of Database in section Introduction to Relational Model and Sql of RDBMS

Answer 1

Right answer is (c) update

Explanation: To change a value in a tuple without changing the entire values in the tuple, we use the update statement. Eg: update employee set salary = salary*1.5;