Database Performance Tuning and Query Control

Question 1

refers to a set of activities and procedures designed to reduce the response time of the database system

Answer 1

Database performance tuning

Question 2

The objective is to generate a SQL query that returns the correct answer in the least amount of time, using the minimum amount of resources at the server end. The activities required to achieve that goal are commonly referred to as

Answer 2

SQL performance tuning

Question 3

the DBMS environment must be properly configured to respond to clients’ requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as

Answer 3

DBMS performance tuning

Question 4

It is the component of a database management system that attempts to select the
most efficient way to execute a query

Answer 4

Query Optimizer