A.13. Chapter 13

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

    Answer: Closed and unavailable to users, open and available to users

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

    Answer: The failure of a disk drive containing database datafiles would be considered a media failure.

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

    Answer: The AS OF TIMESTAMP 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? ...

Get Oracle Database Foundations now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial