Selected answer b answers a b c d question 13 2 out

Selected
Answer:
b.
*
Answers:
a.
/
b.
*
c.
?
d.
\
 Question 13
2 out of 2 points
When the OR operator connects simple conditions, the compound condition will be true
whenever any one of the simple conditions is true.
Selected
Answer:
Tru
e
Answers:
Tru
e
Fals
e
 Question 14
2 out of 2 points
When you connect two or more simple conditions with the AND operator, each condition must
be listed on a separate line.
Selected
Answer:
Fals
e
Answers: Tru
e
Fals
e
 Question 15
2 out of 2 points

The only arithmetic operators that can be used in SELECT statements are + for addition and -
for subtraction.
Selected
Answer:
Fals
e
Answers: Tru
e
Fals
e
 Question 16
2 out of 2 points
The basic form of the SQL SELECT command is ____.
Selected
Answer:
a.
SELECT-FROM-WHERE
Answers:
a.
SELECT-FROM-WHERE
b.
FROM-SELECT-WHERE
c.
FROM-WHERE-SELECT
d.
WHERE-SELECT-FROM
 Question 17
2 out of 2 points
You cannot assign names to computed columns.
Selected
Answer:
Fals
e
Answers: Tru
e
Fals
e
 Question 18
2 out of 2 points
All SELECT statements require a WHERE clause.
Selected
Answer:
Fals
e
Answers: Tru
e
Fals
e
 Question 19

2 out of 2 points
The MIN function determines the minimum value in a column.
Selected
Answer:
Tru
e
Answers:
Tru
e
Fals
e
 Question 20
0 out of 2 points
The ____ operator specifies a range of values in a condition.
Selected
Answer:
b.
GROUP
Answers: a.
LIKE
b.
GROUP
c.
BETWEEN
d.
DISTINCT
 Question 21
2 out of 2 points
When you need to sort data on two columns, the less important column is called the ____ sort
key.
Selected
Answer:
c.
minor
Answers: a.
foreign
b.
primary
c.
minor
d.
double
 Question 22
2 out of 2 points
In a SELECT statement, the FROM clause and the WHERE clause (when used) must appear on
separate lines.
Selected
Answer:
Fals
e

Answers: Tru
e
Fals
e
 Question 23
2 out of 2 points
A query is a question represented in a way that the DBMS can understand.
Selected
Answer:
Tru
e
Answers:
Tru
e
Fals
e
 Question 24
2 out of 2 points
The DISTINCT operator is useful when used in conjunction with the COUNT function.
Selected
Answer:
Tru
e
Answers:
Tru
e
Fals
e
 Question 25
2 out of 2 points
The WHERE clause applies to both rows and groups.