Choice of Evaluation Plans MCQ

Test your knowledge with important Choice of Evaluation Plans MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Choice of Evaluation Plans MCQs on Bissoy. Bissoy App

• The process of replacing a nested query with a query with a join is known as _________
  ক

  Correlation

  খ

  Decorrelation

  গ

  Cache handling

  ঘ

  Join replacement
• What technique is used for the evaluation of a query with a nested sub query?
  ক

  Caching

  খ

  Decorrelated evaluation

  গ

  Correlated evaluation

  ঘ

  Time based evaluation
• Caching and reuse of query plans is called as ________
  ক

  Query caching

  খ

  Plan caching

  গ

  Plan memorizing

  ঘ

  None of the mentioned
• The join orders where the right operand of each join is in one of the initial relations are called as ________
  ক

  Right deep join orders

  খ

  Left deep join orders

  গ

  Outer join orders

  ঘ

  None of the mentioned
• Optimizers use __________ to reduce the cost of optimization.
  ক

  Analyzers

  খ

  Statistics

  গ

  Heuristics

  ঘ

  Caches
• State true or false: Making multiple copies of the same sub-expressions must be avoided
  ক

  True

  খ

  False
• The rule that allows transformation of a logical operation to a physical operation is called
  ক

  Logical equivalence rule

  খ

  Physical equivalence rule

  গ

  Memory equivalence rule

  ঘ

  None of the mentioned
• A particular sort order is said to be _________ sort order if it could be useful for a later operation.
  ক

  Interesting

  খ

  Reusable

  গ

  Efficient

  ঘ

  Good
• What is the disadvantage of cost based optimizers?
  ক

  It is too expensive

  খ

  It is inefficient in producing results

  গ

  It does not perform the desired function

  ঘ

  None of the mentioned
• A ________ explores the space of all query evaluation plans that are equivalent to a given query.
  ক

  Cost based optimizer

  খ

  Space based optimizer

  গ

  Time based optimizer

  ঘ

  None of the mentioned