Advanced Database Management System - Tutorials and Notes: Database Management Systems - Relational Algebra quiz
Please visit, subscribe and share 10 Minutes Lectures in Computer Science

## Database management system quiz - DBMS quiz with answers - DBMS multiple choice questions - DBMS basics quiz - DBMS interview questions - Relational Algebra quiz in DBMS - Relational Algebra operations in Database interview questions

Let us use the following relations R and S to answer the questions 1 – 10s;
 A B 3 3 6 4 2 3 3 5 3 6
 B C D 5 1 6 3 3 5 4 3 1
1. Compute R S. Which of the following records will be in the result? Assume each record has the schema (A, B, C, D).
(a) (3, 3, 1, 6)
(b) (6, 4, 4, 1)
(c) (2, 3, 3, 5)
(d) (3, 5, 3, 1)
2. Compute R R.A<S.C S. [this is theta join]. Which of the following records will be in the result? Assume each record has the schema (A, B, C, D).
(a) (2, 3, 3, 5)
(b) (6, 4, 4, 1)
(c) (6, 4, 3, 1)
(d) (3, 5, 1, 6)
3. Compute R R.B < S.D AND R.A<S.C S. [this is theta join]. Which of the following records will be in the result? Assume each record has the schema (A, B, C, D).
(a) (3, 3, 3, 5)
(b) (6, 4, 3, 1)
(c) (2, 3, 3, 5)
(d) (3, 5, 1, 6)
4. Compute π C, D (S). Which of the following records will be in the result?
(a) (5, 1)
(b) (4, 3)
(c) (3, 3)
(d) (3, 5)
5. Compute π B, C (R S). Which of the following records will be in the result?
(a) (6, 4)
(b) (4, 3)
(c) (5, 1)
(d) (5, 3)
6. Compute π B (R) - π B (S). Which of the following records will be in the result?
(a) (6)
(b) (4)
(c) (1)
(d) (5)
7. Compute π B (R) ∩ π B (S). Which of the following records will be in the result?
(a) (6)
(b) (1)
(c) (2)
(d) (5)
8. Compute R S. Which of the following records will be in the result? Assume each record has the schema (A, B, C, D).
(a) (3, 3, 1, 6)
(b) (6, 4, 4, 1)
(c) (3, 5, 1, 6)
(d) (3, 5, 3, 1)
9. Compute π B (R) U π B (S). Which of the following records will be in the result?
(a) (6)
(b) (1)
(c) (2)
(d) (5)
10. Assume a relation R(A, B) with n unique records, and a relation S(B, C) with m unique records. When you compute the natural join between R and S you shall get r records as the result. Which of the following assumptions are correct in terms of (n, m, r)?
(a) (5, 4, 25)
(b) (2, 3, 8)
(c) (3, 3, 10)
(d) (2, 3, 6)

## Go to QUIZZ in Database / DBMS / Advanced DBMS page

#### 2 comments:

1. They have mistak on question 5 ?
Answer will be : (b) (4, 3) & (c) (5, 1)

1. thanks. you are right.

## Featured Content

### Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...