Which type of query creates a brand new table from query results?

Which type of query creates a brand new table from query results?

• A. Select Query - A view of the data
• B. Update Query - Updates or replaces existing data
• C. Make Table Query - Creates a brand new table from query results
• D. Delete Query - Deletes records

Answer: (C)

Make Table query creates a brand new table from the results of a query. It takes the selected fields and rows that match your criteria and writes them into a new table you name, without changing the source tables. This is what you’d use when you want to persist a subset or transformed view of data as its own physical table. In contrast, a Select query only displays data (and can be saved as a view or used to drive other operations), an Update query changes existing data in a table, and a Delete query removes records.

Make Table query creates a brand new table from the results of a query. It takes the selected fields and rows that match your criteria and writes them into a new table you name, without changing the source tables. This is what you’d use when you want to persist a subset or transformed view of data as its own physical table. In contrast, a Select query only displays data (and can be saved as a view or used to drive other operations), an Update query changes existing data in a table, and a Delete query removes records.