Contents

A primary key that consists of more than one attribute is called…..
a) foreign key                      

b) composite key
c) multivalued key             

d) global key

b

How many types of relations in relational database model?
a) one    

b) two    

c) three 

d) four

c

Explanation: base table, query results, views


Which of the following are advantages of views?
a) security                            

b) simplicity
c) insulation for change     

d) all of these

d

In 3NF, which form of dependency is removed?
a) functional                        

b) non-functional
c) associative                       

d) transitive

d

In relational database, table is also called
a) tuple                                 

b) relation
c) file                                     

d) schema

b

In 3NF, a non-key attribute must not depend on a……
a) non-key attribute          

b) key attribute
c) composite key

d) sort key

a