Exam 2: Tools and Architecture

A(n)____________________ is like a direct pipeline between different databases,often used to manage replication (duplication)of data across multiple databases.

Load balancing between multiple listener processes is placed in the ____ configuration file on the client computer.

What are the three paths of communication used when you access the database while logged on to the server?

The ____________________ creates new users,allocates storage resources to users,and changes passwords.

A(n)____________________ system has multiple instances that are used as if they were one instance.

A ____ is a label given to a specific network configuration,usually a specific computer,at a specific TCP / IP address.

Oracle ____________________ is made up of several subcomponents that work together to translate your requests,such as SQL queries,into network packages for the local,or Internet,network.

The listener.ora file is stored in the ____ directory.

The ____ file is placed onto the client machine,allowing communication between the client machine and the listener on the database sever.

The Net Configuration Assistant views and modifies data;views and modifies table structures,indexes,views,objects,procedures,and packages.

Why is it important for you to be familiar with both automated (using a tool)and manual (using a command)methods for performing tasks in Oracle?

The ____________________ is used for java code buffering specific to user sessions.

Listener logging and tracing can be a drain on resources and is defaulted as on.

The ____________________ configuration file is used to translate a connection string typed by the user into the network and database,addressing information needed to locate the database on the network.

How can you configure a shared server and a dedicated server using the tnsnames.ora file?

What are the different naming methods supported by Oracle?

The ____ allows definition of all possible individual sections of configuration for Oracle Net Services.

You can start and stop the listener using the listener control utility (____).

A session lasts from the time you make a connection until you end the connection.

The Database Configuration Assistant creates new database instances.