Exam 11: Database Performance Tuning and Query Optimization

The majority of primary memory resources will be allocated to the cache.

End users and the DBMS interact through the use of to generate information.

DBMS implementations are typically similar in complexity to two-tier client/server configurations.

List and describe some typical DBMS processes.

The table space is used to store the data dictionary tables.

On the server side,the database 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 this goal are commonly referred to as tuning.

Knowing the sparsity of a column helps you decide whether the use of is appropriate.

is the central activity during the parsing phase in query processing.

Summarize the steps required to formulate a query.

The data cache is where the data read from the database data files are stored the data have been read or the data are written to the database data files.

DBMS query processing has phases.

refers to the number of different values a column could possibly have.

The data cache caches system catalog data and the contents of the indexes.

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

An index scan is less efficient than a full table scan.

helps provide a balance between performance and fault tolerance.

In the context of RAID levels,striped arrays provide:

Indexes do not facilitate join operations.

The data cache or is a shared,reserved memory area that stores the most recently accessed data blocks in RAM.

Character field comparisons are faster than numeric,date,and NULL comparisons.