Set Operations Multiple Choice Questions (MCQ) PDF Download

MCQ 1: If any of the input values is null, the result of an arithmetic expression, would be

1. 0
2. Null
3. 1
4. Undefined

MCQ 2: SQL uses the special keyword in a predicate to test for a null value

1. Escape
2. Unknown
3. Known
4. Null

MCQ 3: The union operation automatically eliminates duplicates, unlike the

1. Select clause
2. From clause
3. Define clause
4. Where clause

MCQ 4: Duplicate tuples must be eliminated, when the query uses the clause

1. Select Clause
2. Where Distinct Clause
3. Select distinct Clause
4. From Distinct Clause

MCQ 5: The SQL set operations include

1. Union
2. Intersect
3. Except
4. All of the Above