Chapter 11 Flashcards
End users and the DBMS interact through the use of _______ to generate information.
Queries
A system will perform best when its hardware and software resources are ________.
Optimized
Database ___________ activities can be divided into those taking place either on the client side or on the server side.
Performance Tuning
__________ is another name for table space
File Group
An _________ request is a low-level read or write data access operation to or from computer devices.
Input/Output
DBMS query processing has ______ phases
Three
What are the three phases of DBMS query processing?
Parsing, execution, and fetching
The _________ analyzes the SQL query and finds the most efficient way to access the data.
Query Optimizer
Once an SQL statement is transformed, the DBMS creates what is commonly known as an ___________ plan.
Access Execution
________ are ordered sets of values that are crucial in speeding up data access
Indexes
A __________ is good for simple and fast lookup operations based on equality conditions
Hash Index
__________ is a measure of the likelihood that an index will be used in query processing
Index Selectivity
_________ is evaluated based on client perspective
SQL Performance Tuning
A conditional expression is normally expressed within the ______ or HAVING classes of an SQL statement.
WHERE
_______ helps provide a balance between performance and fault tolerance
RAID
The _______ table space is the most frequently accessed table space and should be stored in its own volume.
System
The ________ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.
Sort
The _______ segment table space is used for transaction-recovery purposes
Rollback
An _________ table stores the end-user data and the index data in consecutive locations on permanent storage
Index-Organized
In a level ______ RAID, the data and the parity data is striped across separate drives.
Five
