Quiz Discussion

The union operation automatically __________ unlike the select clause.

• 1]

  Adds tuples

• 2]

  Eliminates unique tuples

• 3]

  Adds common tuples

• 4]

  Eliminates duplicate

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

(SELECT course id
FROM SECTION
WHERE semester = ’Fall’ AND YEAR= 2009)
EXCEPT
(SELECT course id
FROM SECTION
WHERE semester = ’Spring’ AND YEAR= 2010);

This query display

• 1]

  Only tuples from second part

• 2]

  Only tuples from the first part which has the tuples from second part

• 3]

  Tuples from both the parts

• 4]

  Tuples from first part which do not have second part

The union operation is represented by

• 1]

  ∩

• 2]

  U

• 3]

  -

• 4]

  *

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

• 1]

  Like Predicate

• 2]

  Null Predicate

• 3]

  In Predicate

• 4]

  Out Predicate

_________ 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

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

• 1]

  Select

• 2]

  Group-by

• 3]

  Having

• 4]

  Order by