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. |
|
|
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.
|
|
|
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.
|
|
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.
|
|
|
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. |
|
|