Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 332
|
The materialization approach of query evaluation includes (from root to leaf) :
|
π, ∞, σ
|
|
|
π, σ, ∞
|
|
|
σ, π, ∞
|
|
|
σ, ∞, π
|
Question 332 Explanation:
In SQL we write
SELECT
FROM
WHERE
in a sequence.
So it is equivalent to
SELECT-π
FROM- ∞
WHERE-σ
SELECT
FROM
WHERE
in a sequence.
So it is equivalent to
SELECT-π
FROM- ∞
WHERE-σ
Correct Answer: A
Question 332 Explanation:
In SQL we write
SELECT
FROM
WHERE
in a sequence.
So it is equivalent to
SELECT-π
FROM- ∞
WHERE-σ
SELECT
FROM
WHERE
in a sequence.
So it is equivalent to
SELECT-π
FROM- ∞
WHERE-σ