GkSeries.com

Relational Calculus and Relational Algebra Objective 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
(11) Which clause from the following corresponds to the projection operation of the relational algebra ?
[A] from
[B] select
[C] where
[D] none of these

Comment

Answer: Option [B]
(12) Which one of the clause is useful in defining the notion of tuple variable ?
[A] as
[B] by
[C] from
[D] none of these

Comment

Answer: Option [D]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(13) The intersect operation :
[A] automatically eliminates duplicates
[B] automatically eliminates duplicates, if we provide all clause with intersect
[C] never eliminates duplicates
[D] none of these

Comment

Answer: Option [A]
(14) Which symbol is used to select tuples in relational algebra ?
[A] Alpha
[B] Beta
[C] Sigma
[D] Phi

Comment

Answer: Option [C]
(15) Consider the join of relation a with a relation b. If A has k tuples and B has r tuples then the maximum and minimum sizes of the join respectively are
[A] K + r and 0
[B] r.k and 0
[C] r + k and |k-r|
[D] r.k and r+k

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