Question 1

BETWEEN

Accepted Answer

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

Question 2

LIKE

Accepted Answer

The ____ operator uses one or more wildcard characters to test for a pattern match.

Question 3

NOT

Accepted Answer

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

Question 4

SELECT-FROM-WHERE

Accepted Answer

The basic form of the SQL SELECT command is ____.

Question 5

GROUP BY

Accepted Answer

The ____ clause lets you group data on a particular column

Question 6

_

Accepted Answer

The wildcard ____ symbol represents an individual character

Question 7

*

Accepted Answer

in the select clause, you can use the ____symbol to indicate that you want to include all columns

Question 8

HAVING

Accepted Answer

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

Question 9

SELECT

Accepted Answer

in SQL you use the ____ command to query a database

Question 10

minor

Accepted Answer

when you need to sort data on two columns, the less important column is called the ____ sort key.

Question 11

BETWEEN

Accepted Answer

the ____ operator specifies a range of values in a condition

Question 12

IN

Accepted Answer

you can use the ____ operator following by a collection of values to provide a concise way of phrasing certain conditions

Question 13

SUM

Accepted Answer

the ____ function calculates a total of the values in a column

Question 14

%

Accepted Answer

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

Question 15

ORDER BY

Accepted Answer

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

Question 16

T/F you cannot assign names to computed columns

Accepted Answer

False

Question 17

T/F instead of including every column in the SELECT clause, you can use an ampersand (&) to indicate that you want to include all columns

Accepted Answer

False

Question 18

T/F the only arithmetic operators that can be used in SELECT statements are + for additions and - for subtraction

Accepted Answer

False

Question 19

t/f the BETWEEN operator is an essential feature of SQL.

Accepted Answer

false

Question 20

t/f to specify that query results be listed in a specific order, use the SORT BY clause

Accepted Answer

False

Question 21

t/f A query is a question represented in a way that the DBMS can understand

Accepted Answer

true

Question 22

t/f sometimes a condition involves a column that can accept null values

Accepted Answer

true

Question 23

t/f the DISTINCT operator is useful when used in conjunction with the COUNT function

Accepted Answer

true

Question 24

t/f its possible to place one query inside another

Accepted Answer

true

Question 25

t/f the MIN function determines the minimum value in a column

Accepted Answer

true

ITS 129 CH.4

Unlock all answers in this set

Haven't found what you need?