Oracle Managing Director Question and Answers

17. What are the advantages of using locally managed tablespace?
  Following are the major advantages of locally managed tablespace.
  • Reduced contention on data dictionary tables
  • No rollback generated
  • No coalescing required
  • Reduced recursive space management
 
Your Name Your Email-ID
Your Answer
18. Define the redo log group and the redo log member?
 
  • Redo log group is a set of identical redo log files.
  • Each log file in the group is referred to as a redo log member.
  • A database needs to maintain at least two redo log groups.
 
Your Name Your Email-ID
Your Answer
19. Can you recover a control file?
  No, a backup of control file generates a script to create a new control file.
 
Your Name Your Email-ID
Your Answer
20. 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
12345678910 Page 5 of 10