SQL Data Definition Multiple Choice Questions (MCQ) PDF - 204

MCQ 1016: A null value indicates an absent value that

1. may exist but unknown
2. known but doesn't exist
3. doesn't exist and not known
4. Both A and B

MCQ 1017: The operations with the ability to express queries that cannot be expressed by the basic relational-algebra operations, is known as

1. Compound relational-algebra
2. Composite relational-algebra
3. Embedded relational-algebra
4. Extended relational-algebra

MCQ 1018: The ResultSetMetaData object contains metadata about the

1. data set
2. input set
3. result set
4. meta data

MCQ 1019: A database can be regarded as a kind of

1. Electronic file handling
2. Electronic filing management
3. Electronic filing storage
4. Electronic filing cabinet

MCQ 1020: In the case of power outage or other system crash, the rollback occurs when the

1. System starts
2. System boosts
3. System restarts
4. System shuts down