Given the relation X below what value will be extracted by the following query? TEMP $\leftarrow$ SELECT from X where B C
RESULT $\leftarrow$PROJECT A from TEMP
A) 2
B) 3
C) 4
D) 5

Question

Given the relation X below  what value will be extracted by the following query? TEMP $\leftarrow$ SELECT from X where B > C
RESULT $\leftarrow$PROJECT A from TEMP
A) 2 
B) 3 
C) 4 
D) 5

Quizplus · Accepted Answer

The query first filters records where B > C, but since there are no attributes labeled B or C in the relation, no records will be selected.
Therefore, TEMP will be an empty relation, and the PROJECT operation will return an empty relation as well.
Since there are no values to extract, the answer is 0, which corresponds to option C.

Given the Relation X Below What Value Will Be ←\leftarrow←

Given the Relation X Below What Value Will Be $\leftarrow$