Question: Consider that you have a relation R with five attributes R(a,b,c,d,e) containing 5,000 records, where each data page of the relation holds 10 records. R
Consider that you have a relation R with five attributes R(a,b,c,d,e) containing 5,000 records, where each data page of the relation holds 10 records. R is organized as a sorted file with secondary indexes. Assume that R.a is a candidate key for R, with values lying in the range 0 to 4999, and that R is stored in R.a order. For each of the following relational queries, 1. SELECT * FROM R WHERE R.a50 2, SELECT * FROM R WHERE R.a = 50. 3. SELECT *FROM R WHERE R.a >50 and R.a
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
