Quiz Discussion

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

• 1]

  Union all

• 2]

  Union some

• 3]

  Intersect all

• 4]

  Intersect some

_________ joins are SQL server default

• 1]

  Outer

• 2]

  Inner

• 3]

  Equi

• 4]

  None of the mentioned

For like predicate which of the following is true.

i) % matches zero OF more characters.
ii) _ matches exactly one CHARACTER.

• 1]

  i-only

• 2]

  ii-only

• 3]

  i & ii

• 4]

  None of the mentioned

The intersection operator is used to get the _____ tuples.

• 1]

  Different

• 2]

  Common

• 3]

  All

• 4]

  Repeating

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

• 1]

  Like Predicate

• 2]

  Null Predicate

• 3]

  In Predicate

• 4]

  Out Predicate

The number of attributes in relation is called as its

• 1]

  Cardinality

• 2]

  Degree

• 3]

  Tuples

• 4]

  Entity

The union operation automatically __________ unlike the select clause.

• 1]

  Adds tuples

• 2]

  Eliminates unique tuples

• 3]

  Adds common tuples

• 4]

  Eliminates duplicate

_____ clause is an additional filter that is applied to the result.

• 1]

  Select

• 2]

  Group-by

• 3]

  Having

• 4]

  Order by

The union operation is represented by

• 1]

  ∩

• 2]

  U

• 3]

  -

• 4]

  *