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

Oracle Interview Q/A Series - II

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 a Database System?

Q. What is Data?

Q. What are different models of popular database systems?

Q. State some important properties of Relational Data Base Management System (RDBMS)?

Q. What are different forms of SQL statements?

Q. Explain the term predicate with reference to a data query?

Also Read : Oracle Interview Q/A Series - I
Q. What is a Database System?
Q. What is a Database System?

Oracle Interview Q/A Series - I



Oracle Interview Q/A Series brings you those choicest questions which are frequently asked interview questions (Interview FAQ). You may try to answers these questions from  your own knowledge and check your answers against those standard answers at Interview Questions Answers

Q.      What do you mean by “Logical” and “Physical” storage in Oracle database system?


Q.      What are the components of Physical Storage in Oracle database system? 

Q.      What are the components of Logical Storage in Oracle database system?


Q.      What is the importance of a Control File?

 
Q.      My Oracle database contains only one Control File. Is it OK for operating the database?

Q.      Why Oracle uses Tablespace for storing tables? OR Why not oracle use concept of one table per file like storage?

Q.      Explain Online and Offline Redo Log Files.