Author Question: Describe performance tuning and the trade-offs associated with it. What will be an ideal ... (Read 43 times)

theo

  • Hero Member
  • *****
  • Posts: 698
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

  • Sr. Member
  • ****
  • Posts: 363
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Anti-aging claims should not ever be believed. There is no supplement, medication, or any other substance that has been proven to slow or stop the aging process.

For a complete list of videos, visit our video library