Quiz 3 Ch3

Question 1

A __ is used to link one table with another in a relational database

Answer 1

Foreign Key

Question 2

Which concept ensures that each row in a table has unique identifier and that no part of the primary key can have null value?

Answer 2

Entity Integrity

Question 3

Which type of JOIN retains unmatched rows from one of the tables?

Answer 3

Outer Join

Question 4

Which type of integrity does a Foreign Key enforce?

Answer 4

Referential Integrity

Question 5

Which key is primarily used for data retrieval purposes in a relational database?

Answer 5

Secondary Key

Question 6

What operation between two sets, A and B, results in a set C that contains the tuples common to both A and B?

Answer 6

Intersection

Question 7

How is a Many-to-Many (M:N) relationship typically handled in a relational database?

Answer 7

By creating a middle (linking) table

Question 8

Which relationship type would best describe Employees working in Departments where each department can have many employees, but each employee works in only one department?

Answer 8

One-to-Many (1:M)
Many-to-One (M:1)

Question 9

In a bookstore database, each book can have multiple authors, and each author can write multiple books. How would you model this relationship?

Answer 9

Many-to-Many (M:M)

Question 10

What does an attribute describe in a database?

Answer 10

A characteristic of an entity