8.5. Review Questions

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

Get Oracle Database Foundations now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.