The operation whose result contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

1. Join
2. Cartesian product
3. Intersection
4. Set difference

Which SQL function is used to count the number of rows in a SQL query ?

1. COUNT()
2. NUMBER()
3. SUM()
4. COUNT(*)

All aggregate functions except …………… ignore null values in their input collection.

1. Count(attribute)
2. Count(*)
3. Avg
4. Sum

Which of the following is a SQL aggregate function ?

1. LEFT
2. AVG
3. JOIN
4. LEN