Contents

How many types of problems in relation?
a) one    

b) two    

c) three  

d) four

d

Explanation: synonym, homonym, redundancy, mutual exclusive of data


Two or more attributes having different names, but same meaning is called…..
a) homonyms                      

b) aliases
c) synonyms                        

d) alternate attributes

c

Which of the following problem is created, when same name is used for two different attributes?
a) homonyms                      

b) aliases
c) synonyms                        

d) alternate attributes

a

Duplication of data in multiple files is called…
a) homonyms                      

b) aliases
c) synonyms                        

d) redundancy

d

Which of the following combines the product, selection, and possibly projection?
a) union                                

b) join
c) intersection                      

d) none of these

b

How many types of joins in database?
a) one    

b) two    

c) three  

d) four

d

Explanation: Theta join, equi join, natural join, outer join