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

(6) Which of the following is not a valid binary operation in the relational algebra ?
[A] project
[B] union
[C] set difference
[D] cartesian product

Comment

Answer: Option [A]
(7) Relational Calculus is :
[A] Programming language
[B] Functional language
[C] Procedural language
[D] Non-procedural language

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(8) Pick out the false statement from the following :
[A] The tuples within base relations corresponds to entries in the real world
[B] DBMS provides media recovery by restoring the database from a previous dump
[C] DBMS that support mandatory controls can be reffered as multilevel secure system
[D] None of these

Comment

Answer: Option [D]
(9) Consider the join of a relation R with a relation S. If R has m tuples and S has n tuples. Then the maximum and minimum size of the join respectively are :
[A] m+n and 0
[B] m+n and [m-n]
[C] mn and 0
[D] mn and m+n

Comment

Answer: Option [C]
(10) Consider P1 and P2 are formulae. Which of the following is correct ?
[A] P1 ∧ P2 is equlvalent to ⌈(P1V⌈(⌈P2))
[B] P1 ∧ P2 is equlvalent to ⌈(⌈(P1)V⌈(P2))
[C] P1 ∧ P2 is equlvalent to ⌈(⌈(P1)V⌈(⌈P2))
[D] None of the above

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