Database - Operations MCQ

Test your knowledge with important Database - Operations MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Database - Operations MCQs at Bissoy

• The _____________ is essentially used to search for patterns in target string.
  ক

  Like Predicate

  খ

  Null Predicate

  গ

  In Predicate

  ঘ

  Out Predicate
• _________ joins are SQL server default
  ক

  Outer

  খ

  Inner

  গ

  Equi

  ঘ

  None of the mentioned
• _____ clause is an additional filter that is applied to the result.
  ক

  Select

  খ

  Group-by

  গ

  Having

  ঘ

  Order by
• The number of attributes in relation is called as its
  ক

  Cardinality

  খ

  Degree

  গ

  Tuples

  ঘ

  Entity
• If we want to retain all duplicates, we must write ________ in place of union.
  ক

  Union all

  খ

  Union some

  গ

  Intersect all

  ঘ

  Intersect some
• The union operation automatically __________ unlike the select clause.
  ক

  Adds tuples

  খ

  Eliminates unique tuples

  গ

  Adds common tuples

  ঘ

  Eliminates duplicate
• The intersection operator is used to get the _____ tuples.
  ক

  Different

  খ

  Common

  গ

  All

  ঘ

  Repeating
• The union operation is represented by
  ক

  ∩

  খ

  U

  গ

  –

  ঘ

  *