Modification of Database MCQ (Multiple Choice Questions) PDF - 242

MCQ 1206: To insert data into a relation, we specify a tuple to be

1. Retrieved
2. Processed
3. Tested
4. Inserted

MCQ 1207: A protocol that permits a transaction to lock a new data item only if it has not yet unlocked any data item, is called

1. Two-phase unlocking protocol
2. One-phase locking protocol
3. Two-phase locking protocol
4. One-phase unlocking protocol

MCQ 1208: The first part, which is the upper half of the rectangle, contains the name of

1. All attributes
2. Entity set
3. Schema
4. Domain

MCQ 1209: The aggregate function that returns the number of the elements in the collection is known as

1. total
2. count
3. whole
4. combine

MCQ 1210: The rolling back of any transaction takes place at the stage of

1. Partially committed
2. Aborted
3. Active
4. Committed