Exam 8: Database Administration

The DBA uses views and the SQL ____________________ statement as two security mechanisms.

What can the DBA do if the organization has no additional money for its production system but needs further performance improvements?

____________________ is the prevention of unauthorized access,either intentional or accidental,to a database.

The ____________________ strictly controls the production system.

To protect against electrical power interruptions and outages,organizations use a(n) ____________________,which is a power source such as battery or fuel cell.

Another term for production system is the sandbox.

The DBA is responsible for DBMS maintenance,data dictionary management,and training.

By default,Access and other DBMSs create indexes automatically for the ____ keys.

Damage to a database can occur through a physical incident such as a computer malfunction.

The ____ establishes the naming conventions for tables,fields,and indexes in the data dictionary.

Any changes made in the database structure are communicated only to the affected users.

Programmers monitor database usage to detect potential security violations.

If users access only certain fields in a table,you can improve performance by ____________________ the tables into two or more tables that each have the same primary key as the original and that collectively contain all the fields from the original table.

The DBA determines and documents the database access privileges for all users.

____________________ is the rule that the primary key cannot be null.

____ integrity is the constraint that says that the values in foreign keys must match values already in the database.

If a DBMS lacks essential security features,the DBA might create or purchase special security programs that provide the missing features.

Changing the database design to improve the performance is called ____ the design.

The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so.

Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content,such as information about programs and the various data items these programs access?