Sybase Question:
Download Questions PDF

Can Two Tasks Be Assigned to the Same Partition in Sybase?

Answer:

Yes. ASE randomly assigns partitions. This means there is always a chance that two users will vie for the same partition when attempting to insert and one would lock the other out.

The more partitions a table has, the lower the probability of users trying to write to the same partition at the same time.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
Must I Use Multiple Devices to Take Advantage of Partitions in Sybase?How Does Partition Assignment Relate to Transactions in Sybase?