Online GK Series

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

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

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

Answer: Option [D]
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]


Please Like Us