Q91.
d
Section
9-3 Database
Answer
The rate of increase based on the sales performance for the last month and two (2) months
ago is calculated by taking the difference between the sales performance last month and two
(2) months ago, and di viding it by the sales performance two (2) months ago.
Q92.
b
Section
9-3 Database
Answer
As in Q90, it is efficient to extract and sort the data, and calculate the total sales. However,
since the total sales is by state, the member number is needed as a key that links to the member ledger.
Q93.
b
Section
7-1 Basic theory
Answer
The number of postcards needed for the vehicle inspection discount promotion is calculated
using the “logical sum.” The logical sum is the union set, so the formula is “A+B.”
Q94.
c
Section
7-1 Basic theory
Answer
All customers of both passenger cars and mini-cars are included. To calculate the number using the logical sum, the customers in both lists are merged into one list, so the correct number
is six (6) customers.
Q95.
a
Section
7-1 Basic theory
Answer
The new vehicle discount promotion is for customers who purchased a passenger vehicle excluding mini-cars, so the correct answer is a).
b): Passenger vehicle and mini-car.
c): Mini-car excluding passenger vehicle.
d): Passenger vehicle other than mini-car, or mini-car other than passenger vehicle.
35