Can Two Tasks Be Assigned to the Same Partition

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

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.

(Continued on next question...)

Other Job Interview Questions

• How to feed the result set of one stored procedure into another in Sybase ?
• How can I tell the datetime my Server started?
• Explain the structure of Adaptive server enterprise?
• What is ASA UltraLite in Sybase?
• What is procedure cache and data cache in Sybase?
• When are stored procedures compiled in Sybase ?
• How Do I Take Advantage of Table Partitioning with bcp in Sybase ?
• Which version of Open Client works with which ASE in Sybase?
• What is the difference between an LTM and a RepAgent in Sybase?
• Are there any alternatives to isql in Sybase ?
• More...