Oracle
Interview Questions / Answers Series brings you some top interview
questions which are frequently asked in interviews (Interview FAQ). You
should try answering these questions and in other posts of this blog and
check your answers against the standard answers at Interview Questions Answers
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
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