A.8. Chapter 8

  1. What are the four functions of the Database Creation Assistant (DBCA)?

    Answer: DBCA can create, delete, and modify databases. It can also create a template that can be used to create a database.

  2. What is the Oracle background process that writes modified data blocks to disk?

    Answer: The DBWn process writes modified data blocks to disk.

  3. What is the difference between a database and an instance?

    Answer: 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. An extent is composed of one or more ______________.

    Answer: Database blocks

  5. True or false: The control file contains important system tables.

    Answer: False, the control file ...

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.