Function count() is a/an …………… function.

1. Single row
2. Multiple rows
3. Aggregate
4. None of these

The sum(), if used in a condition, is used with …………… clause.

1. Group by
2. With
3. Where
4. Having

What is the meaning of "WHERE" clause in a GROUP BY query ?

1. To filter out the summary groups
2. To filter out the column groups
3. To filter out the row and column values before creating groups
4. None of the mentioned

The following SQL is which type of join :

SELECT CUSTOMER.CUST_ID, ORDER.CUST_ID, NAME, ORDER_ID 
FROM CUSTOMER, ORDER
WHERE CUSTOMER.CUST_ID = ORDER.CUST_ID?

1. Equi-join
2. Natural join
3. Outer join
4. Cartesian product