Database Management System - Relational Algebra Online Test

This online test section contains the next top best multiple-choice type questions answers (MCQs) based on Database Management System related to Relational Algebra. This online Quiz / Practice Test is suitable for various exams conducted by various educational organizations. These Objective questions have been selected from previous years question papers of various competitive exams.

Test Instructions
Question type	Questions remain the same unless test is updated
Total Number of Questions	25
Time Limit	10 Minutes
Points	1 Point for each Question

TIME LEFT : 0

Test-summary

0 of 25 questions completed

Questions:

Information

You have already completed the Test before. Hence you can not start it again.

Test is loading...

You must sign in or sign up to start the Test.

You have to finish following Test, to start this Test:

Results

0 of 25 questions answered correctly

Time Taken by You:

Time has elapsed

You have reached 0 of 0 points, (0)

Categories

Not categorized 0%

Answered
Review

Question 1 of 25

Q-1. Find equivalent relational algebraic expression for the following SQL query select C.sid from catalog C, parts P where (P.color = red or P.color = green) and P.pid = C.pid

π sid (σcolor=red or color=green(parts)אpid catalog)

π sid (σcolor=red or color=red(parts)אpid catalog)

π pid (σcolor=red or color=green(parts)אpid catalog)

π pid (σcolor=red or color=green(parts)אsid catalog)

Your Answer : Correct

Your Answer : Incorrect

Question 2 of 25

Q-2. Two relations are A(x,y) and B(y). Then the relation algebra operation Division i.e. A/B is

πx(A) – πxC (πx((A × B) – A)

πx(A) – πx (πx((A × B) – A)

πx(A) – πx (Cπx((A) × B) – A)

A – πxC (πx(A)× B)

Your Answer : Correct

Your Answer : Incorrect

Question 3 of 25

Q-3. Let R be a relation of degree n. How many different projections on R are possible

n+1

n–1

2^n –1

Your Answer : Correct

Your Answer : Incorrect

Question 4 of 25

Q-4. EXCEPT in SQL is analogous to

Intersection operator of relational algebra

Join operator of relational algebra

Difference operator of relational algebra

Cartesian product operator of relational algebra

Your Answer : Correct

Your Answer : Incorrect

Question 5 of 25

Q-5. Let A = {0, 1} × {0, 1} × {0, 1} and B = {a, b, c} × {a, b, c} × {a, b, c}. Suppose A is listed in lexicographic order based on 0 < 1 and B is listed in lexicographic order based on a < b < c. If A×B×A is listed in lexicographic order, then the next element after ((1, 0, 0), (c, c, c), (1, 1, 1)) is

((1, 0, 1), (a, a, b), (0, 0, 0))

((1, 0, 1), (b, a, a), (0, 0, 1))

((1, 0, 1), (a, a, a), (0, 0, 0))

((1, 0, 0), (a, a, b), (0, 0, 1))

Your Answer : Correct

Your Answer : Incorrect

Question 6 of 25

Q-6. Consider the statement, “(–2 < x ≤ 10) and (–5 ≤ x < 3)”. This means that

–2 < x < 3

–2 ≤ x < 3

–2 < x ≤ 3

–5 ≤ x ≤ 10

Your Answer : Correct

Your Answer : Incorrect

Question 7 of 25

Q-7. For two sets P and Q and null set Ø, which of the following statements is NOT correct?

P U (P ∩ Q) = P

P - Ø = P

P U Ø = P

P ∩ Ø = P

Your Answer : Correct

Your Answer : Incorrect

Question 8 of 25

Q-8. Consider two sets A and B. Element in each set is a positive integer. These sets are represented as bit vector i.e. kth bit set to 1 if number k belongs to set. For example, A = {0, 1, 3, 4, 7}; bit vector representation shall be 10011011. (LSB corresponds to number 0) In such a representation, A - B (difference of sets) can be computed using

A AND B

A XOR B

A OR B

A AND (NOT (B)

Your Answer : Correct

Your Answer : Incorrect

Question 9 of 25

Q-9. In a group of 180 people, 120 can either swim or jog or both. If only 65 persons can swim and 45 can both swim and jog, how many can only jog?

100

110

Your Answer : Correct

Your Answer : Incorrect

Question 10 of 25

Q-10. Which of the following relations is correct?

10^5 < 2^20 < 10^6

10^6 < 2^20 < 10^7

10^5 > 2^20 > 10^6

10^6 > 2^20 > 10^7

Your Answer : Correct

Your Answer : Incorrect

Question 11 of 25

Q-11. The PROJECT operation in Relational Algebra is used for:

Combining two relations

Extracting columns from a relation

Creating a new relation

Removing duplicates from a relation

Your Answer : Correct

Your Answer : Incorrect

Question 12 of 25

Q-12. Which operation in Relational Algebra is used to combine two relations based on a common attribute?

Select

Project

Join

Union

Your Answer : Correct

Your Answer : Incorrect

Question 13 of 25

Q-13. In Relational Algebra, what does the UNION operation do?

Combines two relations and eliminates duplicates

Combines two relations and retains duplicates

Creates the Cartesian product of two relations

Finds the intersection of two relations

Your Answer : Correct

Your Answer : Incorrect

Question 14 of 25

Q-14. Which operation in Relational Algebra is used to find the intersection of two relations?

Join

Project

Intersect

Minus

Your Answer : Correct

Your Answer : Incorrect

Question 15 of 25

Q-15. What is the result of the CARTESIAN PRODUCT operation in Relational Algebra?

A relation containing all possible combinations of rows from two input relations

A relation containing the common elements of two input relations

A relation containing the union of two input relations

A relation containing the difference between two input relations

Your Answer : Correct

Your Answer : Incorrect

Question 16 of 25

Q-16. What is the purpose of the RENAME operation in Relational Algebra?

To change the name of a relation

To rename attributes in a relation

To perform a cross join operation

To remove rows from a relation

Your Answer : Correct

Your Answer : Incorrect

Question 17 of 25

Q-17. In Relational Algebra, what does the DIVISION operation do?

Combines two relations

Creates a new relation

Finds tuples that are common to two relations

Determines if one relation is a subset of another

Your Answer : Correct

Your Answer : Incorrect

Question 18 of 25

Q-18. Which operation in Relational Algebra is used to create a new relation from the rows of two input relations that are not in common?

Select

Project

Union

Minus

Your Answer : Correct

Your Answer : Incorrect

Question 19 of 25

Q-19. The σ symbol is used to represent which operation in Relational Algebra?

Select

Project

Join

Union

Your Answer : Correct

Your Answer : Incorrect

Question 20 of 25

Q-20. Which operation in Relational Algebra is used to calculate the number of tuples in a relation?

Project

Count

Join

Union

Your Answer : Correct

Your Answer : Incorrect

Question 21 of 25

Q-21. What is the result of the EXTEND operation in Relational Algebra?

A new relation containing additional attributes

A new relation containing additional tuples

A new relation containing all possible combinations of rows

A new relation containing the intersection of two relations

Your Answer : Correct

Your Answer : Incorrect

Question 22 of 25

Q-22. Which operation in Relational Algebra is used to calculate the average value of an attribute?

Sum

Avg

Min

Max

Your Answer : Correct

Your Answer : Incorrect

Question 23 of 25

Q-23. In Relational Algebra, what does the SUM operation do?

Calculates the maximum value of an attribute

Calculates the average value of an attribute

Calculates the sum of values in an attribute

Calculates the minimum value of an attribute

Your Answer : Correct

Your Answer : Incorrect

Question 24 of 25

Q-24. What is the purpose of the INTERSECT operation in Relational Algebra?

To find the common elements of two relations

To create a new relation

To combine two relations and eliminate duplicates

To find the difference between two relations

Your Answer : Correct

Your Answer : Incorrect

Question 25 of 25

Q-25. In Relational Algebra, what does the SET DIFFERENCE operation do?

Combines two relations and eliminates duplicates

Combines two relations and retains duplicates

Finds the intersection of two relations

Finds the difference between two relations

Your Answer : Correct

Your Answer : Incorrect

Practice More Online Tests

Database Management System – Locking Protocol (2PL) Online Test

Database Management System – Transaction,Concurrency Control,Recovery,Serializability Online Test

Database Management System – Normalization (1NF,2NF,3NF,BCNF) Online Test

Database Management System – SQL Online Test

Database Management System – ER Model (Entity Relationship) Online Test

Database Management System – Relational Algebra Online Test

Database Management System – Functional Dependency Online Test

Database Management System – B tree,Indexing,hashing Online Test

Database Management System Online Test 1 – Randomized MCQs

Database Management System Online Test 2 – Randomized MCQs

EXAMRADAR

For Solo Learner Computer science

Database Management System – Relational Algebra Online Test

Test-summary

Information

Results

Categories

Practice More Online Tests