DataBase midterm

The DBMS acts as an interface between what two components of an enterprise-class database

system?

• Database application and the database

• Data and the database

• The user and the database application

• Database application and SQL

The following are components of a database except ________ .

• user data

• metadata

• reports

• indexes

SQL stands for ________ .

• Structured Query Language

• Sequential Query Language

• Structured Question Language

• Sequential Question Language

You have run an SQL statement that asked the DBMS to display data in a table named

USER_TABLES. The results include columns of data labeled "TableName,"

"NumberOfColumns" and "PrimaryKey." You are looking at ________ .

• user data.

• metadata

• metadata

• indexes

A DBMS that combines a DBMS and an application generator is ________ .

• Microsoft's SQL Server

• Microsoft's Access

• IBM's DB2

• Oracle Corporation's Oracle

The following are functions of a DBMS except ________ .

• creating and processing forms

• creating databases

• processing data

• administrating databases

Which of the following data constraints would be used to specify that the value of cells in a

column must be one of a specific set of possible values?

• A domain constraint

• A range constraint

• An intrarelation constraint

• An interrelation constraint

Helping people keep track of things is the purpose of a(n) ________ .

• database

• table

• instance

• relationship

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

• primary key.

• foreign key.

• composite key.

• surrogate key.

Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

• A domain constraint

• A range constraint

• An intrarelation constraint