Oracle Dba Interview Question and Answers

66. What are the different types of concurrent manager?
  Oracle Applications consist of several types of concurrent managers. The important ones are internal manager, standard manager and conflict resolution manager. Apart from these, you can define your own custom concurrent manager.
 
Your Name Your Email-ID
Your Answer
67. Name the three network components of RAC?
 
    The three network components of RAC are
  • public
  • private
  • VIP
 
Your Name Your Email-ID
Your Answer
68. What is Global Services Daemon(GSD)?
  GSD runs on each node and it not an Oracle background process. This process performs administrative tasks, such as startup and shut down, based on the requests from different clients such as DBCA and enterprise manager.
 
Your Name Your Email-ID
Your Answer
69. What is SQL*Loader?
  SQL*Loader is a tool to load data from file to a database table.
 
Your Name Your Email-ID
Your Answer
70. What is the capture process?
  Capture process extracts database changes from redo log files at source. It is a background process.
 
Your Name Your Email-ID
Your Answer