Databases Reference
In-Depth Information
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 flash-
back 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?
Answer:
The undo tablespace contains information that is used to reconstruct 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.
Answer:
False, the flashback query feature does not provide the DDL for undoing changes. Log Miner is the
tool that 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?
Answer:
An abnormal termination of the Oracle server software would be considered an instance failure and
therefore a nonmedia 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?
Answer:
The Import (IMP) and Export (EXP) 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?
Answer:
The redo log files ensure that all committed transactions are applied to the database in the event of
an instance failure.
9.
What option of the Import (IMP) command allows the DBA to view the DDL contained in a dump file with-
out executing those DDL commands?
Answer:
The SHOW=Y 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?
Answer:
The transportable tablespace feature of Oracle's Export and Import utilities allows a DBA to move
or copy an entire tablespace from one database to another.
