Oracle Managing Director Question and Answers

29. What is Automatic Segment Space Management (ASSM)?
 
  • ASSM is a method used to Oracle to manage space inside data blocks.
  • It eliminates the need to specify parameters, such as PCTUSED, freelist and freelist groups, for objects created in the tablespace.
 
Your Name Your Email-ID
Your Answer
30. 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
31. How can you get the information about log files and archive log files?
  There are different data recovery views, such as V$LOGFILE and V$ARCHIVE_LOG, to obtain information about log files and archiving log files.
 
Your Name Your Email-ID
Your Answer
32. What is the need to multiplex redo log file? How can you do that?
  Multiplexing is required to improve recoverability of the database in case of disk failure.
You can multiplex redo log file by maintaining more than one member in each group.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 8 of 10