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 21

Multiple Choice

Review LaterAdd Note

Review Later

____ yields only the rows that appear in both tables.

A) INTERSECT
B) UNION
C) DIFFERENCE
D) SELECT

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Controlled ____ makes a relational database work.

A) relations
B) logic
C) chaos
D) redundancy

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

Each table in a relational database must have a primary key.

No data entry at all is known as a(n) ____.

In a relational model,if A determines B,C,and D,you write A = B,C,D.

As rare as 1:1 relationships should be,certain conditions absolutely require their use.

The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

DBMSs use indexes for many different purposes.

A(n)____________________ links tables on the basis of an equality condition that compares specified columns of each table.

A(n)____________________ provides a detailed description of all tables found within the user/designer-created database.

____________________ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

In a database context,a(n) ____ indicates the use of different names to describe the same attribute.

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 data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

Tables within a database share common attributes that enable the tables to be linked together.

The order of the rows and columns is important to the DBMS.

If one department chair-a professor-can chair only one department and one department can have only one department chair,then the entities PROFESSOR and DEPARTMENT exhibit a(n)____________________ relationship.

Describe the use of the UNION operator.

____ data can have only a true or false (yes or no) values.