Exam 12: Database Administration and Security

The end user's role requires a broad understanding of DBMS functions, configuration, programming languages, data modeling and design methodologies, and so on.

An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations.

A(n) ____________________ physically stores the database's data.

Most of today's successful organizations depend on the ____________________ database to provide support for all of their operations-from design to implementation, from sales to services, and from daily decision making to strategic planning.

The person responsible for the control of the centralized and shared database is the database ____.

The security, privacy, and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations.

A(n) ____ data dictionary is not updated automatically and usually requires a batch process to be run.

Classifying users into ____ according to common access needs facilitates the DBA's job of controlling and managing the access privileges of individual users.

____ CASE tools provide support for the coding and implementation phases.

In today's Internet environment, the DBA must also work with ____________________ and network administrators to implement efficient and secure Web-to-database connectivity.

The end user must provide testing and evaluation services for all the database and DBA applications.

A DBMS facilitates ____.

A ____ is a named collection of settings that control how much of the database resource a given user can use.

Several DBMS packages contain features that allow the creation of a(n) ____, which automatically records a brief description of the database operations performed by all users.

____ CASE tools provide support for the planning, analysis, and design phases.

A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

A(n) ____ serves as the basis for planning, development, and control of future information systems

The DBA works with managers to ensure the quality and integrity of database design and transactions.

The DBA must review the database application design to ensure that transactions are ____________________, meaning that they do not overload the DBMS.

A ____ is a uniquely identifiable object that allows a given person to log on to the database.