In distributed query processing, the global query plan is always executed at the central site.Question 10AnswerTrueFalse

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

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

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

Which layer of query processing decomposes the calculus query into an algebraic query on global relations?Query DecompositionData LocalizationGlobal Query OptimizationDistributed Query ExecutionLocal Query Optimization

The activity of choosing an efficient execution strategy for processing a query is called asSelect one:a. Query plan evaluationb. Query executionc. Query parsingd. Query optimization