Author Question: Describe performance tuning and the trade-offs associated with it. What will be an ideal ... (Read 41 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?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

For a complete list of videos, visit our video library