Exam 4: Database Processing

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

________ are used by users to read,insert,modify,and delete data in a database.

The rows in a database are called ________.

MySQL is an open source DBMS product that is license-free for most database applications.

Attributes are used to describe characteristics of entities.

The easiest time to change the database structure is after the data modeling stage.

A spreadsheet can be used to store data if the structure of a list is simple.

________ is the term used to describe data collections that are characterized by huge volume,rapid velocity,and great variety.

In an E-R diagram,a line between two entities represents a(n)________.

________ in an E-R diagram refer to the least number of entities required in a relationship.

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

Which of the following is a developmental task of database administration?

SQL is an international standard language for processing a database.

Which of the following refers to the problem that exists in database applications when two users modify the same data item,but only one of those changes is recorded?

The lost update problem can be resolved by implementing multi-user database processing.

In a data model,a(n)________ is something that a user wants to track.

A data integrity problem will occur only if ________.

Every table in a normalized database has a ________.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

A line in an E-R diagram is used to represent the attributes of the entities.