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

Questions
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

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

Answer: Option [D]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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

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

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

Answer: Option [B]

Chapters

ADRE 3.0 Complete Study Material