The type of query extract the data and put them into separate table A. A parameter query B. A make-table query C. An update query D. A crosstab query

The correct answer is: B. A make-table query.

A make-table query is a type of query that creates a new table from the results of another query. The new table can be used to store the results of the query, or it can be used to join with other tables in a database.

A parameter query is a type of query that allows you to enter a value when you run the query. This value is then used to filter the results of the query.

An update query is a type of query that changes the data in a table. You can use an update query to change the value of a field, or to delete a record from a table.

A crosstab query is a type of query that summarizes data in a table. The data is summarized by rows and columns, and the results are displayed in a table.

Here is an example of a make-table query:

SELECT *
FROM Customers
INTO NewCustomers

This query will create a new table called NewCustomers that contains all of the data from the Customers table.

Here is an example of a parameter query:

SELECT *
FROM Customers
WHERE City = @City

This query will select all of the customers from the Customers table who live in the city that is entered as the value of the @City parameter.

Here is an example of an update query:

UPDATE Customers
SET City = 'New York'
WHERE City = 'Los Angeles'

This query will change the city of all of the customers who live in Los Angeles to New York.

Here is an example of a crosstab query:

SELECT Country, SUM(Sales)
FROM Orders
GROUP BY Country
ORDER BY Country

This query will summarize the sales by country. The results will be displayed in a table with one row for each country and one column for the total sales for that country.