Sybase Certification Exam Question:
Download Questions PDF

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

Sybase Certification Interview Question
Sybase Certification Interview Question

Answer:

C. create and drop a clustered index

Download Sybase Certification Interview Questions And Answers PDF

Previous QuestionNext 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		Do you know Transaction Isolation Level 2 is directly supported in the following lock
scheme(s):
A. Allpages
B. Allpages, Datapages
C. Allpages, Datapages, Datarows
D. Datapages, Datarows