Contents

Different attributes in two different tables having same name are referred to as…..
a) synonym                         

b) homonym
c) acronym                          

d) mutually exclusive

b

Every relation must have……
a) primary key   

b) candidate key
c) secondary key

d) mutually exclusive

a

Which of the following is entity integrity rule is?
a) no primary key can null                             
b) each entity must have primary key
c) primary key must have only attribute
d) none of these

a

How many categories of data integrity?
a) one    

b) two    

c) three 

d) four

c

Explanation: entity integrity, domain integrity, referential integrity


A rule that state that each foreign key value must match a primary key value in the other relation is called…..
a) referential integrity                     
b) key match rule
c) entity key group             
d) foreign/primary match rule

a

The rule ensure that primary key cannot contain null value is called……
a) referential integrity
b) entity integrity

c) entity key group             
d) foreign/primary match rule

b