Sybase Certification Exam Question:
Download Questions PDF

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

Answer:

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

Download Sybase Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What are some ways to reduce last data page lock contention for inserts?
(Choose 3)
A. alter the table to use the Datarows locking scheme
B. alter the table to use the Datapages locking scheme
C. partition the table
D. create a clustered index on a random key
E. increase the server configuration for the number of locks
F. increase the server configuration for the deadlock checking period		Suppose All of the following tactics may reduce contention for cache spinlocks in an
ASE configured to support multiple online engines, except
A. Increasing the spinlock ratio
B. Creating additional named caches and binding frequently used tables to them
C. Creating partitions in heavily used caches
D. Returning to a single engine configuration