Deck 1: Oracle Architecture Overview

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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.

Answer 3

True

Question 4

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

Question 5

Only one database can be managed within OEM.

Question 6

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).

Question 7

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

Question 8

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

Question 9

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

Question 10

A tablespace may use only one datafile.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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.

Question 22

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

A) GIS
B) ESRI
C) Sybase
D) Symantec

Question 23

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.

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

Question 24

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

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

Question 25

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.

A) single-instance server
B) multiple-instance server
C) shared server
D) dedicated server

Question 26

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

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

Question 27

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

A) Online Analytical Processing
B) Label Security
C) Advanced Security
D) Database Extensions for .NET

Question 28

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

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

Question 29

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

A) PL / SQL
B) SQL*Plus
C) Forms
D) SQLJ

Question 30

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

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

Question 31

____ is a valid client installation configuration.

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

Question 32

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.

Question 33

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.

Question 34

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

A) sql.exe
B) sqlplus.exe
C) sqlp.exe
D) plus.exe

Question 35

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

A) ODBC
B) SQL
C) PgSQL
D) PL / SQL

Question 36

____ is a valid client installation configuration.

A) Personal
B) Administrator
C) Standard
D) Universal

Question 37

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

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

Question 38

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

Question 39

The OFA naming standards are only recommendations,not requirements.

Question 40

____ is the typical configuration for an Oracle10g database.

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

Question 41

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

Question 42

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

A) BASE
B) ORACLE_BASE
C) HOME
D) ORACLE_HOME

Question 43

RAC stands for _________________________.

Question 44

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

A) BASE
B) ORACLE_BASE
C) HOME
D) ORACLE_HOME

Question 45

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

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 46

RDBMS stands for ________________________________________.

Question 47

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.

Question 48

OEM stands for _________________________.

Question 49

The is usually stored as the ____ environment variable.

A) ORACLE_DB
B) ORACLE_NAME
C) ORACLE_DNAME
D) ORACLE_SID

Question 50

Current database files are stored in ____ / .

A) DB
B) Datafiles
C) Oradata
D) Data

Question 51

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 -silent

A) installer.exe
B) install.exe
C) setup.exe
D) runInstaller.exe

Question 52

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

A) redo log
B) datafile
C) control
D) tablespace

Question 53

In Windows,the default ORACLE_BASE directory is ____.

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

Question 54

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

Question 55

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

A) redo log
B) datafile
C) control
D) tablespace

Question 56

JVM stands for ____________________.

Question 57

OLTP stands for ______________________________.

Question 58

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

Question 59

A ____ file records changes to database data.

A) redo log
B) datafile
C) control
D) tablespace

Question 60

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

Question 61

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

Question 62

OLAP stands for ______________________________.

Question 63

What does the Oracle10g RDBMS software suite include?

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

Describe the OEM wizards feature of the Oracle10g suite.

Question 71

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

Question 72

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

Question 73

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 ____________________.

Question 74

Describe the Java / Web features of the Oracle10g suite.

Question 75

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

Question 76

____________________ redo logs record changes immediately.

Question 77

JDM stands for ____________________.

Question 78

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.

Question 79

Each datafile belongs to one ____________________ in a database.