 |
1 |  |  Since its inception in the 1970's, SQL has been an international standard, primarily because IBM was the first company to commercialize it. |
|  | A) | True |
|  | B) | False |
 |
 |
2 |  |  Case sensitivity is only an important concern with exact matching. |
|  | A) | True |
|  | B) | False |
 |
 |
3 |  |  When two tables are joined in the WHERE clause on the same column name, the column names must be prefixed by the table names to avoid ambiguity. |
|  | A) | True |
|  | B) | False |
 |
 |
4 |  |  Conditions being tested in the WHERE clause cannot involve aggregate functions. |
|  | A) | True |
|  | B) | False |
 |
 |
5 |  |  Since the HAVING clause applies to groups of rows, you cannot have a HAVING clause without a GROUP BY clause. |
|  | A) | True |
|  | B) | False |
 |
 |
6 |  |  When grouping on more than one column, the result table will include one row for each combination of the grouping columns. |
|  | A) | True |
|  | B) | False |
 |
 |
7 |  |  When sorting with an ORDER BY clause, the default order is ascending, however this can be overridden using the keyword DESC. |
|  | A) | True |
|  | B) | False |
 |
 |
8 |  |  By default, SQL automatically removes duplicate rows from a result table, regardless of the DBMS running the query. |
|  | A) | True |
|  | B) | False |
 |
 |
9 |  |  The cross product style of query formulation can join any number of tables, but the join operator style limits the join to at most five tables. |
|  | A) | True |
|  | B) | False |
 |
 |
10 |  |  A self-join between a table and itself can be is useful for discovering relationships among columns of the same table. |
|  | A) | True |
|  | B) | False |
 |