Database Concepts Quiz

A characteristic or quality that describes a particular database entity is called a(n):

• Field

• Tuple

• Key field

• Attribute

Data ________ occurs when the same data is duplicated in multiple files of a database.

• Redundancy

• Repetition

• Independence

• Partitions

Which of the following occurs when the same attribute in related data files has different values?

• Data redundancy

• Data duplication

• Data discrepancy

• Data inconsistency

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues?

• Program-data dependence

• Lack of flexibility

• Poor security

• Data redundancy

Which common database challenge is illustrated by a person receiving multiple copies of a catalog each addressed to a slightly different variation of their full name?

• Data normalization

• Data redundancy

• Data inconsistency

• Data duplication

Which of the following is a DBMS for desktop computers?

• DB2

• Oracle Database

• Microsoft SQL Server

• Microsoft Access

A field identified in a table as holding the unique identifier of the table's records is called the:

• Primary key

• Key field

• Unique ID

• Key attribute

The select operation in a database:

• Combines relational tables

• Creates a subset consisting of all records that meet stated criteria

• Creates a subset consisting of columns in a table

• Identifies the table from which columns will be selected

A record is a group of related:

• Fields

• Bytes

• Tables

• Attributes

Which of the following is an example of an entity-attribute relationship?

• The entity CUSTOMER with the attribute ADDRESS

• The entity CUSTOMER with the attribute PRODUCT

• The entity PRODUCT with the attribute CUSTOMER

• The entity PRODUCT with the attribute PURCHASE