Solved

Which of the Following SQL Statements Will Change All the Records

Question 27

Multiple Choice

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q22: A _ key is a field that

Q23: Which of the following SQL statements is

Q24: Which statement is true?<br>A) All the statements

Q25: Which of the following is not an

Q26: The relational entity is connected to each

Q28: A simple rule of thumb for determining

Q29: The _ operator uses the wildcard character

Q30: The relational entity uses the _ key

Q31: The _ operation creates a single table

Q32: To designate a character or text constant