Exam 12: Database Administration and Security

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

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

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

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

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

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

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

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.

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?

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

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?"

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

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

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

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

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.

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

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

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.