Which type of query automatically creates a new table from data that already exists in a database?
A)Make Table
B)Update
C)Append
D)Delete

Question

Quizplus · Accepted Answer

The Make Table query in SQL automatically creates a new table using data that already exists in a database. It copies the selected data to a new table with the specified name and structure. This query is useful when you want to extract certain data from an existing table and store it in a new table for further analysis or reporting. Update, Append, and Delete queries manipulate existing data within a table but do not create a new one.

Which Type of Query Automatically Creates a New Table from Data