FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: The Relational Database Model

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

True/False

Review LaterAdd Note

Review Later

Character data can contain any character or symbol intended for mathematical manipulation.

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

The DIVIDE operation uses one single-column table (e.g., column "a") as the divisor and one two-column table (e.g., columns "a" and "b") as the dividend.

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

Referential dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.

The row's range of permissible values is known as its domain.

To avoid nulls, some designers use special codes, known as , to indicate the absence of some value.

The catalog can be described as a detailed system data dictionary that describes all objects within the database, including data about table names, the table's creator and creation date, the number of columns in each table, the data type corresponding to each column, index filenames, index creators, authorized users, and access privileges.

A is the primary key of one table that has been placed into another table to create a common attribute.

Date attributes contain calendar dates stored in a special format known as the date format.

You can think of a table as a persistent representation of a logical relation.

In the relational model, are important because they are used to ensure that each row in a table is uniquely identifiable.

Relational algebra defines the theoretical way of manipulating table contents using relational operators.

In a relational model, are also used to establish relationships among tables and to ensure the integrity of the data.

When you define a table's primary key, the DBMS automatically creates a(n) index on the primary key column(s) you declared.

Only a single attribute, not multiple attributes, can define functional dependence.

A key is defined as a key that is used strictly for data retrieval purposes.