A(n)____ is a built-in program or routine that the DBMS uses to monitor and improve database performance.
A)algorithm
B)tuner
C)optimizer
D)trigger

Question

Quizplus · Accepted Answer

An optimizer is a built-in program or routine used by the DBMS to automate the process of selecting the most efficient query execution plan based on available statistics and system resources. The optimizer determines the most efficient way to execute a query by analyzing the database schema and the data distribution, and by generating different execution plans that can be compared based on their estimated cost. The goal of the optimizer is to minimize the response time of the queries while using the least amount of system resources possible. Therefore, choice C is the best answer.

A(n)____ Is a Built-In Program or Routine That the DBMS