Database Transactions Multiple Choice Questions (MCQ) PDF - 280

MCQ 1396: The process that undoes all the updates performed by the SQL statements in the transaction, is known to be

1. Transmit work
2. Commit work
3. Rollback work
4. Trace work

MCQ 1397: Mapping cardinalities are also known as

1. Mapping ratios
2. Cardinality ratios
3. Ratio expression
4. Mapping expression

MCQ 1398: If the design makes the computation hard to enforce functional dependency, the design is said to be

1. Preserving consistency
2. Dependency preserving
3. Not dependency preserving
4. Not preserving consistency

MCQ 1399: Within query execution process, several database systems today support external language routines running in a

1. Tambox
2. Sandbox
3. Ranbox
4. Fandbox

MCQ 1400: The flow of tasks between various components of a system, is depicted by the diagram

1. Activity diagram
2. Implementation diagram
3. Class diagram
4. Use case diagram