CompTIA ITF+ FC0-U61 Practice Question
Imagine you have a database with a table named 'Contacts'. You've been asked to update a user's phone number. Which of the following is the BEST way to approach this task while ensuring accuracy and minimizing the impact on other data?
Perform an update operation without specifying any conditions.
Locate the record by the user's unique ID, typically the primary key, and use an update statement to change the phone number.
Use the user's first name to find the correct record and update the phone number.
Update the phone number field for all records in the 'Contacts' table.