Saturday 23 November 2013

Oracle Interview Q/A Series - III

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