What type of query should you create to populate new EmployeeFirst and EmployeeLast fields with atomic values from an EmployeeName field?
A)select query
B)update query
C)concatenation query
D)atomic query

Question

Quizplus · Accepted Answer

An update query is used to modify existing data in a database. In this case, it would be used to split the EmployeeName field into two separate fields (EmployeeFirst and EmployeeLast) by updating the new fields with the respective parts of the EmployeeName.

What Type of Query Should You Create to Populate New