Free CompTIA ITF+ FC0-U61 Practice Question

What is the MOST appropriate way to update the email address for a user named 'John Doe' in a database, knowing that there may be multiple users with that name, but each user has a unique identifier (UserID)?

  • Issue a SELECT command to find all users named 'John Doe' and update the email address individually for each record returned.

  • Use an UPDATE statement to change the email address where the UserID matches John Doe's unique identifier.

  • Use an UPDATE statement that changes the email address where the user's first name is 'John' and the last name is 'Doe'.

  • Use an UPDATE statement with the correct email address where the UserName is 'jdoe'.

This question's topic:
CompTIA ITF+ FC0-U61 / 
Database Fundamentals
Your Score:

Check or uncheck an objective to set which questions you will receive.