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

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

Which clause cannot be used with "aggregate functions" ?

1. GROUP BY
2. SELECT
3. WHERE
4. Both (1) and (3)

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

The following SQL is which type of join :

SELECT CUSTOMER.CUST_ID, ORDER.CUST_ID, NAME, ORDER_ID
FROM CUSTOMER, ORDER

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