Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 780 |
the relational algebra expression equivalent to the tuple calculus expression {t|t ∈ r ⋀ (t[A]=10 ⋀ t[B]=20)} is
| σ (A=10 v B=20) (r) | |
| σ (A=10) (r) Uσ ( B=20) (r) | |
| σ (A=10) (r) ∩ σ ( B=20) (r) | |
| σ (A=10) (r) – σ ( B=20) (r) |
Question 780 Explanation:
The given relational algebra having the two tuples such as t.a=10 and t⋅B = 20
→ (Tuple having A=10) ∩ (Tuple having B=20) is equal to (Tuples having A=10 and B=20)
→ (Tuple having A=10) ∩ (Tuple having B=20) is equal to (Tuples having A=10 and B=20)
Correct Answer: C
Question 780 Explanation:
The given relational algebra having the two tuples such as t.a=10 and t⋅B = 20
→ (Tuple having A=10) ∩ (Tuple having B=20) is equal to (Tuples having A=10 and B=20)
→ (Tuple having A=10) ∩ (Tuple having B=20) is equal to (Tuples having A=10 and B=20)