Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Certifications Interviews:AFMCAIIMS ExamCCDA CertificationCCIE CertificationCCIP CertificationCCSP CertificationCertificationsCheck Point CertificationCISCO CertificationCIW CertificationEngineering Entrance ExamsEntrance ExamsGATE ExamIBM CertificationICET ExamIIT JEEISTQB CertificationManagement Entrance ExamsMATMCDBA CertificationMCSD.NET - 70-089MCSD.NET - 70-300MCSD.NET - 70-306 ExamMCSD.NET - 70-310 ExamMCSD.NET - 70-315 ExamMCSD.NET - 70-316 ExamMCSD.NET - 70-320 ExamMCSD.NET - 70-330 ExamMCSD.NET - 70-340 ExamMCTS .Net CertificationMedical Science Entrance ExamsMicrosoft CertificationMSCE 2003 CertificationNovell CertificationNovell CLE 9 CertificationNovell CLP CertificationNovell CNA CertificationNovell CNE CertificationNovell MCNE CertificationOCP 9i DBA CertificationOPENMAT ExamOracle Application DeveloperOracle CertificationPMI CertificationPost Graduation Entrance ExamsRed Hat CertificationS/W Quality AssuranceSun CertificationSybase CertificationTesting Certification
Copyright © 2018. All Rights Reserved
Sybase Certification Interview Question:
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: AdministratorB. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)
Submitted by: Administrator
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.