Oracle DBA Question: Download Oracle DBA PDF
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? |