Exam 5: Beginning Structured Query Language Sql

The ____________________ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables you to transform data into information.

The conditional LIKE must be used in conjunction with wildcard characters.

If you have not yet used the COMMIT command to store the changes permanently in the database, you can restore the database to its previous condition with the ROLLBACK command.

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

The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.

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

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

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.

To join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attribute values do not match.

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

String comparisons are made from left to right.

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

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?

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

Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes.

To list all the contents of the PRODUCT table, you would use ____.

The ANSI SQL standards are also accepted by the ISO.

The SQL command that modifies an attribute's values in one or more table's rows is ____.

With the exception of the database ____________________ process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

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