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

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

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

In Query optimization, Estimation of plan cost is based on:Select one:a.Statistics estimation for intermediate results to compute cost of complex expressionsb.All of the abovec.Cost formulae for algorithms, computed using statisticsd.Statistical information about relations

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.

You are comparing two query execution plans.Query plan A has an estimated query cost of 1000Query plan B has an estimated query cost of 500What can we conclude from this?A.Query B will take 50% less time to execute than query AB.Query B is more efficient but that has no impact on query execution timeC.Query A is less efficient and most likely slower than a query B.