Oracle Dba Interview Question and Answers

91. What kind of information is stored in a control file?
  Control file stores information about log switches, checkpoints and modification in disk resources.
 
Your Name Your Email-ID
Your Answer
92. What are the components of Oracle Clusterware?
 
    The components of Oracle Clusterware are given as follows :
  • Oracle Process Monitor Daemon
  • RACG Process
  • Oracle Notification Service
  • Event Manager
  • Cluster Ready Service(CRS)
  • Cluster Synchronization Services(CSS)
 
Your Name Your Email-ID
Your Answer
93. What is a multi node installation?
  A multi–node installation is the one in which the database tier and the application tier are installed across two or more nodes.
 
Your Name Your Email-ID
Your Answer
94. What is the difference between SPFILE and PFILE?
 
  • Oracle can use both SPFILE and PFILE as initialization parameter files.
  • SPFILE is a binary file while PFILE is a text file.
  • You can change the values in PFILE by directly editing it but those changes would not take effect until the restart of the database.
 
Your Name Your Email-ID
Your Answer
95. What is an extent?
  An extent is the unit of space that a schema object allocates when it is created or grows. As a table increases in size and fills up all its space, another extent is allocated. An extent is a continuous groups of blocks.
 
Your Name Your Email-ID
Your Answer