DBMS Basics Practice Test: Query Processing Techniques — Flashcards

Quiz questions on query processing and optimization techniques, selection, sort and join operations, relational expressions and materialized views.

A DBMS processes queries in three phases:
Parsing: Checks syntax
Optimization: Finds efficient plan
Execution: Retrieves and manipulates data 

Here are some query processing techniques in a DBMS:
Optimization: The DBMS chooses the most efficient plan to retrieve data from the database. This reduces system overhead and improves performance.
Query evaluation: The query processer and optimizer translates a user query into an efficient program that can be executed against the database. The system then evaluates the generated low-level query and delivers the output.
Data modeling: The DBMS creates a conceptual representation of the data in the database. This data model includes all the entities and their relationships. It helps to understand the data in the database and to design the database.