Answers

Question and Answer:

  Home  Sybase Certification

⟩ Suppose The titles table has 50,000 rows and a nonclustered index on the pricecolumn. Which of the following queries use less logical I/Os?A. select "Min" = min(price), "Max" = max(price) from titlesB. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)C. They will both use the same number of I/Os

B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)

 204 views

More Questions for you: