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