Here you can find Oracle DBA Interview Questions and Answers.
In this Oracle DBA Interview Questions and Answers section you can learn and practice Oracle DBA Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Oracle DBA interview.
AllIndiaExams provides you lots Oracle DBA Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Oracle DBA Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of Oracle DBA Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Oracle DBA technical interview.
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.
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.
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.
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.
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.
Name three Oracle Utilities?
Oracle utilities include The SQL*Loader The Export utility and The Import utility
What is the difference between PGA and SGA?
The basic difference between SGA and PGA is that PGA cannot be shared between multiple processes, in the sense, that it is used only for requirements of a particular process whereas the SGA is used for the whole instance and it is shared.
What is Partial Backup?
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
What is admin server?
The admin server is that node of the APPL_TOP from which all the maintenance activities for Oracle Applications are performed.
What is rapidclone?
Rapidclone is the new cloning utility which is used for autoconfig enabled environments. Rapidclone leverages the new installation and configuration technology utilized by RapidInstall.