Deck 2: Tools and Architecture

Question 1

The Security Manager views and modifies users,roles,and profiles;creates new users;changes passwords.

Answer 1

True

Question 2

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.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

If there are multiple files in a log group,LGWR writes to all the files at the same time,in parallel.

Question 7

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

Question 8

The Database Configuration Assistant creates new database instances.

Question 9

The listener listens for requests made by user connections.

Question 10

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.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

The process monitor process writes buffers to datafiles.

Question 16

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

Question 17

Oracle Net Services resides only on the server side of the network.

Question 18

The queue monitor process is optional and is utilized when running Oracle Streams Advanced Queuing.

Question 19

iSQL*Plus output looks like an HTML table.

Question 20

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

Question 21

The PGA is allocated when an instance is started and is deallocated when the instance is shut down.

Question 22

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

Question 23

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

A) Log Miner
B) Schema Manager
C) Universal Installer
D) Instance Manager

Question 24

To start Net Manager in Unix or Linux,type ____ on the command line of a shell.

A) sqlplus
B) sql+
C) sqlmgr
D) netmgr

Question 25

The ____ collects statistics about tables or objects,validates tables,finds continuing rows.

A) Backup and Restore Wizard
B) Analyze Wizard
C) Net Manager
D) Universal Installer

Question 26

The Oracle Net Services configuration is stored in the ____ configuration file on the client computer.

A) listener.ora
B) client.ora
C) tnsnames.ora
D) netservices.ora

Question 27

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

Question 28

The ____ migrates data from older versions to newer versions of the database.

A) Export and Import Wizard
B) Database Configuration Assistant
C) Analyze Wizard
D) Data Upgrade Assistant

Question 29

____ is the Grid Computing (clustered)version of the Database Control.

A) Grid Control
B) Storage Manager
C) XML Database Manager
D) Warehouse Summary Management

Question 30

Computers on a network use ____ connections to communicate with each other.

A) database
B) listener
C) database
D) network

Question 31

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

Question 32

____ is the default method for connecting to a database.

A) TNS
B) LDAP
C) Host naming
D) Easy connect

Question 33

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

Question 34

The Schema Manager performs storage-related tasks in the Oracle10g database.

Question 35

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

Question 36

The Instance Manager allows starting and stopping of the database when running the console from a client machine.

Question 37

In versions of Oracle prior to Oracle 10g,executing the Enterprise Manager console (or simply console)was complicated.

Question 38

The database has a service called the ____ process.This process waits for requests and responds to requests as needed.

A) listener
B) netservice
C) netserver
D) netnames

Question 39

Each schema is owned by one Oracle user and is identified by the user's name.

Question 40

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

A) bequeath protocol
B) network name
C) JDBC
D) database name

Question 41

The ____ is the part of an Oracle database executing in memory,when a database is started.

A) lsnctrl
B) netmgr
C) LDAP
D) Oracle instance

Question 42

The ____ is only present when a database is in ARCHIVELOG mode.

A) ARCn
B) CKPT
C) DBWn
D) Dnnn

Question 43

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

A) / etc / network / admin
B) / user / network / admin
C) ORACLE_HOME / network / admin
D) / sbin / network / admin

Question 44

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

A) Schema Manager
B) Net Configuration Assistant
C) Security Manager
D) Storage Manager

Question 45

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

A) $ORACLE_HOME / network / admin
B) / home / network / admin
C) / sbin / network / admin
D) / etc / network / admin

Question 46

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

A) SQL *Plus Worksheet
B) iSQL*Plus
C) Net Services Console
D) Instance Manager

Question 47

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

A) netmgr
B) ps
C) lsnrctl
D) vi

Question 48

To discover the name on a Unix or Linux machine use the ____ command in a shell.

A) ls
B) ENV
C) netmgr
D) ps

Question 49

The ____ listens for requests and passes them on to the appropriate database server process for execution in the database.

A) tnsnames
B) listener
C) schema manager
D) storage manager

Question 50

Setting a user connection as being dedicated or shared can be controlled in the client-side configuration of Oracle Net Services,in the ____ file.

A) tnsnames.ora
B) listener.ora
C) server.ora
D) mode.ora

Question 51

An easy way to validate configuration is to use an Oracle version of the TCP / IP ping utility,called ____.

A) tnsping
B) netmgr
C) netping
D) tcpping

Question 52

The ____ process cleans up after user sessions are finished.

A) SMON
B) PMON
C) DBWn
D) CKPT

Question 53

A ____ server uses CPU and memory more efficiently by swapping out user sessions during idle time.

A) dedicated
B) foreground
C) shared
D) background

Question 54

The ____ variable is the directory upward from the ORACLE_HOME variable.

A) ORACLE_DIR
B) ORACLE_ROOT
C) ORACLE_BEGIN
D) ORACLE_BASE

Question 55

The ____ process handles recovery if it is needed.

A) ARCn
B) SMON
C) RECO
D) LGWR

Question 56

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

A) listener.ora
B) processes.ora
C) balance.ora
D) tnsnames.ora

Question 57

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

A) LDAP
B) PGA
C) SGA
D) TNS

Question 58

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

A) dedicated
B) shared
C) background
D) foreground

Question 59

The ____ does not write any data to disks.It signals the DBWn to begin writing to disk,by issuing a checkpoint.

A) PMON
B) SMON
C) RECO
D) CKPT

Question 60

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

A) listener.ora
B) servers.ora
C) tnsnames.ora
D) clients.ora

Question 61

The ____ area stores parsed SQL in memory.

A) redo log buffer
B) Java pool
C) shared pool
D) large pool

Question 62

The ____________________ variable refers to the directory where Oracle installs its executable files.

Question 63

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

Question 64

A ____ is a set of database structures,such as tables,indexes,user-defined attributes,and procedures.

A) session
B) view
C) console
D) schema

Question 65

____ and its console can be used as a centralized control center for many of the available DBA tools.

A) Enterprise Manager
B) Buffer Cache
C) Process Monitor
D) Job Queue Process

Question 66

Whenever a change is made to data,the ____ stores a copy of the changed data and the original data,in case it is needed.

A) redo log buffer
B) Java pool
C) shared pool
D) streams pool

Question 67

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

A) Sessions
B) SGA Memory
C) Kill Session
D) Dynamic

Question 68

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.

Question 69

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

A) 2K
B) 8K
C) 16K
D) 32K

Question 70

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

A) Queue monitor
B) Recoverer
C) Checkpoint
D) Dispatcher

Question 71

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

Question 72

The ____ improves response time for background processes and for backup and recovery processes.

A) streams pool
B) large pool
C) redo log buffer
D) shared pool

Question 73

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

Question 74

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.

Question 75

Service names and their mappings are stored in a(n)_____________________________________________ server.

Question 76

The ____ processor runs scheduled jobs,submitted in background,using the DBMS_JOBS package,as scheduled batch job operations.

A) system monitor
B) dispatcher
C) job queue
D) recoverer

Question 77

The ______________________________ monitors databases and provides access to database management tools.

Question 78

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

A) Queue Monitor Area (QMA)
B) Job Queue Area (JQA)
C) Dispatcher Global Area (DGA)
D) Program Global Area (PGA)

Question 79

A(n)____________________ protocol allows a direct connection to a database,on a database server computer,without going through Oracle Net services and without requiring a network name.

Question 80

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