Database Management Test 4

Front 1

Data about the data in a database is known as ___.

Back 1

metadata

Front 2

___ contain information about table relationships, view, indexes, users, privileges, and replicated data.

Back 2

Catalogs

Front 3

Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export?

Back 3

Portability

Front 4

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

Back 4

Referential

Front 5

To break deadlock, the DBMS chooses one deadlocked user to be the ___.

Back 5

victim

Front 6

A ___ is a snapshot of certain data in a database at a given moment in time.

Back 6

view

Front 7

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.

Back 7

DBA

Front 8

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

Back 8

test system

Front 9

___ rules specify which users have what type of access to which data in the database.

Back 9

Authorization

Front 10

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

Back 10

foreign

Front 11

___ converts a table that is in third normal form to a table no longer in third normal form.

Back 11

Denormalization

Front 12

If two or more users are waiting for the other user to release a lock before they can proceed, this is known as a ___.

Back 12

deadlock

Front 13

___ integrity implies that the value entered for any field should be consistent with the data type for that field.

Back 13

Data type

Front 14

Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time?

Back 14

Limitations

Front 15

___ is the process of returning the database to a state that is known to be correct from a state known to be correct.

Back 15

Recovery

Front 16

A string of characters assigned by the DBA to a database that the user must enter to access the database is known as a database ___.

Back 16

password

Front 17

Tables with indexes allow faster searches, but slower performance on ___.

Back 17

updates

Front 18

___ denies access by other users to data while the DBMS processes one user’s updates to the database.

Back 18

Locking

Front 19

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

Back 19

tuning

Front 20

After the database designers complete the information-level design, the DBA does the ___-level design.

Back 20

physical

Front 21

___ integrity constraints help to ensure the accuracy and consistency of individual field values.

Back 21

Data

Front 22

The DBMS accomplishes ___ by reading the log for the problem transactions and applying the before images to undo their updates.

Back 22

backward recovery

Front 23

The technique for identifying the person who is attempting to access the DBMS is known as ___.

Back 23

authentication

Front 24

___ locks forbid any other users from accessing the data in anyway.

Back 24

Exclusive

Front 25

___ identify users by physical characteristics such as fingerprints, voiceprints, handwritten signatures, and facial characteristics.

Back 25

Biometrics