Oracle 8 - Processes & Security Part 1

Front 1

Using the Oracle export utility, you can export & then import the same database to reduce what?

Back 1

fragmentation and row chaining

Front 2

Before you can run Export and Import, what administrative SQL script must be run once on the database?

Back 2

CATEXP.SQL

Hint 2

The administrative SQL script CATALOG.SQL, which is typically run at database-creation time, automatically runs this.

Front 3

The Oracle export function can be accomplished graphically or programmatically using these 2 utilites.

Back 3

data manager and exp80

Front 4

Type your answer below. Export writes object definitions and table data to an Oracle-format of what kind of file?

Back 4

binary

Front 5

You are exporting a table with indexes. Which part of this data is written to the export file first, table data or index data?

Back 5

table data

Front 6

To perform an export graphically, you must first invoke Data Manager. For Data Manager to work you must have what running?

Back 6

Oracle Agent and Enterprise Manager

Front 7

Operating Export in full mode causes all database objects not in the this schema type to be exported.

Back 7

sys

Front 8

Operating Export in this mode allows you to specify which schema objects to export?

Back 8

table

Front 9

Type your answer below. What do you enter at the NT command prompt to run the Export utility with the username internal and the password oracle?

Back 9

exp80 internal/oracle

Front 10

As with the Export utility, the Import utility features a command line for performing imports. The Import utility's command line is called what under Windows NT. Under other operating systems, it is known simply as?

Back 10

imp80, imp

Front 11

The default Oracle 8 export file name is?

Back 11

expdat.dmp

Front 12

Oracle 8 Import can be used only with data generated from what?

Back 12

export

Front 13

Oracle utility that is used for loading data into an Oracle database. This utility is designed to be flexible and to accept data in a variety of formats.

Back 13

sql*loader

Front 14

SQL*Loader accepts two input file types?

Back 14

input datafile and loader control file

Hint 14

One of the files types is used to specify the format of the datafile(s) as well as column data types, field delimiters, and various other data-specific information.

Front 15

Which of the following indicates that comments are used within a control file?

Back 15

Double hyphens (- -)

Front 16

To load a variable record format datafile, what must you specify for the columns?

Back 16

column delimiter

Front 17

When you use this, data is inserted directly into the datafiles, bypassing much of the logic involved in the conventional path load.

Back 17

direct path loader

Front 18

The advantages of using the direct path loader include the capacity to bypass many of the steps taken by the conventional loader, and the capability to load in parallel. Another advantage is the capability to use the this option?

Back 18

unrecoverable

Front 19

The Oracle RDBMS uses what two types of processes?

Back 19

user and oracle

Front 20

What are Oracle processes also known as (there are two)?

Back 20

Backround, Server

Front 21

What are the nine Oracle processes also known as?

Back 21

Background processes

Front 22

How are Oracle background processes implemented in Windows NT?

Back 22

threads

Front 23

each oracle shadow process uses approx. how much memory?

Back 23

1mb

Front 24

This is used to reduce the number of Oracle user connections.

Back 24

multiplexing

Front 25

A system that has a middle server to handle connection processing is typically called?

Back 25

three-tier system

Front 26

system directly links the user connections into the Oracle instance via the server processes.

Back 26

two-tier

Front 27

What does a three-tier system have that a two-tier system does not?

Back 27

A middleware system

Front 28

process allows many user processes to share a smaller number of server processes

Back 28

multi-threaded server

Front 29

All requests to the shared server processes must go through the?

Back 29

dispatch process

Front 30

To request a dedicated server process when the system is running with the multithreaded server enabled, include the parameter

Back 30

srvr=dedicated

Front 31

If you think the shared-pool size might be too small, you can increase it by tuning this parameter?

Back 31

SHARED_POOL_SIZE

Front 32

The number of dispatchers per protocol is determined by the initialization parameter

Back 32

mts_dispatchers

Hint 32

If you increase this number, each session will potentially see greater performance because it will not have to wait on a dispatcher to become available.

Front 33

lower number of dispatchers are used when there are?

Back 33

less users

Front 34

Sets the number of dispatchers per protocol

Back 34

MTS_DISPATCHERS

Front 35

Sets the initial number of shared server processes

Back 35

MTS_SERVERS

Front 36

Sets the maximum number of dispatcher processes in an instance

Back 36

MTS_MAX_DISPATCHERS

Front 37

Sets the maximum number of shared server processes

Back 37

MTS_MAX_SERVERS