Online GK Series

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

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]
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]

Computer Science Books

Chapters

Please Like Us
Brand