Exam 11: Database Performance Tuning and Query Optimization

A cost-based optimizer uses a set of preset rules and points to determine the best approach to execute a query.

To work with the data,the DBMS must retrieve the data from the ____ and place it in the ____.

Good database performance starts with good database design.

Most current-generation relational DBMSs perform automatic query optimization at the client end.

When setting optimizer hints,____ instructs the optimizer to minimize the time it takes to process the first set of rows,that is,to minimize the time it takes to return only the first set of rows in the query result set.This hint is generally used for interactive mode processes.

A system table space,a user data table space,an index table space,and a temporary table space are examples of ____.

One of the main functions of a database system is to provide timely answers to end users.

All transaction management commands are processed during the parsing and execution phases of query processing.

____ is/are the central activity during the parsing phase in query processing.

A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.