Oracle Dba Interview Question and Answers

56. What is the use of Oracle Cluster Registry(OCR)?
  OCR stores information about cluster resources and their configuration. The CRS process uses that information to manage resources.
 
Your Name Your Email-ID
Your Answer
57. What are the different types of connection load balancing?
 
    There are two types of connection load balancing are :
  • Server side load balancing
  • Client side load balancing
 
Your Name Your Email-ID
Your Answer
58. What is downstream capture?
  Generally, capture process functions at source database. However, if you want to save resources at the source database, you can set up another database for the capture process only. The feature, allows you to move capture process to another database, is called downstream capture.
 
Your Name Your Email-ID
Your Answer
59. What is system change number?
  SCN is an ID that Oracle generates for every transaction. It is recorded with the corresponding change in a redo entry.
 
Your Name Your Email-ID
Your Answer
60. What is an SID?
  The SID is the system identifier. This environment variable is used to determine which database to connect to.
 
Your Name Your Email-ID
Your Answer