C. to control whether writes to operating system files are buffered or not
A. Compact a table that uses datarows locking.
C. Reclaim unused space in an index that uses datapages locking.
B. performing non-Sybase unmirroring and backup operations.
A. 50 User tables and 14 work tables
C. create and drop a clustered index
D. Datapages, Datarows
B. time slice
A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key
B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)
B. serial index scan
B. 1958 bytes of data.
B. It may decrease the contention.
E. It may help to decrease row movement of frequently updated varchar columns.
B. It allows insert, update, and delete commands to read past any incompatible lock.
D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
C. to control whether writes to operating system files are buffered or not
B. performing non-Sybase unmirroring and backup operations.
D. restart Adaptive Server