Chapter7

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

• True

• False

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

• True

• False

The ANSI SQL standards are also accepted by the ISO.

• True

• False

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

• True

• False

All SQL commands must be issued on a single line.

• True

• False

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command’s components.

• True

• False

An alias cannot be used when a table is required to be joined to itself in a recursive query.

• True

• False

Oracle users can use the Access QBE (query by example) query generator.

• True

• False

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

• True

• False

Comparison operators cannot be used to place restrictions on character-based attributes.

• True

• False