9-10
Which of the following product groups can be found when searching the “Product Inventory” table for products with a sales price of 500 dollars or more per unit and an inventory of
less than 10 units?
Product Inventory
Product
Code
Product Name
Manufacturer
Sale
Price
Inventory
Inspector
AAA
300,000
10
Smith
110
Medium refrigerator
AAA
200,000
6
Smith
120
Small refrigerator
BBB
100,000
8
Smith
130
Portable refrigerator
BBB
40,000
3
Smith
200
Air purifier
CCC
60,000
22
Miller
210
Air ionizer
DDD
45,000
18
Miller
300
Coffee maker
EEE
15,000
5
Johnson
400
Air conditioner
FFF
120,000
7
Brown
a) Large refrigerator, medium refrigerator, small refrigerator, air purifier, and air conditioner
)
b Large refrigerator, medium refrigerator, small refrigerator, portable refrigerator, air
purifier, coffee maker, and air conditioner
)
c Medium refrigerator, small refrigerator, and air conditioner
d) Medium refrigerator, small refrigerator, portable refrigerator, coffee maker, and air
conditioner
9-11
Technology element
Large refrigerator
Chapter 9
100
Which of the following is the problem that may occur when multiple users change one file
and overwrite it concurrently?
a) Many files with the same name are created and the users cannot distinguish them.
b) Only the contents overwritten by the last user remain, and the previous modifications
are lost.
c) The file is moved onto the PC of the user who modified the file previously, and other
users cannot find the file.
d) Modified contents are automatically added at the end of the file and the file size increases.
304