You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers
by using a database table named Volunteer.
The table has the following columns and rows:
When volunteer information changes, you must update the table. You need to change Tia’s name to
Kimberly. Which statement should you choose?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Hi,
Isn’t the correct answer “Option D” ?
Yes
Agreed. Proper Order is:
UPDATE Table_Name
SET Field_Name/Column_Name
WHERE PrimaryKey =
However it is best to use the unique primary key in the where clause (what if there were more than one Tia. Then all records with Tia would be changed to Kimberly.
Best practice:
BEGIN TRAN
UPDATE Volunteer
SET GivenName = ‘Kimberly’
WHERE ID = ‘1’
–COMMIT
–ROLLBACK
option D is correct according to given table
Correct answer is D. Does anyone even read the comments? 🙂
D
correct option is D