Multiple choice technology programming languages

Consider the following: A: IN RSREFR FPC RECTYPE = REPORT REPT.KEY IS PRESENT END FIND The above adhoc results in:

  1. Retrieves all records in RSREFR with RECTYPE = REPORT which contains atleast one occurrence of the field name REPT.KEY.

  2. Retrieves all records in RSREFR with RECTYPE = REPORT which contains no occurrence of the field name REPT.KEY

  3. Retrieves all records in RSREFR with RECTYPE = REPORT

  4. None of the above

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

The FIND command with IS PRESENT retrieves all records matching the conditions (RECTYPE = REPORT) that contain at least one occurrence of the specified field name REPT.KEY. The IS PRESENT clause filters for records where this field exists.