Databases Reference
In-Depth Information
Review Questions
1.
A cold database backup occurs when a database is ________, and a hot data-
base 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?
