Which of the following is one of the set operators? Select one: O A, B, C, D
Answer: 1)
The set of operators in SQL are
1.UNION
2.UNION ALL
3.INTERSECT
4.EXCEPT
----------------------------------------------------
In the given options
1.UNION
As a combination of two or more SELECT statements. It is one of the SET operators.
2.UNION ALL
Combining of two or more SELECT statements but the difference of UNION and UNION ALL is UNION ALL allows duplicate rows.
3.INTERSECT ALL
Combining of two or more SELECT statements and returns the rows of first table that are similar to the second table
Intersect All it is a specification Operator it retrieves the rows but it doesnot eliminates duplicate rows
So ,it is one of the Set operator
4.EXCEPT ALL
It returns all the records in the first table which is not present in second table
So it is one of the Set Operator.
So the Anwer is NONE which is Option E.
Step by step
Solved in 2 steps
