Question

Which of the following is NOT an action query?

a) Append
b) Delete
c) Make Table
d) Summarize

Answer 1

The action query not listed among the options is 'Summarize,' as it refers to a select query for data retrieval rather than a query that modifies data.

Step-by-step explanation:

The action query that is NOT an action query among the options given is d) Summarize. Action queries in databases are used to modify sets of data in bulk. The types of action queries are:

• a) Append: This adds records from one or more tables to another table.
• b) Delete: This removes records from a table based on specific criteria.
• c) Make Table: This creates a new table with records from an existing table based on certain criteria.

The option "d) Summarize" does not refer to an action query but rather to a select query that retrieves data based on aggregate functions without modifying or appending any data.