📝 Question
#1053
If we want to retain all duplicates, we must write ________ in place of union.
✓
Correct Answer
A. Union all
💡
Explanation
Union all will combine all the tuples including duplicates. 5. (SELECT course id FROM SECTION WHERE semester = ’Fall’ AND YEAR= 2009) EXCEPT (SELECT course id FROM SECTION WHERE semester = ’Spring’ AND YEAR= 2010); a) Only tuples from second part b) Only tuples from the first part which has the tuples from second part c) Tuples from both the parts d) Tuples from first part which do not have second part Except keyword is used to ignore the values.
⌨️ Press
A
B
C
D
to select