Exam 14: Data and Database Administration

A disadvantage of signature dependency maintenance is that it may lead to excessive recompilation of dependent objects by the DBMS.

One of the responsibilities of the data administrator is to establish standards for data naming conventions for the databases in the enterprise.

A typical way to retrieve information from the data dictionary of a relational database is to use:

DBMSs used in highly sensitive areas such as national defense and intelligence gathering must be able to support mandatory access controls.

The first step in the DBMS selection and evaluation process is a detailed analysis of the requirements,which usually include data definition support,procedural and nonprocedural access,and recovery management.

Often the level of data quality that is sufficient for business operations meets or exceeds the level necessary for upper management decision making.

____________________ is a database security approach in which users are assigned access privileges to specific parts of a database.

In distributed database environments,the word "distributed" refers to the following:

Object databases arose from the need to integrate traditional types of data with non-traditional types of data in the same database.

The stages of information transformation that each entity in an organization goes through are collectively known as its ________________________.

___________________ is a database security approach in which a user can access a database element if their clearance level provides access to the classification level of that element.

The poor choice of a DBMS will usually not cause:

Which of the following is not an example of transaction processing?

Which of the following information is usually not provided by a data dictionary?

The persons playing the most important role in the overall information systems planning process are:

Development of an enterprise data model is one of the most important responsibilities of the data administrator.

For complex integrity constraints beyond the capability of CHECK constraints,SQL:2003 provides for ___________________,which can be used for constraints involving multiple tables and statistical calculations.

Two forms of authorization controls are _________ and ____________?

The information systems planning process does not involve the development of:

SQL:2003 provides a limited ability to define new data types using the CREATE DOMAIN statement.A domain can be created as a subset of a standard data type.