Oracle Managing Director Question and Answers

9. What is row migration?
 
  • Whenever a row length increase, as a result of an update and the current block is unable to provide additional space, the row has to be moved to another block with sufficient space.
  • In such situation , the original location of the row holds the rowid of the new location.
 
Your Name Your Email-ID
Your Answer
10. Explain the steps of creating copy of a control file?
  Following are the steps to create a copy of control file.
  • Shutdown the database using the shutdown normal, shutdown immediate, or shutdown transactional command.
  • Copy the control file to another disk using operating system's file copy command.
  • Modify the CONTROL_FILE parameter in initialization parameter file to include additional control file.
  • Restart the instance
 
Your Name Your Email-ID
Your Answer
11. What is freelist?
 
  • Freelist is a bitmap kind of structure in the header of every segment in which every bit maps to a block in the segment.
  • This list can be used to determine which blocks are available to insert new rows.
 
Your Name Your Email-ID
Your Answer
12. Can you change SHARED_POOL_SIZE online?
  Yes, you can change SHARED_POOL_SIZE online by using the following statement:
  • SQL> alter system set SHARED_POOL_SIZE = 200M scope =spfile and restart.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 3 of 10