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

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

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

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

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.

Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.a.Fundamentalb.Relationalc.Structurald.Procedural