Multiple Choice
Which of the following set operators can be used to make certain that only the rows returned by both queries are displayed in the results?
A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS
Correct Answer:
Verified
Correct Answer:
Verified
Q18: Which of the following terms refers to
Q19: When a self-join is created,each copy of
Q20: A column qualifier is separated from the
Q21: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg" alt=" Structure of
Q22: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg" alt=" Contents of
Q24: The _ operator is used to create
Q25: Equality,non-equality,and self-joins are broadly categorized as <u>outer
Q26: When combining the results of two <u>SELECT</u>
Q27: Joins are classified as _ joins if
Q28: An outer join operator can be included