Quiz

• The Data Recovery Advisor handles both cases:when you cannot start up the database (because some required database files are missing,inconsistent,or corrupted) and when file corruptions are discovered during run time.
  • True
  • Flase
• Which of the following checks can the Health Monitor Perform?
  • Intuitive commit check
  • Memory check
  • Metadata check
  • Redo check
  • Transaction check
  • User alertness check
  • Undo segment check
• When a row is chained or migrated ,the I/O performance associated with this row decreases because the Oracle database server must scan more than one data block to retrieve the information for the row.
  • True
  • Flase
• Which of the following statements are ture for Oracle Database 11g Release2 ?
  • Deferred segment creation is alwarys enabled.You cannot control it.
  • You can control the deferred segment creation with the SEGMENT CREATION clause of the CREATION TABLE command.
  • Segment creation on demand is available for all types of tables,including those owned by the SYS user.
  • Segment creation on demand is available for nonpartitioned tables.