Sybase Certification Exam Question: Download Questions PDF
Explain What are some ways to reduce last data page lock contention for inserts?
(Choose 3)
A. alter the table to use the Datarows locking scheme
B. alter the table to use the Datapages locking scheme
C. partition the table
D. create a clustered index on a random key
E. increase the server configuration for the number of locks
F. increase the server configuration for the deadlock checking period
Answer:
A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key
C. partition the table
D. create a clustered index on a random key
Download Sybase Certification Interview Questions And Answers
PDF