PrepAway - Latest Free Exam Questions & Answers

Which statement should you choose?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Option A

B.
Option B

C.
Option C

D.
Option D

8 Comments on “Which statement should you choose?

  1. Kyle says:

    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




    4



    0

Leave a Reply