Selection Operation & Sorting MCQ

Test your knowledge with important Selection Operation & Sorting MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Selection Operation & Sorting MCQs at Bissoy

• Which of the following can be implemented?
  ক

  Conjunctive selection using one index

  খ

  Conjunctive selection using composite index

  গ

  Conjunctive selection by intersection of identifiers

  ঘ

  All of the mentioned
• A selection of the form giving all the records not satisfying simple individual conditions is ______
  ক

  Conjunctive selection

  খ

  Disjunctive selection

  গ

  Negation

  ঘ

  None of the mentioned
• A selection of the form satisfying the union of all records satisfying individual simple conditions is
  ক

  Conjunctive selection

  খ

  Disjunctive selection

  গ

  Negation

  ঘ

  None of the mentioned
• A selection of the form satisfying the intersection of all records satisfying individual simple conditions is
  ক

  Conjunctive selection

  খ

  Disjunctive selection

  গ

  Negation

  ঘ

  None of the mentioned
• Sorting of relations that do not fit in memory is called as _______
  ক

  Internal sorting

  খ

  External sorting

  গ

  Overflow sorting

  ঘ

  Overload sorting
• Search algorithms that use an index are referred to as _________
  ক

  Index scans

  খ

  Search scans

  গ

  Primary scans

  ঘ

  Equality scans
• The lowest level operator to access data in query processing is _______
  ক

  File scan

  খ

  File manipulation

  গ

  File handling

  ঘ

  File organization
• A sequence of primitive operations that can be used to evaluate a query are called as __________
  ক

  Query evaluation algebra

  খ

  Query evaluation plan

  গ

  Query evaluation primitive

  ঘ

  Query evaluation engine
• A relational algebra operation annotated with instructions on how to evaluate it is called _______
  ক

  Evaluation algebra

  খ

  Evaluation plan

  গ

  Evaluation primitive

  ঘ

  Evaluation engine
• Which of the following are steps in query processing?
  ক

  Parsing and translation

  খ

  Optimization

  গ

  Evaluation

  ঘ

  All of the mentioned