Exam 11: Databases

____ refers to the number of associations that can exist between two record types.

Critical Thinking questions (Multiple Choice) You're setting up a new database for a survey on movie viewing in your hometown. Survey results include residents, visitors, types of movies each sees, how much they pay, and when they attend. You will need to create different ____ to store the information in one database.

What are the limitations of the global UPDATE command within SQL?

Surveys show that as many as ____ of businesses never change the standard administrator password for a DBMS.

The term RDBMS refers to software that is designed to manage data stored in a database.

If the data you enter is shorter than the allocated field length, blank spaces are automatically added to fill the field.

The goal of normalization is to minimize data ____.

Each column of a relational database table is equivalent to a(n) ____________________.

In a relational database, relationships can be added, changed, or deleted on demand.

The term database ____________________ refers to the arrangement of the fields, tables, and relationships in a database.

In a(n) relational database, relationships are specified by joining common data stored in the fields of records in different tables.

Discuss in detail the two things that access controls do.

A(n) ____________________ refers to a collection of data fields about one entity--a person, place, thing, or event.

In SQL, the SEARCH command searches for records.

The relationship shown in the third row of the above figure is a many-to-many relationship.

What is the lowest level of user access privilege and what does it entitle you to?

A(n) ____ allows you to create, update, and administer a relational database.

Differentiate between static Web publishing and dynamic Web publishing.

____ controls can block unauthorized users and limit activities of authorized users.