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" />

Interview Questions Answers.ORG

Interviewer And Interviewee Guide

Sybase Certification Interview Question:

Next ❯❮ Previous

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

Submitted by: Administrator

B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)
Submitted by: Administrator

Next ❯❮ Previous

Read Online Sybase Certification Job Interview Questions And Answers

Top Sybase Certification Questions

☺	If sp_sysmon output consistently shows a high number of Voluntary Yields, which configuration parameter could be modified to improve performance? A. user log cache size B. time slice C. identity grab size D. stack size E. cpu accounting flush interval

☺	Explain Which of the following are true of the Datarows Locking Scheme? (Choose 2) A. Index pages are locked. B. No transaction locks are held on index pages. C. Server uses page locks and row locks, but not table locks. D. Server uses table locks and row locks, but not page locks.

☺	Explain When you run optdiag command on a allpages-locked table with 1000 pages, what will be value of "Forwarded row count"? A. 1000 B. 500 C. 0 D. 1

☺

Explain Which of the following statements describes readpast locking? (Choose 2)
A. It can be specified at the session, transaction, and table level.
B. It allows insert, update, and delete commands to read past any incompatible lock.
C. It allows readers to not block writers.
D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.

☺	Where are table/index level statistics stored? A. sysstatistics B. systabstats C. On the leaf level of the index D. The GAM page E. The distribution page

Top Certifications Categories

☺	CCIE Certification Interview Questions.

☺	CCSP Certification Interview Questions.

☺	AFMC Interview Questions.

☺	Sun Certification Interview Questions.

☺	GATE Exam Interview Questions.

SHARE

Disclaimer

Interview Questions Answers .ORG is responsive and optimized web portal for individuals to get preparation for their job interviews, learning and training. Content at Interview Questions Answers .ORG might be simplified to improve our users experience. We constantly review our content to avoid errors and copyright violations, but we cannot warrant full correctness of all the content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2007-2025 by Interview Questions Answers .ORG All Rights Reserved.