GkSeries.com

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

Download PDF

Database management system objective questions and answers page contain 5 questions from chapter Relational algebra and calculus. Each MCQ has 4 possible answers. Choose your answer and check it with the given correct answer.
Go To Download Page
(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

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

Please share this page

DATABASE MANAGEMENT SYSTEM MULTIPLE CHOICE QUESTIONS & ANSWERS – E-BOOK

Chapters

Click Here to Read more questions

Teacher Eligibility Test