FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Database Performance Tuning and Query Optimization

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) batch
B) interactive
C) transaction
D) real-time

E) B) and C)
F) C) and D)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) loop
B) range
C) row ID table access
D) full table

E) None of the above
F) All of the above

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

Good database performance starts with good database design.

List and describe some typical DBMS processes.

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

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

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

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

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

The SQL cache stores the end-user written SQL.

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

Indexes do not facilitate join operations.

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

RAID systems use a single disk to create storage volumes.

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

is evaluated based on client perspective.

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-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.