Chapt.7 - Introduction to SQL

Portability of a database language is the

• ability to be used on different platforms or systems without modification

• ability to be used without any programming knowledge

• ability to automatically fix errors in the code

• ability to only be used on one specific platform

Which is not a feature of SQL?

• Object-oriented programming

• Data definition

• Data manipulation

• Data retrieval

Which SELECT clause restricts the selection of grouped rows based on a condition?

• WHERE

• HAVING

• ORDER BY

• GROUP BY

Which SELECT clause is used to restrict the selection of rows based on a conditional expression?

• FROM
• WHERE
• GROUP BY
• HAVING

___ clause arranges the selected rows based a one or more attributes.

• FILTER BY
• GROUP BY
• ORDER BY
• SORT BY

LIKE operator checks whether an attribute value

• is within a range

• matches any value within a value list

• is null

• matches a given string pattern

IN operator checks whether an attribute value

• is within a range

• matches any value within a value list

• is null

• matches a given string pattern

BETWEEN operator checks whether an attribute value

• is within a range

• matches any value within a value list

• is null

• matches a given string pattern

To limit values to unique values we use

• DISTINCT
• UNIQUE
• LIMIT
• ONLY

___ JOIN is used when the tables share one or more common attributes with common names.

• NATURAL

• LEFT

• RIGHT

• OUTER