Q. What is SQL?
Q. Explain Inner Join and Outer Join with an example.
Q. What is a Predicate? What is the difference between "WHERE" and "HAVING"?
Q. What is the difference between "ROWNUM" and "ROWID"?
Q. What is the difference between Union and Join operations?
Q. Compare operators IN and EXISTS.
Q. Differentiate between DELETE and TRUNCATE commands.
Q. What is DUAL table in Oracle database?
Q. Explain the use of NVL function in Oracle?
Q. What are important aspects of ORDER BY clause?
Also Read : Oracle Interview Q/A Series - II