True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Use
CREATE TABLE to insert rows into a table.
|
|
|
2.
|
A
valid name might be tblEmp&Manage.
|
|
|
3.
|
A
valid name for a table might be tblEmployee.
|
|
|
4.
|
In
the SELECT clause, you list the fields that you want to display; the order of the list is the order
of display.
|
|
|
5.
|
Tables from which you are retrieving data should be in the WHERE clause.
|
|
|
6.
|
There
are two versions of the not equal operator - <> and !=.
|
|
|
7.
|
There
are two compound conditions - AND, OR
|
|
|
8.
|
When
using the AND condition, only one simple condition must be true for the compound condition to be
true.
|
|
|
9.
|
Using
the NOT operator with a compound conditional operator (AND, OR) will negate the
condition.
|
|
|
10.
|
The
BETWEEN operator is an alternative to using some of the relational operators.
|
|
|
11.
|
All
fields that will display due to a SELECT statement must be present in the database.
|
|
|
12.
|
Using
the LIKE operator with the wildcard symbol will allow you to display those rows whose fields match a
certain collection of characters.
|
|
|
13.
|
The
IN operator will allow you to choose from a given set of choices.
|
|
|
14.
|
The
ORDER BY clause will permanently sort the original table.
|
|
|
15.
|
The
ORDER BY clause will sort the results of the SELECT statement by a specified sort key.
|
|
|
16.
|
The
output from a SELECT can only be ordered (sorted) by one key.
|
|
|
17.
|
The
COUNT function will return the number of rows affected in your SELECT query.
|
|
|
18.
|
There
is no difference between the COUNT function and the SUM function.
|
|
|
19.
|
A
subquery is a nested query.
|
|
|
20.
|
In
order to calculate sales for each sales rep, you need to group the customers together for each sales
rep.
|
|
|
21.
|
The
clause used to group customers together is the ORDER BY clause.
|
|
|
22.
|
You
can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.
|
|
|
23.
|
Use
the WHERE clause to restrict output from the SELECT using a GROUP BY.
|
|
|
24.
|
Use
the HAVING clause to restrict output from the SELECT using a GROUP BY.
|
|
|
25.
|
A
WHERE and a HAVING clause can be included in the same query.
|
|
|
26.
|
Use
the WHERE clause to join tables.
|
|
|
27.
|
For
each pair of tables to be joined, a condition must be included indicating how the tables are
related.
|
Modified True/False
Indicate
whether the sentence or statement is true or false. If false, change the identified word or
phrase to make the sentence or statement true.
|
|
|
28.
|
The
CREATE TABLE command will describe the layout of a table.
|
|
|
29.
|
A(n)
decimal data type is used to store numbers without a decimal part.
|
|
|
30.
|
Many
versions of SQL require that commands end with a(n) colon.
|
|
|
31.
|
An
SQL query can use the & symbol to shortcut the SELECT query; all fields will be selected
when this symbol is used.
|
|
|
32.
|
The
WHERE clause is used to restrict the query results of a SELECT statement.
|
|
|
33.
|
A(n)
simple condition consists of the field name, comparison operator, and either another field
name or a value.
|
|
|
34.
|
Complex conditions are formed by connecting two or more simple conditions.
|
|
|
35.
|
In
order to negate a condition, use the NOR operator.
|
|
|
36.
|
In
order to list data for which both conditions in your query are true, use the OR operator.
|
|
|
37.
|
In
order to list data for which only one condition in your query is true, use the OR operator.
|
|
|
38.
|
Use
the IN operator with a wildcard symbol to match a certain collection of characters.
|
|
|
39.
|
The
two wildcard symbols are * and ! .
|
|
|
40.
|
Using
the ORDER BY clause will sort the query results.
|
|
|
41.
|
Use
DESC for a descending sort.
|
|
|
42.
|
Use
SUM to get the number of rows affected by the query.
|
|
|
43.
|
Use
SUM to get the total of a particular numeric field in a query.
|