 |
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 |
|