111. The tuples that are represented in one of two relations and are lost if the JOIN operation is performed are called
a. functional tuples
b. dangling tuples
c. algorithm tuples
d. decomposition tuples
Answer: (b).dangling tuples

112. The inclusion dependencies that are preceding are used to represent
a. algorithmic constraint
b. trivial constraint
c. referential integrity constraint
d. decomposition constraint
Answer: (c).referential integrity constraint

113. The template conclusion is a set of tuples that must be included in the relations in the template dependency called
a. constraint generating templates
b. tuple generating templates
c. schema generating templates
d. relation filtering template
Answer: (b).tuple generating templates

114. The other name of project-join normal form is
a. join normal form
b. trivial normal form
c. sixth normal form
d. fifth normal form
Answer: (d).fifth normal form

115. The types of template dependencies are
a. constraint generating templates
b. tuple generating templates
c. schema generating templates
d. both a and b
Answer: (d).both a and b

116. The decomposition of one relation say R into two relations is classified as
a. functional decomposition
b. ternary decomposition
c. binary decomposition
d. ordinary decomposition
Answer: (c).binary decomposition

117. The type of algorithm in which decomposition of relation schema is constructed from other specific set of functional dependencies is classified as
a. relational synthesis algorithm
b. decomposition algorithm
c. schema synthesis algorithm
d. none of above
Answer: (a).relational synthesis algorithm

118. The conclusion of the template is a condition which must be held on tuples hypothesis in the template dependency called
a. schema generating templates
b. relation filtering template
c. constraint generating templates
d. tuple generating templates
Answer: (c).constraint generating templates

119. The constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called
a. language based constraints
b. tuple based constraints
c. scale based constraints
d. precision based constraints
Answer: (b).tuple based constraints

Page 12 of 12