Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

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]


Useful Computer Science EBooks