alleryStart learning →Which statement is used to modify existing data in a table?
AUPLOAD
BUPDATE
CUPGRADE
DUPHOLD
Answer & Solution
Correct answer: B. UPDATE
1. Rows already in a table sometimes need changing.
2. One statement changes values in place.
3. The UPDATE statement is used to modify existing data in a table.
4. So the answer is UPDATE.
_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Keep practising Structured Query Language
Browse all Structured Query Language questions for IGNOU MCA, or explore more Computer Science topics.