Which query type updates or replaces existing data?

Which query type updates or replaces existing data?

• A. Select Query
• B. Update Query
• C. Append Query
• D. Make Table Query

Answer: (B)

Updating existing data means changing values in records that are already stored. An update query targets specific rows (using a condition) and sets new values for chosen fields. It can replace values, such as changing a status from 'Inactive' to 'Active', or modify multiple fields for all matching rows. The key is that the underlying data in the table is altered. In contrast, a select query retrieves data without changing anything, an append query adds new rows to a table, and a make table query creates a new table from the results of a query without modifying the existing table.

Updating existing data means changing values in records that are already stored. An update query targets specific rows (using a condition) and sets new values for chosen fields. It can replace values, such as changing a status from 'Inactive' to 'Active', or modify multiple fields for all matching rows. The key is that the underlying data in the table is altered.

In contrast, a select query retrieves data without changing anything, an append query adds new rows to a table, and a make table query creates a new table from the results of a query without modifying the existing table.