Oracle Dba Interview Question and Answers

76. What is a single node installation?
 
  • Single node installation is the one in which all the servers (concurrent processing, forms, Web, reports), the database and all product directories are installed on a single node.
  • In other words, in single node installation the entire Oracle applications are installed on a single server.
 
Your Name Your Email-ID
Your Answer
77. What are Ad utilities?
 
  • Ad utilities stand for application DBA utilities.
  • These are a set of tools used for installing, upgrading, maintaining and patching Oracle Applications.
  • There are around 15 Ad utilities, which are shipped along with Oracle Applications.
 
Your Name Your Email-ID
Your Answer
78. What is an interconnect network?
  An interconnect network is a network between nodes of a cluster. It uses switches to ensure that only nodes can access this network, Generally, this is a high speed connection.
 
Your Name Your Email-ID
Your Answer
79. What is a shared server process?
  The shared server process handles more than one user process. The dispatcher queues the job and the shared server process executes it.
 
Your Name Your Email-ID
Your Answer
80. What is read consistency?
  Read consistency allows a long running transaction to always obtain the same data within the query.
 
Your Name Your Email-ID
Your Answer