Set Operations Notes Questions with Answers PDF Download – Test 23

MCQ 111: The SQL set operations include:

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

MCQ 112: The predicated that succeeds if the value on which it is applied is not null, is known to be:

1. Is Not Null
2. Is Null
3. Not Null
4. Null

MCQ 113: The error that causes loss of the data of volatile storage, and halts the transaction processing is known as:

1. System error
2. Application error
3. System crash
4. Transaction error

MCQ 114: Mapping of conceptual schema using the entity-relationship model into a relation schema, is achieved at the stage:

1. Physical-design phase
2. Contextual-design phase
3. Virtual-design phase
4. Logical-design phase

MCQ 115: Durability can be ensured in different:

1. 2 ways
2. 3 ways
3. 4 ways
4. 5 ways