What is the update statement used for ?The UPDATE statement is used to modify the existing records in a table.The UPDATE statement is used to delete recordsThe UPDATE statement is used to fetch records from a tableThe UPDATE statement is used to retrieve records from a table

Which SQL statement is used to update data in a database?Question 15Answera.UPDATEb.SETc.CHANGEd.MODIFY

2. Describe the differences between the SQL UPDATE and DELETE statements. When would you use one over the other, and what precautions should be taken?

Which Java statement is used to update data in a database table?Question 5Answera.ALTER TABLEb.UPDATEc.MODIFYd.CHANGE

Which of the following statements are DML statements?a)Update [tablename] set [columnname] = value;b)Delete [tablename]c)Select * from [tablename]

What is the purpose of the SELECT statement in SQL?To delete data from a tableTo insert new records into a tableTo retrieve data from a tableTo update existing records in a table