Q94.
Technology
The purchasing department uses one (1) shared database. Which of the following is the
function that prevents others from updating or referencing data when an employee is entering data?
a)
b)
c)
d)
Q95.
Technology
You want to calculate the amount of ingredients used per product based on the ingredient
usage table. Which of the following is the appropriate calculation method?
a)
b)
c)
d)
Q96.
Strategy
Shared lock
Restriction
Access right
Exclusive lock
Group by ingredient ID and add the amount used by product.
Group by product ID and add the amount used by ingredient.
After adding the total amount of ingredients used, sort it by product ID.
The amount of each ingredient cannot be calculated.
You want to put the monthly amount of ingredients used between January and December
2008 into a graph for comparison. Which of the following graphs is best suited for that purpose?
a)
t
Amount of ingredients used in 2008
b)
Amount of ingredients used
January
700
February
600
March
500
April
400
May
June
300
July
200
August
100
September
October
0
November
Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Nov. De c.
December
c)
Amount of ingredients used (t)
January
December
800
Amount of ingredients used
t
February
700
600
November
d)
March
400
600
500
200
October
April
0
400
300
200
September
May
100
June
August
July
397
0
Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Nov. Dec.