Exam 2: Tools and Architecture

The ____________________ processes support and monitor the server processes and handle database management tasks to keep the database running efficiently and to help maintain fast performance.

(Short Answer)

4.8/5

(40)

Question 21

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

(Short Answer)

4.8/5

(30)

Question 22

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

(Multiple Choice)

4.7/5

(39)

Question 23

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

(True/False)

4.8/5

(40)

Question 24

The ____________________ monitors activities in the database.

(Short Answer)

4.8/5

(45)

Question 25

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

(True/False)

4.9/5

(43)

Question 26

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

(Multiple Choice)

4.8/5

(41)

Question 27

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

(True/False)

4.8/5

(37)

Question 28

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

(True/False)

4.9/5

(43)

Question 29

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

(Multiple Choice)

4.8/5

(39)

Question 30

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

(Multiple Choice)

4.9/5

(42)

Question 31

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

(Multiple Choice)

4.9/5

(33)

Question 32

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

(Short Answer)

4.8/5

(39)

Question 33

____ is the default method for connecting to a database.

(Multiple Choice)

4.8/5

(38)

Question 34

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

(True/False)

4.7/5

(38)

Question 35

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

(Multiple Choice)

4.8/5

(43)

Question 36

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

(True/False)

5.0/5

(32)

Question 37

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

(Multiple Choice)

4.8/5

(25)

Question 38

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

(True/False)

4.7/5

(48)

Question 39

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

(Multiple Choice)

4.8/5

(26)

Question 40

Showing 21 - 40 of 100

The ____________________ processes support and monitor the server processes and handle database management tasks to keep the database running efficiently and to help maintain fast performance.

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

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

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

The ____________________ monitors activities in the database.

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

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

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

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

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

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

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

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

____ is the default method for connecting to a database.

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

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

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

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

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

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

Oracle Architecture Overview

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters