Exam 2: Tools and Architecture

The ____________________ views table structures,creates new tables,indexes,views,and any other type of object stored in the database.

A(n)____________________ is the set of information (configuration)that Oracle Net Services uses to locate and communicate with an Oracle database.

______________________________ gives you a way to write queries and other SQL commands via the Internet,or across a network,returning results in a Web browser.

The process monitor process writes buffers to datafiles.

The ____ is used to install Oracle software,or change an existing installation.

The SID has been replaced by the service name in Oracle8i and higher.

The ____________________ queries redo log files and otherwise.Also called Data Miner.

A shared server is the best configuration for a database system with large amounts of memory and CPU power because user sessions never have to wait for a server process to be available.

iSQL*Plus output looks like an HTML table.

In Oracle10g the buffer cache can consist of multiple buffer caches,of different sizes.The default size is ____.

The two main sections of memory for the Oracle instance are the System Global Area (SGA)and the ____.

The Schema Manager provides a way to manipulate anything in the database that is in a schema.

The ____ contains many of the memory buffer components for an up and running (online)Oracle instance.

The ____ area stores parsed SQL in memory.

The link from the user session,through the server session,and to the database instance is called a(n)____________________.

The _________________________ network name is used to call external programs (external to Oracle software),such as DLL's.

The ____________________ utility attempts to contact the database server through Oracle Net Services,using both the client TNS configuration,and the database server listener process configuration.

____ is a Web-based version of SQL*Plus.

____________________ service database connections (between database server and users)both with dedicated server configuration and with shared server configuration (using dispatchers).

The Enterprise Manager console is only available in the Oracle client installation,for Oracle10g.