Sybase Certification Exam Question: Download Sybase Certification PDF

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.

B. No transaction locks are held on index pages.
D. Server uses table locks and row locks, but not page locks.

Previous Question	Next Question
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	Do you know The reorg command may be used to: (Choose 2) A. Compact a table that uses datarows locking. B. Reclaim unused space in a table that uses allpages locking. C. Reclaim unused space in an index that uses datapages locking. D. Rebuild a table that uses allpages locking.