Oracle Managing Director Question and Answers

37. Where is the instruction about control file stored?
  Initialization parameter file or server parameter file stores the information about control file. The name of the parameter to store control file information is CONTROL_FILES.
 
Your Name Your Email-ID
Your Answer
38. At what stage of instance, startup information about control file is read (from parameter file)?
  Control file is required to mount the database; therefore the control file information should be available before mounting that is, at mount stage.
 
Your Name Your Email-ID
Your Answer
39. What view would you use to determine free space in a tablespace?
  The DBA_FREE_SPACE view can be used to determine free space in a tablespace.
 
Your Name Your Email-ID
Your Answer
40. How can you find out which rows are chained?
  You can use the LIST CHAIND ROWS clause with the ANALYZE table to get the list of chained rows. You need a specific table to store the result of this statement.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 10 of 10