Free Test Query Processing Overview – Databas...

Q1: What is query processing in DBMS?

A. The sequence of steps to execute a query B. Storing data C. Designing tables D. Indexing records

Q2: Which component translates SQL queries into relational algebra?

A. Query compiler B. Query executor C. Storage manager D. Transaction manager

Q3: What is the main goal of query optimization?

A. To find the most efficient query execution plan B. To store data C. To create indexes D. To backup data

Q4: What is a query execution plan?

A. A sequence of operations to execute a query B. A backup file C. A stored procedure D. A data model

Q5: Which algebra operation is commonly used in query processing?

A. Selection B. Encryption C. Compression D. Backup

Q6: What is the role of the query executor?

A. To run the query execution plan B. To write queries C. To design tables D. To handle transactions

Q7: Which step follows query parsing?

A. Query optimization B. Query execution C. Data storage D. Data backup

Q8: What is a heuristic in query optimization?

A. A rule-of-thumb method to simplify optimization B. A complete search C. A storage method D. A backup process

Q9: What does a cost-based optimizer use?

A. Statistics about data and indexes B. Random guesses C. User input D. Backup data

Q10: Which of the following is NOT a part of query processing?

A. Table creation B. Parsing C. Optimization D. Execution

Q11: What is relational algebra?

A. A formal language for manipulating relations B. A programming language C. A database D. An encryption method

Q12: Which operator is used to combine tuples from two relations?

A. Join B. Select C. Project D. Union

Q13: What is query parsing?

A. Checking syntax and generating parse tree B. Running query C. Backing up data D. Designing tables

Q14: Which is an example of a query transformation?

A. Reordering joins B. Backing up data C. Indexing D. Data replication

Q15: What does selectivity mean in query optimization?

A. Fraction of tuples satisfying a condition B. Data size C. Backup frequency D. Storage location

Q16: Which data structure can speed up query processing?

A. Index B. Backup file C. Queue D. Stack

Q17: What is a join algorithm used for?

A. Combining tuples from two relations B. Deleting tables C. Creating views D. Backing up data

Q18: What is the function of the query parser?

A. Generate a parse tree from the SQL query B. Execute the query C. Optimize the query D. Store the data

Q19: Which operation is typically costly in query processing?

A. Join B. Select C. Project D. Rename

Q20: What does a rule-based optimizer use?

A. Fixed set of rules for plan selection B. Cost estimates C. Statistics D. Random choices

Quiz for Query Processing Overview