Describe performance tuning and the trade-offs associated with ...

[theo]

Describe performance tuning and the trade-offs associated with it.
 
  What will be an ideal response?

Question 2

Application controls
 
  A) can be classified as input controls, processing controls, and output controls.
  B) govern the design, security, and use of computer programs and the security of data files in general throughout the organization.
  C) apply to all computerized applications and consist of a combination of hardware, software, and manual procedures that create an overall control environment.
  D) include software controls, computer operations controls, and implementation controls.
  E) monitor the use of system software and prevent unauthorized access to software and programs.

[xMRAZ]

Answer to Question 1

The database needs tuning for optimal performance, and the tuning process takes into account the way the end users access the data. For example, fields that end users use to search for records should be indexed for maximum performance. Although the DBA might be tempted to index everything, that would slow the system down when records are added, so a balance is needed. DBAs make trade-offs to add speed to certain activities while slowing down others, yet always stay attentive to the needs of the employees, customers, and other stakeholders. Optimizing performance for speedy retrieval of information, for example, may require slowing down other tasks, such as data entry or editing.

Answer to Question 2

A