Computer Sciences > GATE 2014 SET-3 > Relational Algebra
What is the optimized version of the relation algebra expression πA₁ (πA₂ (σF₁ (σF₂ (r)))), where A₁, A₂ are sets of attributes in r with A₁ ⊆ A₂ and F₁, F₂ are Boolean expressions based on the attributes in r?
A
πA₁ (σ(F₁∧F₂) (r))
B
πA₁ (σ(F₁∨F₂) (r))
C
πA₂ (σ(F₁∧F₂) (r))
D
πA₂ (σ(F₁∨F₂) (r))

Correct : a

Similar Questions

Consider the relational schema given below, where empId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that ever...
#1304 MCQ
Consider the relational schema given below, where empId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that ever...
#1304 MCQ
Consider the relational schema given below, where empId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that ever...
#1304 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......