Oracle Managing Director Question and Answers

25. What is the control file?
 
  • Control file is a file that contains all the information about the physical structure of the database, such as number of log files and their location.
  • Oracle database server uses control file to find its physical component.
 
Your Name Your Email-ID
Your Answer
26. What is PCTINCREASE?
  PCTINCREASE determines the size of next extent with respect to the current extent.
 
Your Name Your Email-ID
Your Answer
27. What happens when control file is damaged?
  You cannot restore the database if control file is damaged.
 
Your Name Your Email-ID
Your Answer
28. How does row chaining affects the performance?
  Chained rows do not affect the performance if we need to fetch data from the first block only. It affects the performance only if we need to fetch data from any other block besides the first block.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 7 of 10