Question 1

____________________ (such as Pro*COBOL and Pro*C)support embedded SQL commands within programs in C,C++,or COBOL.

Accepted Answer

Pre-compilers

Question 2

OLAP stands for ______________________________.

Accepted Answer

Online Analytical Processing

Question 3

The Oracle Universal Installer defines the ORACLE_HOME directory in the Unix environment variables,or in ____.

Accepted Answer

A)  Windows Registry entries 
B)  Windows environment variables 
C)  Windows hidden files 
D)  Windows .inf files 
A)  Windows Registry entries 
B)  Windows environment variables 
C)  Windows hidden files 
D)  Windows .inf files A

Question 4

The server-side ____________________ Edition installation option provides basic support for multi-user database applications on a smaller scale than that of the Enterprise Edition.

Accepted Answer

The answer of The server-side ____________________ Edition installation option provides...

Question 5

The ____ engine allows you to store,parse,and execute Java applets,servlets,and stored procedures within the database.

Accepted Answer

A)  JVM 
B)  JDeveloper 
C)  JBoss 
D)  SQLJ 
A)  JVM 
B)  JDeveloper 
C)  JBoss 
D)  SQLJ

Question 6

OLTP stands for ______________________________.

Accepted Answer

Online Tra

Question 7

ORACLE_HOME contains a bin directory that holds most of the executables.

Accepted Answer

A) True 
 B)False

Question 8

The term multi-tier,also referred to as ____,means that the data,processing,and user interfaces are divided into separate areas that are fairly independent of one another.

Accepted Answer

A)  n-tier 
B)  grid computing 
C)  client / server 
D)  peer-to-peer 
A)  n-tier 
B)  grid computing 
C)  client / server 
D)  peer-to-peer

Question 9

On Windows,the default ORACLE_HOME for an Oracle10g,Release 2,database server installation is ____.

Accepted Answer

A)  c :\ oracle\product\10.2.0\db 1 
B)  c :\ oracle\home\10.2.0\db 1 
C)  c :\ oracle10\product\release2.0\db 1 
D)  c :\ oracle10g\home\release2.0\db 1 
A)  c :\ oracle\product\10.2.0\db 1 
B)  c :\ oracle\home\10.2.0\db 1 
C)  c :\ oracle10\product\release2.0\db 1 
D)  c :\ oracle10g\home\release2.0\db 1

Question 10

In a typical Oracle10g application system,the user tier includes a browser.

Accepted Answer

A) True 
 B)False

Question 11

What is the Oracle10g Personal Edition? What is it usually used for?

Accepted Answer

The Personal Edition,which is an Oracle1

Question 12

____ is a valid client installation configuration.

Accepted Answer

A)  Personal 
B)  Runtime 
C)  Standard 
D)  Enterprise 
A)  Personal 
B)  Runtime 
C)  Standard 
D)  Enterprise

Question 13

____________________ is a Web-based form of SQL*Plus.

Accepted Answer

The answer of ____________________ is a Web-based form of SQL*Plus....

Question 14

RAC stands for _________________________.

Accepted Answer

Real Appli

Question 15

A COM component is typically a Microsoft Windows acronym for a self-contained,executable,compiled binary chunk of code.

Accepted Answer

A) True 
 B)False

Question 16

Clustered servers are complex to manage,but supply increased computing power for applications that require speed for processing massive amounts of data,or complex calculations,such as astronomy or physics applications.

Accepted Answer

A) True 
 B)False

Question 17

____ is the typical configuration for an Oracle10g database.

Accepted Answer

A)  Single-instance server 
B)  Multiple-instance server 
C)  Clustered servers 
D)  Application server 
A)  Single-instance server 
B)  Multiple-instance server 
C)  Clustered servers 
D)  Application server

Question 18

The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.

Accepted Answer

A)  Application Server 
B)  Financials 
C)  JDeveloper 
D)  Net Services 
A)  Application Server 
B)  Financials 
C)  JDeveloper 
D)  Net Services

Question 19

The Oracle Universal Installer can be used to install applications that you write by preparing an installation script with the optional Oracle package called the ____________________.

Accepted Answer

The answer of The Oracle Universal Installer can be used...

Question 20

The Runtime client-side installation option installs basic tools and connectivity features such as Oracle ____.

Accepted Answer

A)  Application Server 
B)  Financials 
C)  JDeveloper 
D)  Net Services 
A)  Application Server 
B)  Financials 
C)  JDeveloper 
D)  Net Services

____________________ (such as ProCOBOL and ProC)support embedded SQL commands within programs in C,C++,or COBOL.

OLAP stands for ______________________________.

The Oracle Universal Installer defines the ORACLE_HOME directory in the Unix environment variables,or in ____.

The server-side ____________________ Edition installation option provides basic support for multi-user database applications on a smaller scale than that of the Enterprise Edition.

The ____ engine allows you to store,parse,and execute Java applets,servlets,and stored procedures within the database.

OLTP stands for ______________________________.

ORACLE_HOME contains a bin directory that holds most of the executables.

The term multi-tier,also referred to as ____,means that the data,processing,and user interfaces are divided into separate areas that are fairly independent of one another.

On Windows,the default ORACLE_HOME for an Oracle10g,Release 2,database server installation is ____.

In a typical Oracle10g application system,the user tier includes a browser.

What is the Oracle10g Personal Edition? What is it usually used for?

____ is a valid client installation configuration.

____________________ is a Web-based form of SQL*Plus.

RAC stands for _________________________.

A COM component is typically a Microsoft Windows acronym for a self-contained,executable,compiled binary chunk of code.

Clustered servers are complex to manage,but supply increased computing power for applications that require speed for processing massive amounts of data,or complex calculations,such as astronomy or physics applications.

____ is the typical configuration for an Oracle10g database.

The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.

The Oracle Universal Installer can be used to install applications that you write by preparing an installation script with the optional Oracle package called the ____________________.

The Runtime client-side installation option installs basic tools and connectivity features such as Oracle ____.

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

Exam 1: Oracle Architecture Overview

____________________ (such as Pro*COBOL and Pro*C)support embedded SQL commands within programs in C,C++,or COBOL.

OLAP stands for ______________________________.

The Oracle Universal Installer defines the ORACLE_HOME directory in the Unix environment variables,or in ____.

The server-side ____________________ Edition installation option provides basic support for multi-user database applications on a smaller scale than that of the Enterprise Edition.

The ____ engine allows you to store,parse,and execute Java applets,servlets,and stored procedures within the database.

OLTP stands for ______________________________.

ORACLE_HOME contains a bin directory that holds most of the executables.

The term multi-tier,also referred to as ____,means that the data,processing,and user interfaces are divided into separate areas that are fairly independent of one another.

On Windows,the default ORACLE_HOME for an Oracle10g,Release 2,database server installation is ____.

In a typical Oracle10g application system,the user tier includes a browser.

What is the Oracle10g Personal Edition? What is it usually used for?

____ is a valid client installation configuration.

____________________ is a Web-based form of SQL*Plus.

RAC stands for _________________________.

A COM component is typically a Microsoft Windows acronym for a self-contained,executable,compiled binary chunk of code.

Clustered servers are complex to manage,but supply increased computing power for applications that require speed for processing massive amounts of data,or complex calculations,such as astronomy or physics applications.

____ is the typical configuration for an Oracle10g database.

The Oracle ____ tool provides the network link between the Oracle10g database and most applications that communicate with the database.

The Oracle Universal Installer can be used to install applications that you write by preparing an installation script with the optional Oracle package called the ____________________.

The Runtime client-side installation option installs basic tools and connectivity features such as Oracle ____.

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

____________________ (such as ProCOBOL and ProC)support embedded SQL commands within programs in C,C++,or COBOL.