WebMusic’s database designer, Janet, has hired an intern. She has requested that this intern create some SQL queries that would be useful to managers tracking the day-to-day operations of the store.
-Janet wants her intern to make some changes to the contents of records in the store's database.Which of the following commands would the intern use?
A) PURGE
B) INSERT
C) JOIN
D) UPDATE

Question

Quizplus · Accepted Answer

The intern would use the UPDATE command to make changes to the contents of records in the database. PURGE is not a valid SQL command, INSERT is used to add new records to a database, and JOIN is used to combine data from multiple tables.

WebMusic’s Database Designer, Janet, Has Hired an Intern