Oracle Dba Interview Question and Answers

1. What is Oracle HTTP server?
  Oracle HTTP server is the Web server which is used by Oracle Applications. It processes all the requests received from the clients. The Web server includes a couple of additional components like Web listener, Jserv (Java Servlet Engine) and Java Server Pages.
 
Your Name Your Email-ID
Your Answer
2. What is Oracle Streams?
 
  • The Oracle streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between databases.
  • It provides tools to capture, process(stage), and manage database events through Advanced Queuing queues.
 
Your Name Your Email-ID
Your Answer
3. What is the difference between database and instance?
  Database is a collection of data files that contain the information of interest; whereas, instance is the combination of background processes and memory structure.
 
Sandeep,said Mar 05,2014
A database is simply a collection of Datafiles which contains the actual data whereas an instance is the combination of some process(Background Process) which we need to instantiate before working on those datafiles or actual databases. If we need to put some queries on the database then we need to start an instance first.
Your Name Your Email-ID
Your Answer
4. What are the three types of files that make up an Oracle database?
 
    The three types of files that make up an Oracle database are :
  • Datafiles
  • Control files and
  • Redo log files.
 
Your Name Your Email-ID
Your Answer
5. What is the Oracle Enterprise manager?
  The Oracle Enterprise Manager is the new graphical administration tool designed to help the DBA manage one or more Oracle systems.
 
Your Name Your Email-ID
Your Answer