DBMS Failure Classification Multiple Choice Questions (MCQ) PDF - 148

MCQ 736: The types of errors that can result in failure in a transaction are of

1. 2 types
2. 3 types
3. 4 types
4. 5 types

MCQ 737: The DMLs type that requires a user to specify what data is needed, is known as

1. Declarative DML
2. Subjective DML
3. Procedural DML
4. Definitive DML

MCQ 738: A sequence of primitive operations that can be used to evaluate a query is a

1. Query-execution plan
2. Query-evaluation plan
3. Both A and B
4. Query-execution engine

MCQ 739: The short form for all the allowable privileges, is said to be

1. All privileges
2. All grant
3. All access
4. All authorize

MCQ 740: Virtual Private Database (VPD) is said to be an authorization mechanism of level

1. Tuple-level
2. Row-level
3. Schema-level
4. Domain-level