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.