What is procedure cache and data cache in Sybase

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

(Continued from previous question...)

What is procedure cache and data cache in Sybase?

Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for building result sets.

(Continued on next question...)

Other Job Interview Questions

• How can I return number of rows that are returned from a grouped query without using a temporary table?
• How to remove row affected and dashes
• How do I force an index to be used in Sybase ?
• What is procedure cache and data cache in Sybase?
• Can I use a named pipe to bcp/dump data out or in in Sybase?
• What are the vital features of Sybase?
• How can I return number of rows that are returned from a grouped query without using a temporary table?
• Optimistic versus Pessimistic locking in Sybase?
• What is my identity burn factor vulnerability right now in Sybase?
• How to view the log files in sybase
• More...