Exam 11: Database Performance Tuning and Query Optimization

List and describe some typical DBMS processes.

In-memory database systems are optimized to store small portions of the database in disk storage alone.

The primary factor in determining the most efficient access plan is the I/O cost.

How can queries be written to perform the fastest when equality and inequality comparisons are needed?

RAID systems use a single disk to create storage volumes.

To generate database object statistics manually, following syntax should be used in Oracle: .

The SQL cache stores the end-user written SQL.

Bitmap indexes tend to use less space than a because they use bits instead of bytes to store their data.

is evaluated based on client perspective.

If there is no index, the DBMS will perform a scan.

Why do we need to optimize a DBMS with SQL performance tuning, even though they automatically optimize SQL queries?

In standard SQL, the optimizer hint FIRST_ROWS is generally used for mode processes.

Indexes do not facilitate join operations.

All factors must be checked to ensure that each system component operates at its optimum level and has sufficient resources to minimize the occurrence of bottlenecks.

In the context of RAID levels, refers to writing the same data blocks to separate drives.

A(n) request is a low-level read or write data access operation to or from computer devices.

A data file can contain rows from a single table alone.

Indexes are very useful in small tables or tables with low sparsity.

Good database performance starts with good database design.

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