Reference no: EM132757447
Indicated whether each of the following statements is True or False (to answer put a 'T' or an 'F' in the space to the left of each question number):
1. A WHERE clause needs to be included in every SQL statement.
2. By using a WHERE clause, you can exclude rows before dividing them into groups.
3. With reference to following table schema emp (empno, ename, job, sal, mgr, comm, deptno) The following SELECT statement will execute successfully. SELECT ename, job, salary AS Sal FROM emp;
4. Using a subquery is equivalent to performing two sequential queries and using the result of the first query as the search value(s) in the second query.
5. A SELECT clause must contain at least one column name. [1 Point]
6. Aliases used in a FROM clause rename the table name in the database.
7. Aggregate functions include NULLs in calculations.
8. The WHERE clause restricts rows before inclusion in a group calculation.
9. No grouping columns can be listed in the SELECT clause of a SQL statement that involves a GROUP BY clause.
10. The HAVING clause can be used without a GROUP BY clause.