test 1 reivew part 5

Question 1

A relational database stores data in the form of lists. (T/F)

Answer 1

False

Question 2

One problem with storing duplicated data is the potential for inconsistent values.

Answer 2

True

Question 3

Most organizations create and use their own database management system (DBMS) products.

Answer 3

False

Question 4

Which of the following would not be an example of database metadata?

A) Names of tables in a database

B) Properties of tables in a database

C) Names of columns in a database and their associated tables

D) Properties of columns

E) Queries against records in the database tables

Answer 4

E) Queries against records in the database tables

Question 5

Every relation is a table, but not every table is a relation. (T/F)

Answer 5

True

Question 6

DBMS products allow you to specify whether a null value can occur in a column. (T/F)

Answer 6

True

Question 7

You can’t have nulls in either a primary or foreign key (T/F)

Answer 7

True

Question 8

One important relational design principle is that:

A) every determinant must be a candidate key.

B) every candidate key must not be a determinant.

C) every primary key must be a surrogate key.

D) every determinant must be functionally dependent on the primary key.

E) every primary key must be functionally dependent on every determinant.

Answer 8

A) every determinant must be a candidate key.