Exam 2: Tools and Architecture

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.

(Short Answer)

4.8/5

(39)

Question 61

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

(True/False)

4.8/5

(32)

Question 62

The ____________________ monitors storage use (tablespaces and datafiles)and adds more space as needed or adjusts settings on existing storage units.

(Short Answer)

4.9/5

(38)

Question 63

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

(Multiple Choice)

5.0/5

(39)

Question 64

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

(Multiple Choice)

4.8/5

(32)

Question 65

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

(Multiple Choice)

4.8/5

(40)

Question 66

How can you execute SQL Plus and SQL Plus Worksheet?

(Essay)

4.9/5

(33)

Question 67

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

(Multiple Choice)

4.8/5

(30)

Question 68

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

(Multiple Choice)

5.0/5

(45)

Question 69

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

(True/False)

4.8/5

(43)

Question 70

The ____ process handles recovery if it is needed.

(Multiple Choice)

4.9/5

(36)

Question 71

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

(Multiple Choice)

4.8/5

(39)

Question 72

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

(Multiple Choice)

5.0/5

(38)

Question 73

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

(Multiple Choice)

4.9/5

(34)

Question 74

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

(Multiple Choice)

4.8/5

(45)

Question 75

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

(Multiple Choice)

4.8/5

(39)

Question 76

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

(Multiple Choice)

4.8/5

(32)

Question 77

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

(Short Answer)

4.7/5

(37)

Question 78

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

(Multiple Choice)

4.8/5

(33)

Question 79

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

(Multiple Choice)

4.8/5

(45)

Question 80

Showing 61 - 80 of 100

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.

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

The ____________________ monitors storage use (tablespaces and datafiles)and adds more space as needed or adjusts settings on existing storage units.

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

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

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

How can you execute SQL Plus and SQL Plus Worksheet?

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

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

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

The ____ process handles recovery if it is needed.

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

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

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

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

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

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

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

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

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

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

Exam 2: Tools and Architecture

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.

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

The ____________________ monitors storage use (tablespaces and datafiles)and adds more space as needed or adjusts settings on existing storage units.

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

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

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

How can you execute SQL *Plus and SQL *Plus Worksheet?

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

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

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

The ____ process handles recovery if it is needed.

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

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

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

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

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

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

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

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

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

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

How can you execute SQL Plus and SQL Plus Worksheet?