CompTIA Study Materials
AWS Study Materials
AWS Cloud Practitioner AWS Cloud Practitioner
AWS Cloud Practitioner CLF-C02
Microsoft Study Materials
Microsoft Azure Fundamentals Microsoft Azure Fundamentals
Microsoft Azure Fundamentals AZ-900

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)?

  • 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'.

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

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

This question is for objective:
Database Fundamentals
Your Score:
Database Fundamentals
Infrastructure
Applications and Software
Software Development Concepts
Security
IT Concepts and Terminology