Question 17199 – NTA UGC NET DEC-2022 Paper-2
March 30, 2024GATE 2012
March 30, 2024Database-Management-System
| Question 19 |
Consider the following relations A, B, C.
How many tuples does the result of the following relational algebra expression contain? Assume that the schema of AUB is the same as that of A.
(AUB)⋈A.Id>40∨C.Id<15 C
| 7 | |
| 4 | |
| 5 | |
| 9 |
Question 19 Explanation:
Performs the cross product and selects the tuples whose A∙Id is either greater than 40 or C∙Id is less than 15. It yields:
Correct Answer: A
Question 19 Explanation:
Performs the cross product and selects the tuples whose A∙Id is either greater than 40 or C∙Id is less than 15. It yields: