Consider a relational table $r$ with sufficient number of records, having attributes $A_1, A_2, \dots, A_n$ and let $1 \le p \le n$. Two queries Q1 and Q2 are given below. Q1: $\pi_{A_1, \dots, A_p}(\sigma_{A_p = c}(r))$ where $c$ is a constant Q2: $\pi_{A_1, \dots, A_p}(\sigma_{c_1 \le A_p \le c_2}(r))$ where $c_1$ and $c_2$ are constants The database can be configured to do ordered indexing on $A_p$ or hashing on $A_p$. Which of the following statements is TRUE?

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: A1, , Ap( Ap = c(r)) where c is a constant Q2: A1, , Ap( c1 Ap c2(r)) where c1 and c2 are constants The database can be configured to do ordered indexing on Ap or hashing on Ap. Which of the following statements is TRUE?

Topic-wise GATE CS PYQs with verified steps