Week 2 quiz 1. (TCO A) The purpose of a database is to _____. help people keep track of things store data in tables maintain data on different things in different tables create tables of rows and...

Week 2 quiz

1. (TCO A) The purpose of a database is to _____.

help people keep track of things

store data in tables

maintain data on different things in different

tables

create tables of rows and columns

allow Web applications to retrieve data

Question 2.(TCO C) Referential integrity constraints are

used to limit the possible values of a _____.

candidate key

surrogate key

foreign key

composite key

dependency

Question 3. (TCO D) In a SQL query, which of the following

symbols is used by ANSI SQL to represent all of the columns in a single table?

_ (underscore)

? (question mark)

* (asterisk)

% (percent)

# (pound)

Question 4. (TCO G) An online drugstore, such as

Drugstore.com, is an example of a(n) _____.

single-user database application

an ERP application

e-commerce database application

All of the above

Both A and C

Question 5. (TCO C) A relation is in Boyce-Codd normal form

if _____.

every determinant is a candidate key

every determinant is a primary key

every attribute is a candidate key

there is more than one candidate key

there is more than one primary key

Question 6. (TCO D) Match the following terms to their

definitions.

5

: MAX

» SQL built-in function that

obtains the largest value in a numeric column

2

: SUM

» SQL built-in function that

totals values in a numeric column

1

: AVG

» SQL built-in function that

computes the average of values in a numeric column

4

: MIN

» SQL built-in function that obtains

the smallest value in a numeric column

3

: COUNT

» SQL built-in function that

computes the number of rows in a table

Instructor Explanation: General

Feedback: See Chapter 2 in the textbook.

Question 7. (TCO C) Explain the relationships among primary

keys and functional dependencies.