Chapter 1: Oracle Architecture Overview
TRUE/FALSE
1. The Oracle Universal Installer keeps log records on your computer of previous installation activity.
ANS: T PTS: 1 REF: 15
2. Oracle has standardized its software so that it looks and acts identically at the user interface level on
all platforms.
ANS: T PTS: 1 REF: 2
3. Oracle customized its software release on each platform at the lowest levels to optimize performance
based on each platform’s characteristics.
ANS: T PTS: 1 REF: 2
4. If you are upgrading from an earlier version to Oracle10g, you need to install the Oracle10g database
with the pre-configured settings.
ANS: F PTS: 1 REF: 3
5. Only one database can be managed within OEM.
ANS: F PTS: 1 REF: 4
6. SQL*Plus accepts standard SQL, with all the Oracle enhancements to SQL, such as the TO_DATE
function.
ANS: T PTS: 1 REF: 4-5
7. The combination of database software, a database (the files), and a database instance (the SGA and the
background processes) is called a database agent.
ANS: F PTS: 1 REF: 6
8. 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.
ANS: T PTS: 1 REF: 7
9. A COM component is typically a Microsoft Windows acronym for a self-contained, executable,
compiled binary chunk of code.
ANS: T PTS: 1 REF: 9
10. In a typical Oracle10g application system, the middle tier contains the Oracle10g database server.
ANS: F PTS: 1 REF: 11
,11. In a typical Oracle10g application system, the data tier contains the application server.
ANS: F PTS: 1 REF: 11
12. In a typical Oracle10g application system, the user tier includes a browser.
ANS: T PTS: 1 REF: 11
13. The client configuration is a combination of the user interface tier and the application server tier.
ANS: T PTS: 1 REF: 12
14. The Oracle 10g Standard Edition for servers can be upgraded with database features, such as
partitioning and clustering.
ANS: F PTS: 1 REF: 13
15. A single machine cannot contain more than one value for ORACLE_HOME.
ANS: F PTS: 1 REF: 16
16. ORACLE_HOME contains a bin directory that holds most of the executables.
ANS: T PTS: 1 REF: 20
17. The OFA standards call for naming files according to their type and sequence of creation.
ANS: T PTS: 1 REF: 20
18. 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).
ANS: F PTS: 1 REF: 20
19. The primary purpose of the OFA naming standards is to speed up the process of identifying files.
ANS: T PTS: 1 REF: 21
20. A tablespace may use only one datafile.
ANS: F PTS: 1 REF: 21
21. The OFA naming standards are only recommendations, not requirements.
ANS: T PTS: 1 REF: 20
22. 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.
ANS: T PTS: 1 REF: 18
23. 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.
, ANS: T PTS: 1 REF: 16
24. If you install upgrades or enhancements, the Oracle Universal Installer re-installs any previously
existing subcomponents.
ANS: F PTS: 1 REF: 15
25. 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.
ANS: F PTS: 1 REF: 13
MULTIPLE CHOICE
1. The SQL*Plus executable file in a Windows installation is ____.
a. sql.exe c. sqlp.exe
b. sqlplus.exe d. plus.exe
ANS: B PTS: 1 REF: 17
2. The Oracle Universal Installer defines the ORACLE_HOME directory in the Unix environment
variables, or in ____.
a. Windows Registry entries c. Windows hidden files
b. Windows environment variables d. Windows .inf files
ANS: A PTS: 1 REF: 16
3. The Runtime client-side installation option installs basic tools and connectivity features such as Oracle
____.
a. Application Server c. JDeveloper
b. Financials d. Net Services
ANS: D PTS: 1 REF: 14
4. 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 c. Sybase
b. ESRI d. Symantec
ANS: B PTS: 1 REF: 2
5. The ____ engine included with the Oracle software provides a specialized programming language you
can use for creating triggers, packages, and procedures.
a. ODBC c. PgSQL
b. SQL d. PL/SQL
ANS: D PTS: 1 REF: 3
6. The ____ engine allows you to store, parse, and execute Java applets, servlets, and stored procedures
within the database.
a. JVM c. JBoss
b. JDeveloper d. SQLJ
ANS: A PTS: 1 REF: 3
, 7. The Oracle ____ tool provides the network link between the Oracle10g database and most applications
that communicate with the database.
a. Application Server c. JDeveloper
b. Financials d. Net Services
ANS: D PTS: 1 REF: 3
8. If you are running Enterprise Manager, SQL*Plus, Forms, or non-Oracle products, Oracle ____ is the
gateway into the database.
a. Application Server c. JDeveloper
b. Financials d. Net Services
ANS: D PTS: 1 REF: 3
9. The ____ tool allows you to create and run queries, add rows, modify data, and write reports using
SQL.
a. PL/SQL c. Forms
b. SQL*Plus d. SQLJ
ANS: B PTS: 1 REF: 4
10. ____ is the typical configuration for an Oracle10g database.
a. Single-instance server c. Clustered servers
b. Multiple-instance server d. Application server
ANS: A PTS: 1 REF: 8
11. 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 c. shared server
b. multiple-instance server d. dedicated server
ANS: D PTS: 1 REF: 8
12. The Oracle ____ package encrypts outgoing data before it goes onto the network or across the Internet.
a. Online Analytical Processing c. Advanced Security
b. Label Security d. Database Extensions for .NET
ANS: C PTS: 1 REF: 9 | 10
13. 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 c. client/server
b. grid computing d. peer-to-peer
ANS: A PTS: 1 REF: 11
14. ____ is a valid client installation configuration.
a. Personal c. Standard
b. Runtime d. Enterprise
ANS: B PTS: 1 REF: 12
15. ____ is a valid client installation configuration.
a. Personal c. Standard
TRUE/FALSE
1. The Oracle Universal Installer keeps log records on your computer of previous installation activity.
ANS: T PTS: 1 REF: 15
2. Oracle has standardized its software so that it looks and acts identically at the user interface level on
all platforms.
ANS: T PTS: 1 REF: 2
3. Oracle customized its software release on each platform at the lowest levels to optimize performance
based on each platform’s characteristics.
ANS: T PTS: 1 REF: 2
4. If you are upgrading from an earlier version to Oracle10g, you need to install the Oracle10g database
with the pre-configured settings.
ANS: F PTS: 1 REF: 3
5. Only one database can be managed within OEM.
ANS: F PTS: 1 REF: 4
6. SQL*Plus accepts standard SQL, with all the Oracle enhancements to SQL, such as the TO_DATE
function.
ANS: T PTS: 1 REF: 4-5
7. The combination of database software, a database (the files), and a database instance (the SGA and the
background processes) is called a database agent.
ANS: F PTS: 1 REF: 6
8. 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.
ANS: T PTS: 1 REF: 7
9. A COM component is typically a Microsoft Windows acronym for a self-contained, executable,
compiled binary chunk of code.
ANS: T PTS: 1 REF: 9
10. In a typical Oracle10g application system, the middle tier contains the Oracle10g database server.
ANS: F PTS: 1 REF: 11
,11. In a typical Oracle10g application system, the data tier contains the application server.
ANS: F PTS: 1 REF: 11
12. In a typical Oracle10g application system, the user tier includes a browser.
ANS: T PTS: 1 REF: 11
13. The client configuration is a combination of the user interface tier and the application server tier.
ANS: T PTS: 1 REF: 12
14. The Oracle 10g Standard Edition for servers can be upgraded with database features, such as
partitioning and clustering.
ANS: F PTS: 1 REF: 13
15. A single machine cannot contain more than one value for ORACLE_HOME.
ANS: F PTS: 1 REF: 16
16. ORACLE_HOME contains a bin directory that holds most of the executables.
ANS: T PTS: 1 REF: 20
17. The OFA standards call for naming files according to their type and sequence of creation.
ANS: T PTS: 1 REF: 20
18. 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).
ANS: F PTS: 1 REF: 20
19. The primary purpose of the OFA naming standards is to speed up the process of identifying files.
ANS: T PTS: 1 REF: 21
20. A tablespace may use only one datafile.
ANS: F PTS: 1 REF: 21
21. The OFA naming standards are only recommendations, not requirements.
ANS: T PTS: 1 REF: 20
22. 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.
ANS: T PTS: 1 REF: 18
23. 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.
, ANS: T PTS: 1 REF: 16
24. If you install upgrades or enhancements, the Oracle Universal Installer re-installs any previously
existing subcomponents.
ANS: F PTS: 1 REF: 15
25. 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.
ANS: F PTS: 1 REF: 13
MULTIPLE CHOICE
1. The SQL*Plus executable file in a Windows installation is ____.
a. sql.exe c. sqlp.exe
b. sqlplus.exe d. plus.exe
ANS: B PTS: 1 REF: 17
2. The Oracle Universal Installer defines the ORACLE_HOME directory in the Unix environment
variables, or in ____.
a. Windows Registry entries c. Windows hidden files
b. Windows environment variables d. Windows .inf files
ANS: A PTS: 1 REF: 16
3. The Runtime client-side installation option installs basic tools and connectivity features such as Oracle
____.
a. Application Server c. JDeveloper
b. Financials d. Net Services
ANS: D PTS: 1 REF: 14
4. 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 c. Sybase
b. ESRI d. Symantec
ANS: B PTS: 1 REF: 2
5. The ____ engine included with the Oracle software provides a specialized programming language you
can use for creating triggers, packages, and procedures.
a. ODBC c. PgSQL
b. SQL d. PL/SQL
ANS: D PTS: 1 REF: 3
6. The ____ engine allows you to store, parse, and execute Java applets, servlets, and stored procedures
within the database.
a. JVM c. JBoss
b. JDeveloper d. SQLJ
ANS: A PTS: 1 REF: 3
, 7. The Oracle ____ tool provides the network link between the Oracle10g database and most applications
that communicate with the database.
a. Application Server c. JDeveloper
b. Financials d. Net Services
ANS: D PTS: 1 REF: 3
8. If you are running Enterprise Manager, SQL*Plus, Forms, or non-Oracle products, Oracle ____ is the
gateway into the database.
a. Application Server c. JDeveloper
b. Financials d. Net Services
ANS: D PTS: 1 REF: 3
9. The ____ tool allows you to create and run queries, add rows, modify data, and write reports using
SQL.
a. PL/SQL c. Forms
b. SQL*Plus d. SQLJ
ANS: B PTS: 1 REF: 4
10. ____ is the typical configuration for an Oracle10g database.
a. Single-instance server c. Clustered servers
b. Multiple-instance server d. Application server
ANS: A PTS: 1 REF: 8
11. 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 c. shared server
b. multiple-instance server d. dedicated server
ANS: D PTS: 1 REF: 8
12. The Oracle ____ package encrypts outgoing data before it goes onto the network or across the Internet.
a. Online Analytical Processing c. Advanced Security
b. Label Security d. Database Extensions for .NET
ANS: C PTS: 1 REF: 9 | 10
13. 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 c. client/server
b. grid computing d. peer-to-peer
ANS: A PTS: 1 REF: 11
14. ____ is a valid client installation configuration.
a. Personal c. Standard
b. Runtime d. Enterprise
ANS: B PTS: 1 REF: 12
15. ____ is a valid client installation configuration.
a. Personal c. Standard
