final database design ch7

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

False

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

False

The SQL aggregate function that gives the number of rows containing non-null values for a given column is_______.

COUNT

The Oracle ______ functions compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found

DECODE

_____ is a relational set operator.

EXCEPT

In Oracle, the _____ function converts a date to a character string

TO_CHAR()

All SQL commands must be issued on a single line.

false

Most SQL implementations yield case-insensitive searches.

false

When using a(n) ____ join, only rows from the tables that math on a common value are returned

inner

A(n) _____ join will select only the rows with matching values in the common attribute(s),

natural

What type of command does this SQL statement use? SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE=VENDOR. V_CODE

old style join

A(n) _____ is a query that is embedded (or nested) inside another query.

subquery

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

true

Data procedures are often more software specific than other SQL procedures

true

Numeric functions take one numeric parameter and return one value.

true

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

true

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

true