Oracle DBA Question:
Download Job Interview Questions and Answers 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
Download Oracle DBA Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain two easy SQL optimizations. | What is your favorite tool for day-to-day Oracle operation? |