DBMS Worksheet MCQ with Answers PDF Download – Test 40

MCQ 196: The database security is responsible for providing:

1. Authentication
2. Encryption
3. Access control
4. All of the Above

MCQ 197: Execution of multiple statements in a single call is being:

1. Accepted
2. Supported
3. Prioritized
4. Eliminated

MCQ 198: If there is a chain of foreign-key dependencies across multiple relations, a deletion or update at one end of the chain may propagate:

1. No dependent
2. Entire chain
3. 1 dependent only
4. Few dependents only

MCQ 199: In the relational algebra, the select, project, and rename operations are known as:

1. Dimensional operations
2. Multidimensional operations
3. Unary operations
4. Binary operations

MCQ 200: If any of the foreign-key columns is null, the tuple is defined automatically to satisfy the:

1. Integrity
2. Atomicity
3. Isolation
4. Constraint