Oracle9i DBA JumpStart

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 .

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