AP CSP Using Programs with Data (2.4)

• (genre = "mystery") AND ((1 ≤ num) AND (cost < 10.00))

• (genre = "mystery") AND ((1 < num) AND (cost < 10.00))

• (genre = "mystery") OR ((1 ≤ num) OR (cost < 10.00))

• (genre = "mystery") OR ((1 < num) OR (cost < 10.00))

The owner of a clothing store records the following information for each transaction made at the store during a 7-day period.

- The date of the transaction

- The method of payment used in the transaction

- The number of items purchased in the transaction

- The total amount of the transaction, in dollars

Customers can pay for purchases using cash, check, a debit card, or a credit card.

Using only the data collected during the 7-day period, which of the following statements is true?

• The average amount spent per day during the 7-day period can be determined by sorting the data by the total transaction amount, then adding the 7 greatest amounts, and then dividing the sum by 7.

• The method of payment that was used in the greatest number of transactions during the 7-day period can be determined by sorting the data by the method of payment, then adding the number of items purchased for each type of payment method, and then finding the maximum sum.

• The most expensive item purchased on a given date can be determined by searching the data for all items purchased on the given date and then sorting the matching items by item price.

• The total number of items purchased on a given date can be determined by searching the data for all transactions that occurred on the given date and then adding the number of items purchased for each matching transaction.

• Use the customer IDs in the purchases file to search the customers file to generate a list of e-mail addresses

• Use the product IDs in the purchases file to search the products file to generate a list of product names that use AA batteries

• Use the customers file to generate a list of customer IDs, then use the list of customer IDs to search the products file to generate a list of product names that use AA batteries

• Use the products file to generate a list of product IDs that use AA batteries, then use the list of product IDs to search the purchases file to generate a list of customer IDs, then use the list of customer IDs to search the customers file to generate a list of e-mail addresses

• Filter by photographer, then filter by year, then sort by subject

• Filter by photographer, then filter by year, then sort by year

• Sort by subject, then sort by year, then filter by photographer

• Sort by year, then filter by year, then filter by photographer

• (genre = "talk") AND ((day = "Saturday") AND (day = "Sunday"))

• (genre = "talk") AND ((day = "Saturday") OR (day = "Sunday"))

• (genre = "talk") OR ((day = "Saturday") AND (day = "Sunday"))

• (genre = "talk") OR ((day = "Saturday") OR (day = "Sunday"))

A wildlife preserve is developing an interactive exhibit for its guests. The exhibit is intended to allow guests to select the name of an animal on a touch screen and display various facts about the selected animal.

For example, if a guest selects the animal name “wolf,” the exhibit is intended to display the following information.

- Classification: mammal

- Skin type: fur

- Thermoregulation: warm-blooded

- Lifestyle: pack

- Average life span: 10–12 years

- Top speed: 75 kilometers/hour

The preserve has two databases of information available to use for the exhibit. The first database contains information for each animal’s name, classification, skin type, and thermoregulation. The second database contains information for each animal’s name, lifestyle, average life span, and top speed.

Which of the following explains how the two databases can be used to develop the interactive exhibit?

• Only the first database is needed. It can be searched by animal name to find all the information to be displayed.

• Only the second database is needed. It can be searched by animal name to find all the information to be displayed.

• Both databases are needed. Each database can be searched by animal name to find all information to be displayed.

• The two databases are not sufficient to display all the necessary information because the intended display information does not include the animal name.