CPT 172 Chapter 6 Quiz

When is it generally useful to run a delete query? a. A delete query is usually run before an update query. b. A delete query is usually run after an append or make table query. c. A delete query is usually run after an update query. d. A delete query should only be run when you need to delete data permanently from a database.

b.

Which statement is true about update queries? a. If you run an update query more than once, you will receive an error message. b. Update queries should be executed with caution because you cannot undo their changes. c. Only database administrators can run update queries. d. You can only use an update query to change text values in a table.

b.

In a large products table that you have acquired from an external source, you find that there are repeating product IDs. You need to set ProductID as the primary key field in this table. What is the best way to resolve this problem? a. Create a delete query to delete the repeating values. b. Leave the table as is because there are already orders related to the duplicate product IDs. c. Use a find duplicates query to locate duplicate product IDs. Delete the duplicates and associate all orders for that product to the remaining product ID. d. Delete the duplicate product IDs manually.

c.

What is the purpose of a row heading in a crosstab query? a. To display values from a selected field along the top of a crosstab query b. To use a function to summarize data in the intersecting cells c. To display values from a selected field along the left side of the datasheet in the results d. To determine which values you want to update

c.

Which one of the following tasks cannot be completed with an action query? a. Creating a new table based on a group of selected records b. Updating records in a table c. Finding unmatched values between tables d. Deleting records from a table

c.

Which type of query would you run to preview the results before running one of the other three? a. Delete query b. Append query c. Select query d. Update query

c.

Why would you use an append query? a. To summarize the data in a firm's database to help managers evaluate their financial position b. To determine which records may need to be deleted from the database c. To copy records from one table to another based on criteria that you specify d. Because users need to be able to select records based on varied selection criteria

c.

What is the best way to find students who have not handed in a certain assignment? a. Create a select query for assignments and examine the results for missing dates. b. Create a select query of assignments for the students in the class and examine the results for missing student names for each assignment. c. Create a select query for assignments and compare the results with the student roster. d. Create a find unmatched query using the student and assignment tables.

d.

What would you do if you ran an update query inadvertently? a. Run a delete query to delete the modified records. b. Restore the original records from your backed-up copy of the database. c. Manually modify all of the changes that were updated in the table. d. Use the Undo command to reverse the changes to the records.

d.

Why is it a good idea to delete an update query after it runs? a. It is not important; you can always undo the results of an update query. b. Update queries can be used to delete records from your tables. c. An update query can erase your table and create a new one in its place. d. Update queries are capable of changing values (such as prices) more than one time.

d.