Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query.
(a) Base, recursive
(b) Recursive, Base
(c) Base, Redundant
(d) View, Base
The question was posed to me during an online interview.
This intriguing question comes from Recursive Queries and Aggregation Features in section SQL : Queries, Constraints and Triggers of Database Management