Sybase Certification Exam Question:
Download Questions PDF

Explain When does the optimizer consider a hash based table scan on an APL table?
A. if it is a heap table
B. if it is has a clustered index
C. If it is a table with a clustered index and a non clustered index
D. If it is a partitioned table with a clustered index

Answer:

A. if it is a heap table

Download Sybase Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Which of the following steps is NOT always necessary for performing a
tuning benchmark?
A. record a baseline measurement
B. change one variable, holding all others constant
C. make a new measurement
D. restart Adaptive Server
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.