Exam 7: Introduction to Structured Query Language Sql

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

A(n) _____ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Describe the important features and applications of SQL functions.

Date procedures are often more software-specific than other SQL procedures.

In the SQL environment, the word _____ covers both questions and actions.

Numeric functions take one numeric parameter and return one value.

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

The _____ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables.

The special operator used to check whether an attribute value matches a given string pattern is _____.

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

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

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

The special operator used to check whether an attribute value is within a range of values is _____.

When using a(n) _____ join, only rows from the tables that match on a common value are returned.

String comparisons are made from left to right.

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

You cannot insert a row containing a null attribute value using SQL.

_____ is a string function that returns the number of characters in a string value.

_____ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

The special operator used to check whether a subquery returns any rows is _____.