Exam 1: Oracle Architecture Overview

The ____ engine included with the Oracle software provides a specialized programming language you can use for creating triggers,packages,and procedures.

The primary purpose of the OFA naming standards is to speed up the process of identifying files.

JVM stands for ____________________.

The Oracle database has three types of files: control files,database files,and ____________________ log files.

A unique feature of the Oracle Universal Installer is its ability to install several versions of Oracle software on a single machine by setting up a separate directory structure for each version and its software components.

JDM stands for ____________________.

The Oracle 10g Standard Edition for servers can be upgraded with database features,such as partitioning and clustering.

RDBMS stands for ________________________________________.

The <database name> is usually stored as the ____ environment variable.

If you are upgrading from an earlier version to Oracle10g,you need to install the Oracle10g database with the pre-configured settings.

Regardless of which installation option you select,the Oracle ____________________ Installer handles the job.

Only one database can be managed within OEM.

When installing Oracle10g on Windows 2000,you should not install Service Pack 3 before installing the Oracle software because it has some incompatibility issues with Oracle.

The ____ tool allows you to create and run queries,add rows,modify data,and write reports using SQL.

The OFA naming standards are only recommendations,not requirements.

A tablespace may use only one datafile.

All Oracle software files and database storage files reside on subdirectories under ____.

In Windows,the default ORACLE_BASE directory is ____.

Oracle customized its software release on each platform at the lowest levels to optimize performance based on each platform's characteristics.