Basic SQL

Which of the following are components of an SQL statement

• SELECT

• FROM

• WHERE

• PROJECT

• CARTESIAN PRODUCT

True or False? The order of components is Important in SQL

• True: SELECT FROM WHERE <> SELECT WHERE FROM

• False: SELECT FROM WHERE = SELECT WHERE FROM

The result of an SQL statement is a:

• Set

• Multi-set

• RA statement

• SQL statement

Which of the following are aggregate functions?

• AVG

• MAX

• GROUP BY

• HAVING

• DISTINCT

Which of the following are valid JOINS?

• SELECT T1.A, T2.B FROM T1, T2 WHERE T1.C=T2.D

• SELECT T1.A, T2.B FROM T1 INNER JOIN T2 ON T1.C=T2.D

• SELECT T1.A, T2.B FROM T1 LEFT OUTER JOIN T2 ON T1.C=T2.D

• SELECT T1.A, T2.B FROM T1 AND T2

• SELECT T1.A, T2.B FROM T1, T2