Question

Which of the following methods is used to reduce overhead?

(a) Connection pooling

(b) Parallel Processing

(c) Caching Query Results at the server

(d) All of the mentioned

The question was asked during a job interview.

My question comes from Application Architectures in section Application Design and Development of RDBMS

Answer 1

Right choice is (d) All of the mentioned

For explanation: To reduce overhead, any of the following methods can be used. Connection pooling, Parallel processing or caching query results at the server. Caching query results at the server enables to reduce the number of database accesses every time a similar request is sent.