ITSS Practice q

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

• Queries against records in the database tables

• Names of tables in a database

• Properties of tables in a database

• Names of columns in a database and their associated tables

• Properties of columns

A relational database is ________.

• a self-describing collection of related tables

• a collection of forms and reports that support a given purpose

• a set of metadata

• a library of queries and data files for querying

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

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

• True

• False

An advantage of keeping data in lists, in Excel, is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well

• False

• True

Usually, a database table containing both rows and columns is designed to store data for exactly two themes.

• False

• True

The DBMS is used to create the database itself.

• True

• False

A key must be unique.

• False

• True

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

• True

• False

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

• True

• False

If the condition exists such that knowing the value of attribute X determines the value of attribute Y, then attribute Y is functionally dependent on attribute X.

• True

• False