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.

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

A query execution plan provides crucial assistance for query optimization by showing the following elements:Select THREE.A. Join typeB. Alternative (more suitable) join conditionC. Estimated query costD. NO STATISTICS indicator

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

Heuristic optimization transforms the query-tree by using a set of rules that typically (but not in all cases) improve execution performance .It uses which rules to do soSelect one:a.Perform selection early (reduces the number of tuples)b.Perform most restrictive selection and join operations (i.e., with smallest result size) before other similar operations.c. All of the aboved.Perform projection early (reduces the number of attributes)

cost-based query optimization consist ofSelect one:a.Annotate resultant expressions to get alternative query plansb.Generating logically equivalent expressions using equivalence rulesc.Choose the cheapest plan based on estimated costd.All of the above