FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Database Administration and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

In the Oracle Enterprise Manager, a ____ is basically any object created by end users; for example, tables, views, indexes, stored procedures, and triggers.

A) component
B) database object
C) policy
D) role

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

The DBA function provides data modeling and design services to the end-user community, often through coordination with an application development group within the data-processing department.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Protecting the data in the database is a function of authorization management.

As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.

Explain user requirements gathering as part of the DBA's end-user support services.

Explain conflict and problem resolution as part of the DBA's end-user support services.

The testing and evaluation of a database application cover all aspects of the system-from the simple collection and creation of data to its use and retirement. What is covered by the evaluation process?

Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.

Testing procedures and standards must already be in place before any application program can be approved for use in the company.

The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

The selection of the DBMS ____________________ involves asking the question, "Are the company's needs better served by a relational, object-oriented, or object/relational DBMS?"

In the IBM DB2 system catalog tables, ____________________ stores one row for each column of each table or view.

Performance monitoring and ____________________ require much of the DBA's attention and time. These activities are designed to ensure that the DBMS, utilities, and applications maintain satisfactory performance levels.

Describe the need for convenient and safe backup storage.

____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy, must have a thorough understanding of the components being installed, and must be familiar with the installation, configuration, and startup procedures of such components.

Database access can be controlled by placing limits on the use of the DBMS's query and reporting tools.

One of the important functions provided by the database ____ is to reserve the resources that must be used by the database at run time.

____ allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.

The DBA is responsible for ensuring that the data are distributed to the right persons, at the right time, and in the right format.