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. |