Chapter 13 | Oracle9i DBA JumpStart

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 what Oracle structure to retrieve information on how a table appeared at some specified point in the past?
5.	True or false: 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.	What 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?

Answers

1.	Closed and unavailable to users, open and available to users.
2.	The failure of a disk drive containing database datafiles would be considered a media failure.
3.	The AS OF TIMESTAMP clause in a SELECT statement specifies the time and date for an Oracle flashback query.
4.	The undo tablespace contains information that is used to reconstruct how a table appeared at some specified point in the past.
5.	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 an instance failure, and therefore a nonmedia failure.
7.	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.	The redo log files ensure that all committed transactions are applied to the database in the event of an instance failure.
9.	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.	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.