answer
The ____ operator is inclusive, meaning that a value equal to either end would be selected.
answer
The ____ operator uses one or more wildcard characters to test for a pattern match.
answer
Preceding a condition by the ____ operator reverses the truth of the original condition.
question
SELECT-FROM-WHERE
answer
The basic form of the SQL SELECT command is ____.
Don’t waste time
You can get a custom paper by one of our expert writers.
Get your custom essay
Helping students since 2015
answer
The ____ clause lets you group data on a particular column
answer
The wildcard ____ symbol represents an individual character
answer
in the select clause, you can use the ____symbol to indicate that you want to include all columns
answer
The ____ clause is used to restrict the groups that will be included in a query result
answer
in SQL you use the ____ command to query a database
answer
when you need to sort data on two columns, the less important column is called the ____ sort key.
answer
the ____ operator specifies a range of values in a condition
answer
you can use the ____ operator following by a collection of values to provide a concise way of phrasing certain conditions
answer
the ____ function calculates a total of the values in a column
answer
In SQL for oracle and for SQL server, the ____ symbol is used as a wildcard to represent any collection of characters.
answer
You use the ____ clause to list data in a specific order
question
T/F you cannot assign names to computed columns
question
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
question
T/F the only arithmetic operators that can be used in SELECT statements are + for additions and - for subtraction
question
t/f the BETWEEN operator is an essential feature of SQL.
question
t/f to specify that query results be listed in a specific order, use the SORT BY clause
question
t/f A query is a question represented in a way that the DBMS can understand
question
t/f sometimes a condition involves a column that can accept null values
question
t/f the DISTINCT operator is useful when used in conjunction with the COUNT function
question
t/f its possible to place one query inside another
question
t/f the MIN function determines the minimum value in a column
