Aggregate Functions Multiple Choice Questions (MCQ) PDF Download

MCQ 1: To specify duplicate retention, we can use the keyword in place of distinct, which is

1. Select distinct
2. Duplicate
3. Whole
4. All

MCQ 2: If the tuples are satisfying the where predicate, then they are placed into groups by the

1. Having clause
2. Group by clause
3. Like clause
4. Distinct clause

MCQ 3: The clause that apply the aggregate functions to get a single result tuple for each group, is known to be

1. Select clause
2. From clause
3. Where clause
4. Distinct clause

MCQ 4: SQL standard says that the sum operator should ignore an input of

1. 0s
2. 1s
3. Null value
4. strings

MCQ 5: The groups that do not satisfy the having clause predicate are

1. Applied
2. Removed
3. Retrieved accordingly
4. Not retrieved