IS 3310 Chapter 5

In a relational database, a record is also called a(n): A. tuple. B. key field. C. entity. D. field. E. table.

A. tuple.

Which of the following is the most prominent data manipulation language today? A. Access B. DB2 C. SQL D. Crystal Reports E. Hadoop

C. SQL

A characteristic or quality describing an entity is called a(n): A. field. B. tuple. C. key field. D. attribute. E. table.

D. attribute.

The select operation: A. combines relational tables to provide the user with more information than is otherwise available. B. creates a subset consisting of columns in a table. C. identifies the table from which the columns will be selected. D. creates a subset consisting of all records in the file that meet stated criteria.

D. creates a subset consisting of all records in the file that meet stated criteria.

The logical view of a database: A. shows how data are organized and structured on the storage media. B. presents an entry screen to the user. C. allows the creation of supplementary reports. D. presents data as they would be perceived by end users. E. shows the relationships between entities and attributes.

D. presents data as they would be perceived by end users.

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends: A. in two short marks. B. in one short mark. C. with a crow's foot. D. with a crow's foot preceded by a short mark. E. in three short marks.

D. with a crow's foot preceded by a short mark

Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? A. Referential integrity module B. Data definition diagram C. Entity-relationship diagram D. Relationship dictionary E. Data dictionary

E. Data dictionary

Which of the following allows users to add, change, delete, or retrieve data in a database? A. Attribute generation B. Report generation tools C. Data dictionary D. Query wizard tool E. Data manipulation language

E. Data manipulation language

Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables? A. Two-tiered DBMS B. Pre-digital DBMS C. Open source DBMS D. Hierarchical DBMS E. Relational DBMS

E. Relational DBMS

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent. A. intersection relations B. one-to-one ordering C. entity-relationship diagrams D. foreign keys E. referential integrity rules

E. referential integrity rules