Exam 1: Oracle Architecture Overview

If you are running Enterprise Manager,SQL*Plus,Forms,or non-Oracle products,Oracle ____ is the gateway into the database.

If you install Oracle10g Enterprise Edition,Standard Edition,or Personal Edition and choose to have a predefined database created on installation,the database is configured in ____ mode.

The client-side ____________________ installation option is intended primarily for programmers who are developing applications on their own client machines while using a remote database as the connection to the database.

The ______________________________ (OFA)brings standard conventions to the directory structure and filenames for your Oracle software.

The OFA standards call for naming files according to their type and sequence of creation.

A(n)____________________ allows grouping of datafiles within an Oracle database.

A single machine cannot contain more than one value for ORACLE_HOME.

In a typical Oracle10g application system,the middle tier contains the Oracle10g database server.

____________________ redo logs record changes immediately.

A ____ file records changes to database data.

You cannot rename the files that Oracle creates (for example,the files created when you allow the installation to create a predefined database for you).

What does the Oracle10g RDBMS software suite include?

Current database files are stored in ____ / <database name>.

OEM stands for _________________________.

The client configuration is a combination of the user interface tier and the application server tier.

If you install upgrades or enhancements,the Oracle Universal Installer re-installs any previously existing subcomponents.

The Oracle Universal Installer keeps log records on your computer of previous installation activity.

The company called ____ offers a complete graphic information system software solution for computer-generated maps that stores all its data in your Oracle10g database.

The Oracle ____ package encrypts outgoing data before it goes onto the network or across the Internet.

A ____ is a physical file on the computer disk containing data,such as tables and indexes.