Computer Sciences > Gate 2022 > 1
Consider the following three relations in a relational database. Employee (eId, Name ), Brand (bId, bName), Own (eId, bId ) Which of the following relational algebra expressions return the set of eIds who own all the brands?
A
πeldeld,bld(own)/πbrand))
B
πeld(own)-πeld((πeld(own)xπbld(brand))-πbld,eld(own))
C
πeldeld,bld(own)/πown))
D
πeld((πeld(own)xπbld(own))/πbld(brand))

Correct : a,b

Similar Questions

Consider the following recurrence: f(1) = 1; f(2n) = 2f(n) -1, for n≥1; f(2n+1) = 2f(n) +1, for n≥1; Then, which of the following statements is/are TRUE?
#321 MSQ
Consider the following languages: L1 = {ww | w ∈ {a, b}* } L2 = {anbncn | m, n≥ 0} L3 = {ambncn | m, n≥ 0} Which of the following statements is/are FALSE?
#322 MSQ
Which of the following statements is/are TRUE with respect to deadlocks?
#323 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......