Database programming section 9 quiz

Which of the following are correct set operators?
Answer: D.
Set operators are used to combine the results of two (or more) SELECT statements.
Valid set operators in Oracle 11g are UNION, UNION ALL, INTERSECT, and MINUS..
Will intersect give you the common rows found in both queries?
Expert-Verified Answer.
True, the INTERSECT operator in SQL is used to combine the results of two SELECT queries and return only the common rows found in both result sets.
It compares the results and identifies matching records based on the specified columns..
Will minus give you rows from the first query that are not present in the second query True or false?
The MINUS operator returns only the rows that are present in first result set but that are not in the second set.
The MINUS results are always distinct or unique rows, because MINUS eliminates any duplicate rows..
An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria.

Which of the following are correct set operators?