Chapter 8
| 1. | What are the four functions of the Database Creation Assistant (DBCA)? | |
| 2. | What is the Oracle background process that writes modified data blocks to disk? | |
| 3. | What is the difference between a database and an instance? | |
| 4. | An extent is composed of one or more . | |
| 5. | True or false: The control file contains important system tables. | |
| 6. | What is the GUI-based Oracle tool that can manage and monitor one or more Oracle instances? | |
| 7. | DBCA can save the specified database parameters in what kind of file? | |
| 8. | Which Oracle background process will apply the data in the redo log files to the datafiles in the event of a system crash? | |
| 9. | A database schema is closely associated with which other database object? | |
| 10. | A segment consists of one or more . | |
Answers
| 1. | DBCA can create, delete, and modify databases. It can also create a template that can be used to create a database. |
| 2. | The DBWn process writes modified data blocks to disk. |
| 3. | A database is a set of files on disk that is managed by an instance, which is a collection of processes and memory structures that operate against the datafiles on disk. |
| 4. | Database blocks |
| 5. | False, the control file contains information about the physical structure of the entire database. |
| 6. | The Oracle Enterprise Manager (OEM) can manage and monitor one or more Oracle instances. |
| 7. | DBCA can save the database parameters as an HTML file. |
| 8. | The SMON process will apply the data in the redo log files to the datafiles in the event of a system crash. |
| 9. | A schema is associated 1:1 with a user account in the database. |
| 10. | Extents |
