Given the following master file containing employee names (key field)and hourly rates,which of the following transactions would cause an error message to occur?
$$\begin{array}{l}
\text { Master File }\
\begin{array} { l l }
\text { John } & 20.00 \
\text { Mary } & 10.00 \
\text { Sue } & 6.00 \
\text { Tom } & 8.00 \
\text { Vince } & 13.00
\end{array}
\end{array}$$
A)Add Mary 20.00
B)Delete Mary
C)Delete Sue
D)Change Tom 8.00

Question

Given the following master file containing employee names (key field)and hourly rates,which of the following transactions would cause an error message to occur?
$$\begin{array}{l}
\text { Master File }\
\begin{array} { l l } 
\text { John } & 20.00 \
\text { Mary } & 10.00 \
\text { Sue } & 6.00 \
\text { Tom } & 8.00 \
\text { Vince } & 13.00
\end{array}
\end{array}$$
A)Add      Mary      20.00
B)Delete      Mary
C)Delete      Sue
D)Change      Tom     8.00

Quizplus · Accepted Answer

The master file already contains a record for Mary, so adding another record for Mary would cause an error message to occur.

Given the Following Master File Containing Employee Names (Key Field)and