フリー問題

問題文

A developer needs the loyalty tier for the current recipient, and the loyalty table holds one row per member keyed by member number. Which function fits best?

選択肢

1. The function that returns a single column value from the first matching row, because the search is on a value that identifies one member in that table.
2. The function that returns the first unclaimed row and marks it as taken, because the search assigns one available entry to one member in that table.
3. The function that returns a set of rows without a defined order, because the search is on a value that identifies one member in that table.
4. The function that returns a set of rows sorted by a chosen column, because the search needs the newest entry for one member in that table.