Sybase Certification Exam Question:

Explain Which of the following create table can prevent or minimize row
forwarding in DOL tables?
A. fillfactor
B. max_rows_per_page
C. exp_row_size
D. reservepagegap

C. exp_row_size

Previous Question	Next Question
Explain Which of the following cache or IO tuning methods can reduce the spinlock contention on a single "hot" table that is already bound to a named cache? A. Create 16K buffer pool in the named cache B. Change the cache replacement strategy of the named cache to relaxed LRU C. Partition the named cache D. Increase the named cache size	How to reclaim space from a fragmented allpages heap table? A. run reorg command B. dump and load the database C. create and drop a clustered index D. truncate the least used pages