1. You are in an environment requiring the support of a high volume of concurrent online users with minimal downtime and satisfactory completion of transactions. What type of server will help you in accomplishing these requirements reliably and with high performance? Describe why.

2. How does Mullins define database performance in our textbook? List the five factors that influence performance and briefly define two of the factors.

3. The reading efficiency is the percentage of times a data page is found in the data cache memory (or buffer pool) without requiring a physical I/O. To avoid physical disk I/O operations, the proper cache size must be calculated and set. How do you calculate the appropriate size and what are the downsides for both too small and too large cache space?

4. What are the potential benefits of using SQL in stored procedures? Describe two benefits.

Answer rating: 100% (QA)

Question1 answer ORACLE provides the reliability scalability and high performance required to handle a large number of concurrent online users ORACLE is a database management system that is widely use... View the full answer