Exam 8: Database Administration

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

An internal company network that uses software tools typically used on the Internet and World Wide Web is called an extranet.​

The ____ is responsible for providing training in the use of the DBMS.​

In most cases,access to every table and field in a database is a necessity for every user.​

The _________________________ strictly controls the production system.​

What is the DBA's role with regard to access privileges?​

Damage to a database can occur through a physical incident such as an abnormally terminated program.​

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

SQL is an example of a nonprocedural language.​

A shared lock permits other users to read the data in the database.​

The hardware,software,and database for the users is called the ____________________ system.​

To implement and enforce security,the DBA uses such features as encryption and views.​

When the primary key cannot be null,this is known as ____________________.​

Tables with indexes allow faster searches,but slow performance on ____.​

In order to develop new programs,the programmers need access to the information in the DBMS.They are given access to the ____.​

A configuration of several computers connected together that allow users to share a variety of hardware and software resources is known as a(n)_________________________.​

​____ locks forbid any other user from accessing the data in any way.

QBE is an example of a procedural language.​

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

With just two exceptions,the DBA grants access and update privileges to the production system only to authorized users.What are the exceptions?​