Exam 14: Databases

A unary operator is applied to _______ relation(s) and creates an output of ________ relation(s).

Which of the following is a binary operator?

Which of the following is a unary operator?

Each row in a relation is called _______.

In a three-level DBMS architecture, the _______ level determines where data is actually stored on the storage devices.

Of the various database models, the _______ model is the most prevalent today.

_______ is a declarative language used on relational databases.

You want to create a relation called New that contains tuples that belong to both relation A and relation B. For this, you can use the _______ operation.

The _______ level of a three-level DBMS architecture defines the logical view of the data.

A binary operator is applied to _______ relations (s) and creates an output of ________ relation(s).

Each column in a relation is called _______.

In a three-level DBMS architecture, the layer that interacts directly with the hardware is the _______ level.

If you want to change the value of an attribute of a tuple, you use the _______ operation.

If you need to delete an attribute in a relation, you can use the _______ operation.

The operation that takes two relations and combines them based on common attributes is the _________ operation.

The data model and the schema of a DBMS are often defined at the _______ level.

In a three-level DBMS architecture, the _______ level interacts directly with the users.

The unary _______ operation always results in a relation that has exactly one more row than the original relation.