isds 402 exam 1

study guid for the first exam

Microsoft SQL Server is an example of a ________.

Select one:

a. table

b. database management system

c. data manipulation system

d. list manager

e. database

database management system

Personal DBMS products, such as Microsoft Access, create a clear distinction between the DBMS and the database application.

Select one:

True

False

false

A database may be used to help people with all of the following except ________.

Select one:

a. check on the estimated arrival time of an incoming flight at an airport

b. track which student is assigned to a particular advisor

c. look up their checking account balance over the Internet

d. debug existing program code

e. know the current inventory levels of products their company sells

debug existing program code

A relational database is ________.

Select one:

a. a set of applications and the data sets for those applications

b. a set of metadata

c. a collection of forms and reports that support a given purpose

d. a self-describing collection of related tables

e. a library of queries and data files for querying

a self-describing collection of related tables

A possible problem with keeping data in lists is that if you delete a row of data from a list, you may also delete some data items that you want to keep.

Select one:

True

False

true

Metadata is the user data stored in the database.

Select one:

True

False

false

Application programs are responsible for creating, maintaining, and supporting database backup and recovery systems.

Select one:

True

False

false

By separating data into tables containing data on only one theme each, making changes to the data is simplified.

Select one:

True

False

true

Although users use database systems, they are not considered part of a database system.

Select one:

True

False

false

Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL).

Select one:

True

False

true

To create a well-formed relation through normalization, every determinant must be a candidate key.

Select one:

True

False

true

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint.

Select one:

True

False

true

Given the functional dependency for the attributes of ENTITY1, X → (A, B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).

Select one:

True

False

true

In the normalization process, it is necessary to identify all the determinants in a relation.

Select one:

True

False

true

Every cell in a relation can hold only a single value.

Select one:

True

False

Feedback

true

Surrogate key values have no meaning to the users.

Select one:

True

False

true

To be considered a composite key, a key must contain at least two attributes.

Select one:

True

False

true

Which of the following is not true about null values?

Select one:

a. A null value can mean that no value for the field is appropriate.

b. A null value can mean that the value is known to be blank.

c. A null value can mean that the value is unknown.

d. A null value is ambiguous.

e. Null values cannot be avoided.

null values cannot be avoided

During the normalization process, the remedy for a relation that is not well formed is to ________.

Select one:

a. create a surrogate key

b. create a functional dependency

c. convert it into a list

d. break it into two or more relations that are well formed

e. combine it with another relation that is well formed

break it into two or more relations that are well formed

Microsoft Access forms can only contain data from one table.

Select one:

True

False

false

The E-R Model assumes that all instances of a given entity class have the same attributes.

Select one:

True

False

true

In crow's foot E-R notation, a circle indicates a minimum cardinality of zero.

Select one:

True

False

true

The relationship between STUDENT and DORM can be called as a HAS-A relationship.

Select one:

True

False

Feedback

true

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the ________.

Select one:

a. recursive cardinality

b. ordinality

c. degree

d. maximum cardinality

e. minimum cardinality

minimum cardinality

One or more entities can be associated together in relationships.

Select one:

True

False

true

Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.

Select one:

True

False

false

It is possible for an entity to have a relationship to itself.

Select one:

True

False

true

Relationship degree can be 1:1, 1:N, or M:N.

Select one:

True

False

false

One entity class can have only one entity instance.

Select one:

True

False

false

Optional relationship is indicated by ______ for the minimum cardinality.

Select one:

a. 2

b. 0

c. 1

d. 3

e. many

0