Question
What is procedure cache and data cache in sybase?

Answers

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.   Your Comment




More Software Questions..
What is the inputsplit in map reduce software?

What is software configuration management?

What Is Java Api For Xml-based Rpc (jax-rpc)?

How can you implement fine-grained auditing?

What is IBM’s simple explanation for Big Data’s four critical features?

What is static synchronized method in JDBC API? Give an example?

What does the NULLIF function do?

What happens if a start method is not invoked and the run method is directly invoked?

Should we override finalize method

what is the difference between mysql_fetch_array and mysql_fetch_object?

How will XML affect my document links?

Why to use Style Sheets?

What are Filters in MVC?

Can you explain Application layer in OSI model?

How to define new testplan attributes?

What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?

Which oracle package is used to manage the oracle lock management services?

What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?

What is marker interface?

What types of partitioning are there for BW?



Search
Can you Answer!!
  • Q What is ‘dual control’ in master records?
  • Q One Question Has Last Part Like Difference Between Two Terms Is 9 And Product Of Two Numbers Is 10, What Is The Squares Of Sum Of Numbers?
  • Q How do I change the background color of a BUTTON???
  • Q In a class test containing 10 questions , 5 marks are awarded for every correct answer and (-2) marks for every incorrect answer and 0 for questions not attemted. Mohan gets 4 correct and 6 incorrect answers. What is his score ?
  • Q What is BSS(Block Started by Symbol)?
  • Q What is normalisation?
  • Q What is a primary key?
  • Q Which is greater 3/5 or 5/8
  • Q Give an example for a statistical condition?
  • Q What is occipital lobe
  • Q What are the productions?