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 requires the table to be arranged in a specific order (ASCENDING or DESCENDING) as defined by the KEY clause. For predictable results, the key must uniquely identify each table entry. If duplicates exist, SEARCH ALL may return any matching entry, making the result unpredictable. This requirement is due to the binary search algorithm used.

Keep practicing — related questions