Exam 1: Oracle Architecture Overview

Each datafile belongs to one ____________________ in a database.

Describe the OEM wizards feature of the Oracle10g suite.

Describe the Java / Web features of the Oracle10g suite.

____ is a valid client installation configuration.

The Enterprise ____________________ provides an option for the database administrator to reach the database from a remote computer.

To use the Oracle database,you start up a database instance,which allocates ____________________ for the database (called the System Global Area,or SGA)and starts up a set of background processes.

OFA provides standards intended to improve performance of the database by,among other things,spreading I / O functions across separate devices by separating data from software.

Oracle executable files are stored in a directory tree referred to as ____.

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

On Windows platforms,you assign a name to each Oracle Home directory and use a feature called Home ____________________ to change the current target.

On Windows,to run the Universal Installer in SILENT MODE,you can enter the following command in the directory in which Universal Installer resides: ____ -responseFile <filename> -silent

____________________ redo logs contain copies of current and past redo logs for recovery if needed.

Oracle ____________________ must be configured to define ports and the protocols allowed to send and receive data for each database in your network.

The combination of database software,a database (the files),and a database instance (the SGA and the background processes)is called a database agent.

SQL*Plus accepts standard SQL,with all the Oracle enhancements to SQL,such as the TO_DATE function.

The SQL*Plus executable file in a Windows installation is ____.

The client-side ____________________ installation option provides the user management tools,including the Enterprise Manager,to provide remote management of multiple databases.

A ____ file is an administrative file containing up-to-date information on the database structure,log files,checkpoints;critical file for opening the database.

Oracle has standardized its software so that it looks and acts identically at the user interface level on all platforms.

The Oracle Universal Installer provides a(n)____________________ MODE of installation that enables you to run an installation without any human intervention.