Multiple Choice questions

1) is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

A) Data integrity

B) Data anomaly

C) Data ubiquity

D) Data quality

2) A desktop database is a database.

A) single-user

B) multiuser

C) workgroup

D) distributed

3) Data warehouse contains historical data obtained from the.

A) operational databases

B) desktop database

C) enterprise databases

D) workgroup databases

4) Data is said to be verifiable if:

A) the data always yields consistent results.

B) the data cannot be changed or manipulated.

C) the data is obtained from trusted sources.

D) the data is stored in different places within the database.

5) provide a description of the data characteristics and the set of relationships that link the data found within the database.

A) Queries

B) End-user data

C) Metadata

D) Schemas

6) serve as the intermediary between the user and the database.

A) DBMSs

B) Metadata

C) End-user data

D) Programming languages

7) From a database point of view, the collection of data becomes meaningful only when it reflects properly defined_____.

A) business rules

B) business norms

c) business goals

8. The basic form of an SQL retrieval command is:

a. SELECT-WHERE-FROM c. SELECT-WHERE

b. CREATE-SELECT-FROM d. SELECT-FROM-WHERE

9. Which of the following queries will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances.

	a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ;
	b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ;
	c. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance
	d. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;

10. Students and classes have a. relationship.

a. one-to-one

b. one-to-many

c. many-to-one

d. many-to-many

11. Referential integrity dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.

a. integrity

b. uniqueness

c. model

d. attribute

12) The ..relationship is the relational model ideal.

a. 1:1

b. 1:M

c. M:1

d. M:N

13) data exist in a format that does not lend itself to processing that yields information.

A) Structured

B) Semi structured

C) Unstructured

D) Historical

14) Which of the following is true of business rules?

A) They allow the designer to set company policies with regard to data.

b) They allow the designer to develop business processes.

c) They can serve as a communication tool between the users and designers.

d) They provide a framework for the companys self-actualization.

15) A noun in a business rule translates to a(n) in the data model.

A) Entity

b) attribute

c) relationship

d) constraint