Exam 10: Data Administration, Database Administration, and Data Dictionaries

Among the responsibilities of database administration is the physical design of shared databases.

The data administration function is operationally oriented and is responsible for the day-to-day monitoring and management of the company's various active databases, as well as providing liaison support to program designers during application development.

An example of an active data dictionary's use in the "input sense" is if it must be consulted to see who is authorized to access particular data.

Data administration is not concerned with data security because that is the responsibility of the company's firewalls.

A relational DBMS catalog is a limited-scope, passive data dictionary.

Installing new versions of the DBMS and installing "fixes" or "patches" (corrections) to the DBMS would be most directly characterized as ____.

Handling a DBMS application failure during execution would be most directly characterized as ____.

All of the following are responsibilities of data administration, except ____.

All of the following are advantages of data and database administration, except ____.

The data administration group is responsible for the operational aspects of the data dictionary, as opposed to the planning aspects, which are the responsibility of database administration.

The pair of dictionary entities that are in the "impact of change" relationship are ____.

The most appropriate tool for accurately supporting the relational query optimizer is the ____.

In a relational DBMS, the main purpose of the relational catalog is to accurately support the relational query optimizer.

Among the responsibilities of data administration are arbitration of disputes and usage authorization.

The term that describes data about data is ____.

Having dedicated experts whose job it is to perform database design would be most directly characterized as ____.

One of the advantages of data and database administration is having dedicated personnel to manage externally acquired databases.

The term "impact of change" refers to a data dictionary relationship between the table and attribute entities.

Maintaining a reasonable amount of control over centralized/decentralized data would be most directly characterized as ____.

The nature of the interaction of an active data dictionary with the IS environment can be a matter of input into the data dictionary, output from it, or both.