Sybase Certification Exam Question:
Download Questions PDF

Explain 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.

Answer:

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

Download Sybase Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is the purpose of dsync flag?
A. to synchronize primary and mirrored devices
B. to synchronize primary and secondary databases
C. to control whether writes to operating system files are buffered or not
D. to control Backup Servers access to a dump device		Explain Which of the following operations require "quiesce database"?
A. altering the database to a new size
B. performing non-Sybase unmirroring and backup operations.
C. truncating the transaction log
D. dumping the database using Sybase Backup Server.