Multiple choice technology

What is the function of Look up file?

  1. Returns the number of matching data records in a Lookup File.

  2. Returns successive data records from a Lookup File.

  3. Returns a data record from a partition of a Lookup File.

  4. Returns a data record from a Lookup File which matches with the values of expression argument.

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A Lookup File function returns a data record that matches the values of the expression argument passed to it. It searches the lookup file based on the expression and returns matching records. Option A is incorrect - it doesn't just return a count. Option B is incorrect - it doesn't return successive records unless they match. Option C is incorrect - it doesn't return from a specific partition without matching criteria.