1) A characteristic or quality that describes a particular database entity is called a(n): a) field b) tuple c) key field d) attribute 2) Data ________ occurs when the same data is duplicated in multiple files of a database. a) redundancy b) repetition c) independence d) discrepancy 3) Which of the following enables a DBMS to reduce data redundancy and inconsistency? a) Ability to enforce referential integrity b) Use of a data dictionary c) Ability to minimize isolated files with repeated data d) Ability to create two-dimensional tables 4) A field identified in a table as holding the unique identifier of the table's records is called the: a) key field b) primary key c) unique ID d) primary entity 5) A schematic of the entire database that describes the relationships in a database is called a(n): a) datasets with fewer than a billion records b) intersection relationship diagram c) entity-relationship diagram d) data definition diagram 6) You are creating a database to store temperature and wind data from various airports. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table? a) Address b) City c) Airport code d) State

Database and Information Management

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?