Question 1

You should back up your database before testing an action query.

Accepted Answer

It is always recommended to back up a database before running an action query to avoid any accidental changes or loss of data.

Question 2

The results of running an update query can be reversed using the Undo button.

Accepted Answer

Update queries modify the data in the database, and once executed, their effects cannot be reversed using an Undo button. To reverse the changes, you would need to run another query that specifically undoes the changes made by the first query.

Question 3

A purge query is used to remove records from a table.

Accepted Answer

A purge query is not a standard SQL command or function. The term "purge" might be used in some database management systems as a synonym for "delete," but there is no specific SQL command or function called "purge." The standard SQL command for removing records from a table is DELETE.

Question 4

You use a ________ query to select records of former employees from a table and use them to create a new table.&#10;A) create table&#10;B) merge tables&#10;C) combine tables&#10;D) make table

Accepted Answer

You would use a "make table" query to select records of former employees from a table and use them to create a new table. This would create a new table with the selected records, while leaving the original table intact.

Question 5

To find the same values in a table,you would use the Find ________ Query Wizard.&#10;A) Repeated&#10;B) Alike&#10;C) Matching&#10;D) Duplicates

Accepted Answer

The term "duplicates" suggests finding values that appear more than once in a table, which is the desired outcome according to the question prompt. Therefore, using the Find Duplicates Query Wizard would be the best choice.

Question 6

A(n)________ query is used to display aggregate data in a row-and-column layout.&#10;A) summary&#10;B) crosstab&#10;C) action&#10;D) outline

Accepted Answer

A crosstab query is used to display aggregate data in a row-and-column layout where one field is displayed down the rows and another field is displayed across the columns, with the intersection of the two fields displaying the sum, average, or other aggregate value of a third field.

Question 7

A select query is used to select records from one or more tables and use them to create a new table.

Accepted Answer

A select query is used to retrieve data from one or more tables, but it does not create a new table. Instead, it returns the result set which can be further manipulated, sorted or filtered.

Question 8

You would use a find duplicates query to find the same values in a table.

Accepted Answer

A find duplicates query is specifically designed to identify and display any duplicate values in a table.

Question 9

A(n)________ query is used to copy new employee records from one table and add them to an existing table.&#10;A) make table&#10;B) append&#10;C) select&#10;D) dispose

Accepted Answer

An append query is used to add new records from one table to another existing table. The make table query creates a new table, the select query retrieves data from a table, and the dispose query does not exist in SQL.

Question 10

A make table query selects records from one or more tables and uses them to create a new table.

Accepted Answer

The answer of A make table query selects records from...

Question 11

You would use a(n)________ query to remove the records of former employees from a table.&#10;A) erase&#10;B) dispose&#10;C) delete&#10;D) exclude

Accepted Answer

The answer of You would use a(n)________ query to remove...

Question 12

You would use a(n)________ query to make changes to the retail price field for records meeting a specified criteria.&#10;A) select&#10;B) update&#10;C) append&#10;D) make table

Accepted Answer

The answer of You would use a(n)________ query to make...

Question 13

You CANNOT edit a crosstab query.

Accepted Answer

The answer of You CANNOT edit a crosstab query....

Question 14

The ________ Query Wizard would be used to compare customer records in the Customer and Order tables to determine which customers have made no purchases.&#10;A) Find Unmatched&#10;B) List Unmatched&#10;C) Find Missing&#10;D) List Missing

Accepted Answer

The answer of The ________ Query Wizard would be used...

Deck 6: Action and Specialized Queries: Hands-On-Exercise Videos