Database Triggers MCQs with Answers PDF Download – Test 398

MCQ 1986: For backup replica systems that have to take over from the primary system, triggers would have to be:

1. Enabled explicitly
2. Enabled initially
3. Disabled automatically
4. Disabled initially

MCQ 1987: The database provides an abstraction of a transaction as being:

1. Atomic
2. Non-atomic
3. Isolated
4. Non-isolated

MCQ 1988: A query that involves a Cartesian product includes a:

1. Projection operation
2. Selection operation
3. Union operation
4. Set-intersection operation

MCQ 1989: An interface between the computer system and the actual hardware of the disk drive, is said to be:

1. Disk controller
2. Remapping controller
3. Data controller
4. Revolving controller

MCQ 1990: The file organization that have a single file for each relation is named as:

1. Sequential file organization
2. Heap file organization
3. Clustered file organization
4. Hashing file organization