Which of the following join includes all tuples of left hand
relation and right hand relation?
a) left outer join
b) right outer join
c) full outer join
d)
all of these
A constraint between two attributes is called……
a) functional relation
b) attribute dependency
c) functional dependency
d) functional relation constraints
The attribute on the left hand side of arrow in a functional dependency is……
a) candidate key
b) determinant
c) foreign key
d) primary key
What is the goal of normalization?
a) get stable data structure
b) increased number of relations
c) increase dependency
d) none of these
A relation is in 2nd normal form if it is in frat normal form and all its non-key attributes are…….
a) dependent on primary key
b) dependent on entire key
c) independent on primary key
d) independent on other key
In 2nd normal form, which form of dependency is removed?
a) functional
b) partial
c) associative
d) transitive
