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

Comment

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

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(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

Comment

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

Comment

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

Comment

Answer: Option [B]

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!

Chapters