13.5. Review Questions

  1. A cold database backup occurs when a database is ________, and a hot database backup occurs when a database is _______.

  2. The failure of a disk drive containing database datafiles would be considered what kind of a failure?

  3. What clause in a SELECT statement specifies the time and date for an Oracle flashback query?

  4. The flashback query tool uses which Oracle structure to retrieve information on how a table appeared at some specified point in the past?

  5. True or false: A flashback query can retrieve the DDL statement needed to undo a change made to a table in the past.

  6. An abnormal termination of the Oracle server software would be considered what type of database failure?

  7. Which Oracle utilities can be used by a database user to back up and restore a table and by a DBA to move a tablespace from one database to another?

  8. Which Oracle structure allows the automatic recovery of the Oracle database after an instance failure?

  9. What option of the Import (IMP) command allows the DBA to view the DDL contained in a dump file without executing those DDL commands?

  10. What is the name of the feature of Oracle's Export and Import utilities that allows a DBA to move or copy an entire tablespace from one database to another?

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset