Aggregate Functions Notes Questions with Answers PDF Download – Test 75

MCQ 371: Aggregate functions are functions that take a set or multiset of values as input and return:

1. Single value
2. Multiple sets
3. Multiple attributes
4. A relation

MCQ 372: The indexing technique should perform the types of access that are supported:

1. Efficiently
2. Minimum
3. Maximum
4. Specifically

MCQ 373: A two-phase locking protocol variant that requires that all locks be held until the transaction commit is called:

1. Lock-point two-phase locking protocol
2. Deadlock two-phase locking protocol
3. Strict two-phase locking protocol
4. Rigorous two-phase locking protocol

MCQ 374: The operations of Natural-join are:

1. Commutative
2. Associative
3. Distributive
4. Conjunctive

MCQ 375: Ensuring enough free disk space availability for normal operations, are goals to be achieved by:

1. Database Manager
2. Database system
3. Database administrator
4. Database users