Ch. 3 DODM
Most relational database use SQL as a database language to manipulate.. T or F
True
Preceding a condition by the Not operator reverses the truth or falsity of original condition.. T or F
True
The HAVING clause is to group to what the WHERE clause is to rows.. T or F
True
There are two versions of the not equal to operator: <> and !=... T or F
True
When you enter numbers in an SQL command, you do not type commas or dollar signs... T or F
True
You can use GROUP BY clause and ORDER BY clause in same statement.. T or F
True
in SQL, you join tables by entering the appropriate conditions in WHERE clause.. T or F
True
instead of listing all fields, you can use *.. t or f
True
the IN operator can be used or the OR operator in phrasing certain conditions.. T or F
True
you can combine values in character fields as well as number fields.. T or F
true
MySQL use the ____ as a wildcard
underscore
the ____ of two tables
union
two tables involved must have same structure or be_____
union compatiable
in order to make changes to existing data in a table, you would use the ______ command
update
a simple condition includes the field name, ______ operator, and either another field name or a value
comparison
You can use the SQL command to create a table by descending..
create table
The rules for naming tables and columns are the same in every version of SQL.. T or F
false
When you involve a character field, such as customer Name, you must enclose the value in which its being compared to with %.. T or F
false
Fields will appear in query results in the order in which they are listed in the select clause.. T or F
True
By using the word in a query after a comparison..
AS
use the ______ data types for fields that contain letters and other special characters
CHAR
In MYSQl use...
Concat
When you use a name containing a space in SQL you must..
Enclose in brackets
CHAR data types are #'s without a decimal.. T or F
False
In SQL, you use the SORT BY clause to display results in a desired order... T or F
False
In the SELECT statement, the WHERE clause is mandatory.. T or F
False
The BETWEEN operator is an essential feature of SQL.. T or F
False
To create nubers with decimals Access you can use the currency number or decimal data types.. T or F
False
a WHERE and HAVING clause cannot be included in the same query.. T or F
False
You can save results of a query as a table by including the ______ clause in the query.
INTO
To use as wildcard, include the ____ operator in WHERE clause
LIKE
when you connect simple conditions using the _____ operator, the compound condition will be true whenever any of the true
OR
Basic form of SQL retrieval command
SELECT FROM WHERE
SQL was developed under the name_______ at the IBM San Jose research facilities
SEQUEL
one common restriction placed on table and column placed letters, numbers,_______
Underscore
Many versions of SQL require you to end a command..
a semicolon
built in functions
aggregate
the _____ clause can be used to create groups of records
group by
To add new data use_____
insert
the _____ function determines the largest value in a given column
max
When rows are grouped..
one line of output is produced
in MYSQL, the ____ is used as a wildcard to represent any collection...
percent sign
In Access SQL, the ____ is used as a wildcard to represent any individual number..
question mark
the ______ data type stores integers but uses less space
smallint
Are you are working in my SQL...
statement
When a subquery is used,_______ are evaluated first
subquery
