Relational Algebra - Database Questions & Answers - Sanfoundry PDF

Preview

Summary

Download Relational Algebra - Database Questions & Answers - Sanfoundry PDF

Description

9/28/2020

Relational Algebra - Database Questions & Answers - Sanfoundry





Database Questions and Answers – Relational Algebra « Prev

Next »

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Relational Algebra”. 1. Relational Algebra is a __________ query language that takes t a) Relational b) Structural c) Procedural d) Fundamental View Answer Answer: c Explanation: This language has fundamental and other operations which are used on relations. advertisement

https://www.sanfoundry.com/database-mcqs-relational-algebra/



1/7

9/28/2020

Relational Algebra - Database Questions & Answers - Sanfoundry

2. Which of the following is a

?

a) Set intersection b) Natural join c) Assignment

View Answer Answer: d Explanation: The fundamental operations are select, project, union, set dierence, Cartesian product, and rename. 3. Which of the following is used to denote the a) Pi (Greek) b) Sigma (Greek) c) Lambda (Greek) d) Omega (Greek) View Answer Answer: b Explanation: The select operation selects tuples that satisfy a given predicate. 4. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma. b) Relation, Predicates c) Operation, Predicates d) Relation, Operation

https://www.sanfoundry.com/database-mcqs-relational-algebra/



2/7

9/28/2020

Relational Algebra - Database Questions & Answers - Sanfoundry

Answer: a Explanation: None. advertisement

5. The ___________ operation, denoted by −, allows us to nd tuples that are in one relation but are not in another. a) Union c) Dierence d) Intersection View Answer Answer: b Explanation: The expression r − s produces a relation containing those tuples in r but not in s. 6. Which is a a) Selection operation

:

b) Primitive operation c) Projection operation d)

selection View Answer Answer: d

https://www.sanfoundry.com/database-mcqs-relational-algebra/



3/7

9/28/2020

Relational Algebra - Database Questions & Answers - Sanfoundry

7. Which is a b) Cartesian c) Natural d) Left View Answer Answer: a Explanation: None. advertisement

8. In precedence of a) Left to left c) Right to left d) From user specication View Answer Answer: b Explanation: The expression is evaluated from left to right according to the precedence. 9. Which of the following is a) Left outer join

https://www.sanfoundry.com/database-mcqs-relational-algebra/

?



4/7

9/28/2020

Relational Algebra - Database Questions & Answers - Sanfoundry

View Answer Answer: d Explanation: The FULL OUTER JOIN keyword combines the result of both LEFT and RIGHT joins. 10. a) ->

is denoted by

b) c) = d) == View Answer Answer: b Explanation: The result of the expression to the right of the ← is assigned to the relation variable on the left of the ←. advertisement

Sanfoundry Global Education & Learning Series – Database Management System. To practice all areas of Database Management System, here is complete set on 1000+ Multiple Choice Questions and Answers on Database Management System.  Participate in the Sanfoundry Certication contest to get free Certicate of Merit. Join our soc

https://www.sanfoundry.com/database-mcqs-relational-algebra/

5/7...