Which of the following SQL statements will change all the records from the table Courses that begin with ITM and change it to BTM?
A) CHANGE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM'
B) CHANGE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM'
C) UPDATE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM'
D) UPDATE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM'
E) None of the above

Question

Quizplus · Accepted Answer

The correct SQL syntax to update records in a table is the UPDATE statement followed by the SET clause to specify the new value, and the WHERE clause to specify which records should be updated. Option D correctly follows this syntax to change records from 'ITM' to 'BTM'.

Which of the Following SQL Statements Will Change All the Records