...
Question 10824 – APPSC-2016-DL-CS
November 26, 2023
Logical-Reasoning
November 26, 2023
Question 10824 – APPSC-2016-DL-CS
November 26, 2023
Logical-Reasoning
November 26, 2023

Question 7800 – Database-Management-System

Consider the following relations P(X,Y,Z), Q(X,Y,T) and R(Y,V).

How many tuples will be returned by the following relational algebra query?
x(P.Y=R.Y ∧ R.V=V2)(P × R)) – ∏x(Q.Y=R.Y ∧ Q.T>2)(Q × R))

Correct Answer: B

Question 6 Explanation: 
σ(P.Y = R.Y ∧ R.V = V2)(P × R)

x(P.Y = R.Y ∧ R.V = V2)(P × R))

σ(Q.Y = R.Y ∧ Q.T>2)(Q × R)

x(Q.Y = R.Y ∧ Q.T>2)(Q × R))

x(P.Y = R.Y ∧ R.V = V2)(P × R)) – ∏x(Q.Y = R.Y ∧ Q.T>2)(Q × R))
A
0
B
1
C
2
D
3
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x