QUESTION 1 When you connect two or more simple conditions with the AND operator,

Question

QUESTION 1

When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.

True

False

4 points   

QUESTION 2

The ____ operator is inclusive, meaning that a value equal to either end would be selected.

AND

BETWEEN

OR

NOT

4 points   

QUESTION 3

The ____ wildcard symbol represents any individual character.

_

/

%

4 points   

QUESTION 4

Preceding a condition by the NOT operator reverses the truth of the original condition.

True

False

4 points   

QUESTION 5

A query is a question represented in a way that the DBMS can understand.

True

False

4 points   

QUESTION 6

In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.

?

*

/

4 points   

QUESTION 7

When you query a database, there is a defined order in which the results are displayed.

True

False

4 points   

QUESTION 8

After the word FROM in a SELECT statement, you list any conditions (restrictions) that apply to the data you want to retrieve.

True

False

4 points   

QUESTION 9

A simple condition has the form: column name, comparison operator, and then either another column name or a value.

True

False

4 points   

QUESTION 10

When you use the ____ function, you can use the asterisk (*) to represent any column.

MIN

COUNT

SUM

MAX

4 points   

QUESTION 11

The ____ function determines the number of rows in a table.

COUNT

NUMBER

CALCULATE

ROW

4 points   

QUESTION 12

Preceding a condition by the ____ operator reverses the truth of the original condition.

NOT

NULL

REVERSE

OR

4 points   

QUESTION 13

To sort records in descending order, follow the name of the sort key with the REVERSE operator.

True

False

4 points   

QUESTION 14

The WHERE clause applies to both rows and groups.

True

False

4 points   

QUESTION 15

The MIN function determines the minimum value in a column.

True

False

4 points   

QUESTION 16

The UNIQUE operator eliminates duplicate values in a query.

True

False

4 points   

QUESTION 17

In SQL, you use the ____ command to query a database.

FROM

WHERE

SET

SELECT

4 points   

QUESTION 18

You use the ____ clause to list data in a specific order.

LIST BY

ORDER BY

SET ORDER

ORDER

4 points   

QUESTION 19

The ____ clause is used to restrict the groups that will be included in a query result.

HAVING

HAVE

LIKE

WHERE

4 points   

QUESTION 20

In SQL for Oracle and for SQL Server, the ____ symbol is used as a wildcard to represent any collection of characters.

*

!

%

?

4 points   

QUESTION 21

You cannot assign names to computed columns.

True

False

4 points   

QUESTION 22

An arithmetic column is a column that does not exist in the database but can be computed using data in existing columns.

True

False

4 points   

QUESTION 23

In a SELECT statement, the FROM clause and the WHERE clause (when used) must appear on separate lines.

True

False

4 points   

QUESTION 24

The COUNT function only applies to columns with numeric values.

True

False

4 points   

QUESTION 25

In a nested query, the outer query is evaluated first.

True

False

a.

AND

b.

BETWEEN

c.

OR

d.

NOT

Explanation / Answer

QUESTION 1 :- False
No Need we can write in one line also.

QUESTION 2 :- b. BETWEEN
The values between the either values specofied will returned with this operator.

QUESTION 3 :- b. _
_(underscore) represents a single character.

QUESTION 4 :- True
Not operator always reverses the result of the given condition.

QUESTION 5 :- True

QUESTION 6 :- b *
* indicates all in sql.

QUESTION 7 :- False
There is no defined order

QUESTION 8 :- False
After FROM we need to specify the table names on which we are performing the operations.

QUESTION 9 :- True

QUESTION 10 :- b. COUNT
We can use * in count function which represents any column.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.