Relational Calculus and Relational Algebra Objective Questions and Answers | Database Management System MCQs

11 Which clause from the following corresponds to the projection operation of the relational algebra ?
A from
B select
C where
D none of these

Answer: Option [B]
12 Which one of the clause is useful in defining the notion of tuple variable ?
A as
B by
C from
D none of these

Answer: Option [D]
13 The intersect operation :
A automatically eliminates duplicates
B automatically eliminates duplicates, if we provide all clause with intersect
C never eliminates duplicates
D none of these

Answer: Option [A]
14 Which symbol is used to select tuples in relational algebra ?
A Alpha
B Beta
C Sigma
D Phi

Answer: Option [C]
15 Consider the join of relation a with a relation b. If A has k tuples and B has r tuples then the maximum and minimum sizes of the join respectively are
A K + r and 0
B r.k and 0
C r + k and |k-r|
D r.k and r+k

Answer: Option [B]