Multiple choice technology mainframe

The result of SEARCH ALL is predictable only when the table is defined with ASCENDING or DESCENDING KEY and the key should uniquely identify an occurrence of the table entry.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SEARCH ALL uses a binary search algorithm, which requires the table to be sorted in a known order (ASCENDING or DESCENDING). Additionally, for binary search to work correctly and predictably, each key value must be unique so the search can definitively locate a single occurrence. Option A correctly states both requirements.

Keep practicing — related questions