Exam 2: Tools and Architecture

The listener listens for requests made by user connections.

The Security Manager's primary tasks involve setting up and maintaining users in Oracle10g.

The ____________________ process writes redo log buffers to the redo log files.

When you are using tools that reside on the same computer as the database,you might assume that no Oracle Net Services connection is needed.

The Schema Manager provides access to configuration,sessions and resource consumer group configuration.It also includes summary advisory performance metrics.

In the case of a ____ server,every user session (connection)has its own server process.

The SGA is effectively used in session connection memory and is broken into private chunks for each server process.

You can stop the database using SQL*Plus or iSQL*Plus.

The ____ process cleans up after user sessions are finished.

The ____________________ file is stored on the database server,providing configuration for how the listener process listens over the network,for connection requests.

A(n)____________________ is a way in which a node name on a network will be translated into a form understandable and routable by hardware and network software on that network.

The recoverer process is only present in a distributed database system.

____ processes are only present in shared server mode to distribute user connection requests,between server processes.

The Administration screen of the Database Control provides comprehensive maintenance access to database utilities,backup / recovery,and deployment activities.

A checkpoint is assigned a(n)______________________________ that is written into each redo log entry,the control files,and each data block that is written back to the datafiles.

You can use Net Manager to start and stop the listener.

The tnsnames.ora file is found in the ____ directory on Unix or Linux.

A dedicated server is the best configuration for an OLTP database system with a large number of users.

The ____ button allows you to end a user session from the console.

The port setting 1521 is the default port setting for most Oracle database listeners.