Relational Algebra Questions And Answers

Here you can find Relational Algebra Questions and Answers.

Why Relational Algebra Questions and Answers Required?

In this Relational Algebra Questions and Answers section you can learn and practice Relational Algebra Questions and Answers to improve your skills in order to face technical inerview conducted by organisations. By Practicing these interview questions, you can easily crack any Exams interview.

Where can I get Relational Algebra Questions and Answers?

AllIndiaExams provides you lots Relational Algebra Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Relational Algebra Questions and Answers as PDF files and eBooks.

How to solve these Relational Algebra Questions and Answers?

You no need to worry, we have given lots of Relational Algebra Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Competitive Exams interview.

Relational Algebra Questions & Answers

1. Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.

Relational Algebra Questions & Answers

2. Which of the following is a fundamental operation in relational algebra ?

Relational Algebra Questions & Answers

3. Which of the following is used to denote the selection operation in relational algebra ?

Relational Algebra Questions & Answers

4. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.

Relational Algebra Questions & Answers

5. The ___________ operation, denoted by -, allows us to find tuples that are in one relation but are not in another.

Relational Algebra Questions & Answers

6. Which is a unary operation:

Relational Algebra Questions & Answers

7. Which is a join condition contains an equality operator:

Relational Algebra Questions & Answers

8. In precedence of set operators the expression is evaluated from

Relational Algebra Questions & Answers

9. Which of the following is not outer join ?

Relational Algebra Questions & Answers

10. The assignment operator is denoted by

Relational Algebra Questions and Answers

This is the DBMS questions and answers section on "Relational Algebra" with explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given and it would be easy to understand.

1. Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.

A. Relational
B. Structural
C. Procedural
D. Fundamental

Answer & Explanation

Answer: Option C

Explanation:

Procedural

This language has fundamental and other operations which are used on relations .

Workspace

Report Error

2. Which of the following is a fundamental operation in relational algebra ?

A. Set intersection
B. Natural join
C. Assignment
D. None of the mentioned

Answer & Explanation

Answer: Option D

Explanation:

None of the mentioned

The fundamental operations are select, project, union, set difference, Cartesian product, and rename.

Workspace

Report Error

3. Which of the following is used to denote the selection operation in relational algebra ?

A. Pi (Greek)
B. Sigma (Greek)
C. Lambda (Greek)
D. Omega (Greek)

Answer & Explanation

Answer: Option B

Explanation:

Sigma (Greek)

The select operation selects tuples that satisfy a given predicate.

Workspace

Report Error

4. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.

A. Predicates, relation
B. Relation, Predicates
C. Operation, Predicates
D. Relation, Operation

Answer & Explanation

Answer: Option A

Explanation:

Predicates, relation

Workspace

Report Error

5. The ___________ operation, denoted by -, allows us to find tuples that are in one relation but are not in another.

A. Union
B. Set-difference
C. Difference
D. Intersection

Answer & Explanation

Answer: Option B

Explanation:

Set-difference

The expression r - s produces a relation containing those tuples in r but not in s.

Workspace

Report Error

Govt Exam Online Mock Tests

SSC Mock Test Online

IBPS Mock Test Online

RRB Online Mock Test

LIC Online Mock Test

SBI Online Mock Test

Free Mock Test Series

CAT Mock Test

GATE Mock Test

MAT Mock Test