Sybase Certification Exam Question: Download Sybase Certification PDF

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.

A. Compact a table that uses datarows locking.
C. Reclaim unused space in an index that uses datapages locking.

Previous Question	Next Question
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.	Parallel sorting can be used for: (Choose 3) A. Sort Merge joins B. slow bcp C. Reformatting D. Creating indexes E. reorg compact