(7) What is the purpose of an external index?

Question: What is the purpose of an external index?   [signinlocker] SOLUTION An external index allows data to be accessed in a logical order that differs from the physical order in which it is stored. [/signinlocker]

(5) Identify a common task in a payroll system for which sequential access is more appropriate than direct access, and explain why this is so?

QUESTION: Identify a common task in a payroll system for which sequential access is more appropriate than direct access, and explain why this is so?   [signinlocker] SOLUTION Printing monthly (weekly, bi-weekly) payroll checks is the classic example since typically, virtually every employee receives a monthly (weekly, bi-weekly) payroll check. [/signinlocker]