How to clear tempdb when the tempdb gets filled

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

(Continued from previous question...)

How to clear tempdb when the tempdb gets filled in Sybase?

Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]})

(Continued on next question...)

Other Job Interview Questions

• We have lost the sa password, what can we do?
• Where should I install replication server in Sybase
• Using large raw partitions with Replication Server on Unix in Sybase
• Buildmaster Configuration Definitions in Sybase
• Explain about the Sybase group?
• What is cmaxpktsz good for in Sybase?
• How do I move tempdb off of the Master Device?
• Does Table Partitioning Require User-Defined Segments in Sybase?
• Server naming and renaming
• Why do my page locks not get escalated to a table lock after 200 locks?
• More...