Free Test Query Evaluation Strat... – Databas...

Q1: What is query evaluation in DBMS?

A. Executing the query plan to get results B. Writing SQL queries C. Designing databases D. Backing up data

Q2: Which evaluation strategy processes one tuple at a time?

A. Tuple-at-a-time evaluation B. Block-at-a-time evaluation C. Batch processing D. Full scan

Q3: What is pipelining in query evaluation?

A. Passing intermediate results directly to next operation without temporary storage B. Storing all intermediate results on disk C. Batch processing D. Encrypting results

Q4: Which join method is commonly used in pipelined evaluation?

A. Nested-loop join B. Sort-merge join C. Hash join D. Cartesian join

Q5: What is materialization in query evaluation?

A. Storing intermediate results in temporary relations B. Immediate output generation C. Encrypting queries D. Backing up data

Q6: Which is an advantage of pipelining?

A. Reduced I/O and memory usage B. Requires large temporary storage C. Slower execution D. More disk access

Q7: Which operation is typically implemented using materialization?

A. Aggregation B. Selection C. Projection D. Join

Q8: What is the main disadvantage of materialization?

A. Increased I/O overhead due to disk writes B. Slower network C. More CPU usage D. Data loss

Q9: Which evaluation strategy is better for large datasets that do not fit in memory?

A. Materialization B. Pipelining C. In-memory processing D. Batch processing

Q10: How does tuple-at-a-time evaluation affect latency?

A. Increases latency per tuple B. Decreases latency C. No effect D. Encrypts data

Q11: What is block-at-a-time evaluation?

A. Processing blocks of tuples together B. Processing tuples one by one C. Storing data in batches D. Encrypting batches

Q12: Which is a benefit of block-at-a-time evaluation?

A. Better CPU cache utilization B. Higher latency C. More disk writes D. More memory usage

Q13: Which query operator benefits most from pipelining?

A. Selection B. Sort C. Aggregation D. Materialization

Q14: What is the main role of a query executor?

A. Execute the optimized query plan B. Parse the query C. Store data D. Optimize the query

Q15: Which of the following is a key trade-off in query evaluation?

A. Memory usage vs. I/O overhead B. CPU speed vs. disk size C. Network speed vs. storage D. Encryption vs. compression

Q16: What is an intermediate result in query evaluation?

A. A temporary output generated between query operators B. Final query output C. Encrypted data D. Stored backups

Q17: Which of the following can improve pipelined query execution?

A. Operator fusion B. More disk writes C. Separate execution D. Backup plans

Q18: What is lazy evaluation in query processing?

A. Delaying computation until results are needed B. Eager computation C. Backup storage D. Data encryption

Q19: Which strategy reduces temporary storage needs?

A. Pipelining B. Materialization C. Batch processing D. Full scan

Q20: What does "early selection" mean in query evaluation?

A. Applying filters as soon as possible to reduce data volume B. Delaying filters C. Storing data D. Encrypting data

Quiz for Query Evaluation Strategies