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.

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

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

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.

An extent is composed of one or more ______________.

Answer: Database blocks

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

Answer: False, the control file contains information about the physical structure of the entire database.

What is the GUI-based Oracle tool that can manage and monitor one or more Oracle instances?

Answer: The Oracle Enterprise Manager (OEM) can manage and monitor one or more Oracle instances.

DBCA can save the specified database parameters in what kind of file?

Answer: DBCA can save the database parameters as an HTML file.

Which Oracle background process will apply the data in the redo log files to the datafiles in the event of a system crash?

Answer: The SMON process will apply the data in the redo log files to the datafiles in the event of a system crash.

A database schema is closely associated with which other database object?

Answer: A schema is associated 1:1 with a user account in the database.

A segment consists of one or more _____________.

Answer: Extents