Oracle DBA Question:
Name three SQL operations that perform a SORT.
Answer:
a. CREATE INDEX
b. DISTINCT
c. GROUP BY
d. ORDER BY
f. INTERSECT
g. MINUS
h. UNION
i. UNINDEXED TABLE JOIN
b. DISTINCT
c. GROUP BY
d. ORDER BY
f. INTERSECT
g. MINUS
h. UNION
i. UNINDEXED TABLE JOIN
| Previous Question | Next Question |
| Explain two easy SQL optimizations. | What is your favorite tool for day-to-day Oracle operation? |