In distributed query processing, what is the main challenge addressed by query optimization?Question 7Select one:A.Ensuring data encryptionB.Increasing query complexityC.Minimizing data redundancyD.Reducing query response timeE.Maximizing data replication

What is the primary function of the global query optimizer in distributed query processing?Question 11Select one:A.To distribute queries to the appropriate local sitesB.To encrypt the query dataC.To compress the query resultsD.To maintain data consistencyE.To manage data replication

Which technique is used to improve the performance of distributed query processing?Question 6Select one:A.Query fragmentationB.Data shardingC.Data IndexingD.Data encryptionE. Data normalization

Match the following concepts with their descriptions:Regulate the application behavior.Answer 1 Question 22Express basic semantic properties inherent to a model.Answer 2 Question 22Break down a calculus query into an algebraic query on global relationsAnswer 3 Question 22Transforms the distributed query into a query on fragments.Answer 4 Question 22Finding the best execution strategy for the queryAnswer 5 Question 22

The MapReduce programming model is designed for:Question 3Select one:A.Real-time data processingB.Simplifying relational database operationsC.Distributed computation over large datasetsD.Enhancing SQL query performanceE.Handling large datasets on a single machine

What are some advanced query optimization techniques not mentioned earlierReview LaterUsing stored procedures instead of ad-hoc queries.Utilizing query hints to force specific execution plans.Employing database partitioning for large tables.Implementing data caching mechanisms.