MIS 2113 Comprehensive-Quizzes With
Complete Solutions
The maximum number of clauses in an SQL Select statement is: -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-6 |
The minimum number of clauses in an SQL Select statement is: -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-2 |
A column whose value is always unique in every row in a table is called a
| | | | | | | | | | | | | | |
- CORRECT ANSWER✔✔-key
| | |
The clause that gives the condition for selecting rows is the __ clause -
| | | | | | | | | | | | | |
CORRECT ANSWER✔✔-where |
Let's assume that you wrote a query that has the following four clauses:
| | | | | | | | | | | | |
Select, From, Where, Order By. What is the order in which the four SQL
| | | | | | | | | | | | | |
query clauses are executed? - CORRECT ANSWER✔✔-from, where,
| | | | | | | |
select, order by | |
To eliminate duplicate values you put into the Select clause use this key
| | | | | | | | | | | | |
word: - CORRECT ANSWER✔✔-distinct
| | |
, The process of linking records in different tables to execute a query is
| | | | | | | | | | | | |
called a - CORRECT ANSWER✔✔-join
| | | |
* in an SQL Select statement means: - CORRECT ANSWER✔✔-List all
| | | | | | | | | | |
columns
To override precedence of AND, OR, and NOT, use: - CORRECT
| | | | | | | | | | |
ANSWER✔✔-Parentheses
The maximum number of tables that can be joined in an SQL Select
| | | | | | | | | | | | |
statement is: - CORRECT ANSWER✔✔-There is no maximum
| | | | | | |
The process of linking records in different tables is called: - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-JOINing
To eliminate duplicate values, put into the SELECT clause the keyword: -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-Distinct |
The FROM clause can contain a second, much simpler, name for a table.
| | | | | | | | | | | | |
This name is called an: - CORRECT ANSWER✔✔-Alias
| | | | | | |
What does the following statement return in SQL for SQL Server:
| | | | | | | | | |
"MONTH(PurchaseDate)" - CORRECT ANSWER✔✔-An integer for the
| | | | | | | |
month of the purchase such as 9
| | | | | |
Complete Solutions
The maximum number of clauses in an SQL Select statement is: -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-6 |
The minimum number of clauses in an SQL Select statement is: -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-2 |
A column whose value is always unique in every row in a table is called a
| | | | | | | | | | | | | | |
- CORRECT ANSWER✔✔-key
| | |
The clause that gives the condition for selecting rows is the __ clause -
| | | | | | | | | | | | | |
CORRECT ANSWER✔✔-where |
Let's assume that you wrote a query that has the following four clauses:
| | | | | | | | | | | | |
Select, From, Where, Order By. What is the order in which the four SQL
| | | | | | | | | | | | | |
query clauses are executed? - CORRECT ANSWER✔✔-from, where,
| | | | | | | |
select, order by | |
To eliminate duplicate values you put into the Select clause use this key
| | | | | | | | | | | | |
word: - CORRECT ANSWER✔✔-distinct
| | |
, The process of linking records in different tables to execute a query is
| | | | | | | | | | | | |
called a - CORRECT ANSWER✔✔-join
| | | |
* in an SQL Select statement means: - CORRECT ANSWER✔✔-List all
| | | | | | | | | | |
columns
To override precedence of AND, OR, and NOT, use: - CORRECT
| | | | | | | | | | |
ANSWER✔✔-Parentheses
The maximum number of tables that can be joined in an SQL Select
| | | | | | | | | | | | |
statement is: - CORRECT ANSWER✔✔-There is no maximum
| | | | | | |
The process of linking records in different tables is called: - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-JOINing
To eliminate duplicate values, put into the SELECT clause the keyword: -
| | | | | | | | | | | |
CORRECT ANSWER✔✔-Distinct |
The FROM clause can contain a second, much simpler, name for a table.
| | | | | | | | | | | | |
This name is called an: - CORRECT ANSWER✔✔-Alias
| | | | | | |
What does the following statement return in SQL for SQL Server:
| | | | | | | | | |
"MONTH(PurchaseDate)" - CORRECT ANSWER✔✔-An integer for the
| | | | | | | |
month of the purchase such as 9
| | | | | |
