GATE Computer Science (CS) 2011 Solved Paper

© examsiri.com
Question : 49 of 65
 
Marks: +1, -0
Consider a relational table r with sufficient number of records, having attributes A1, A2,..., An and let 1 ≤ p ≤ n. Two queries Q1 and Q2 are given below.
Q1:Ï€Ai...Ap(σAp=c(r)) where c is a constant
Q2:Ï€Ai...Ap(σc1≤Ap≤c2(r)) where c1 and c2 are constant
The database can be configured to do ordered indexing on Ap or hashing on Ap. Which of the following statements is TRUE?
Go to Question: