FK values

A) Must be a number.

B) Can be NULL

C) Need not be unique

D) must be a character

CEO of IBM wants to put data access restrictions on some of its employees. What would be the best way to do it

A) Use primary key (PK) C) Use alter statement

B). Use Foreign Key (FK) D) None of the above

Given the following tables

EMPLOYEE (EMP_ID, EMP_Name, DEPT_ID)

PK: doc-ID

DEPT(DEPT_ID, D_Name, Year_started)

PK: Hosp_ID

What is the FK in these relations?

A. There is no FK in these tables

B. EMP_ID is FK in the EMPLOYEE table

C. EMP_ID is FK in the DEPT table

D. None of the above

Refer to EMPLOYEE and DEPT tables in above

Referential integrity error occurs when

A. There is an exact matching value for FK

B. There is an attempt to put duplicate value for FK

C. There is an attempt to put duplicate value for PK

D. There is no matching value for FK in PK

A relationship m:n between two entities

TEAM PLAYER

Implies

A) There is many to many associations between TEAM and PLAYER

B) There is one too many associations between PLAYER to TEAM

C) There is one too many associations between TEAM to PLAYER.

D) There is one to one association between A and B