Question 1

3NF requires that a table be in 2NF and have transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 2

Structured Query Language is a commonly used language for accessing data in database tables.

Accepted Answer

A) True 
 B)False

Question 3

If an employee record contains both a company-assigned employee ID and a Social Security number, then both columns are ____ keys.

Accepted Answer

A)  primary 
B)  candidate 
C)  secondary 
D)  foreign

Question 4

Connecting two tables based on the values in a common column is called a(n) ____ operation.

Accepted Answer

A)  union 
B)  join 
C)  intersection 
D)  liberation

Question 5

Some database designers insert an exclamation point after the key instead of underlining it.

Accepted Answer

A) True 
 B)False

Question 6

____ is the unnecessary repetition of data.

Accepted Answer

A)  Data duplication 
B)  Data replication 
C)  Data normalization 
D)  Data redundancy

Question 7

____ is the process of coding data into a format that human beings cannot read.

Accepted Answer

A)  Integrity 
B)  Encoding 
C)  Encryption 
D)  RFID

Question 8

A common reason you create a one-to-one relationship is security.

Accepted Answer

A) True 
 B)False

Question 9

The ____ assigned to a user indicate which parts of the database the user can view, modify, or delete.

Accepted Answer

A)  permissions 
B)  controls 
C)  locks 
D)  attributes

Question 10

____________________ are composed of associated records.

Accepted Answer

The answer of ____________________ are composed of associated records....

Question 11

Discuss the use of null values within a database table.

Accepted Answer

The answer of Discuss the use of null values within...

Exam 14: Using Relational Databases

3NF requires that a table be in 2NF and have transitive dependencies.