問題文
A geospatial helper must accept a bounding box and return every monitoring station inside it, so that the result can be joined to a readings table. Which object shape matches?
選択肢
- A regular view that lists every station, filtered by the bounding box in each calling query.
- A scalar user-defined function that returns an array of station identifiers, joined directly to the readings table.
- A stored procedure that returns a result set and a bounding box, referenced in the FROM clause of the joining query.
- A user-defined table function that returns a set of rows, referenced in the FROM clause of the joining query.