Set Operations Quiz PDF: Questions and Answers - 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