UTEP Oracle 9i
UTEP Oracle 10g Notes

REVIEW QUESTIONS ANSWERS

Answer Q1: UNION only selects distinct values, and UNION ALL selects all values.

Answer Q2: Takes the result set of one SELECT statement, and removes those rows that are also returned by a second SELECT statement.

Answer Q3: c)

Answer Q4: a)

Answer Q5: BETWEEN