Query Processing MCQ

Test your knowledge with important Query Processing MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Query Processing 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
• Ensuring isolation property is the responsibility of the
  ক

  Recovery-management component of the DBMS

  খ

  Concurrency-control component of the DBMS

  গ

  Transaction-management component of the DBMS

  ঘ

  Buffer management component in DBMS
• A table can be logically connected to another table by defining a
  ক

  Super key

  খ

  Candidate key

  গ

  Primary key

  ঘ

  Unique key
• Which of the following terms does refer to the correctness and completeness of the data in a database?
  ক

  Data security

  খ

  Data constraint

  গ

  Data independence

  ঘ

  Data integrity
• Which of the following is an attribute that can uniquely identify a row in a table?
  ক

  Secondary key

  খ

  Candidate key

  গ

  Foreign key

  ঘ

  Alternate key
• Which of the following schemas does define a view or views of the database for particular users?
  ক

  Internal schema

  খ

  Conceptual schema

  গ

  Physical schema

  ঘ

  External schema