DBMS Chapter 7 Review

The ____ query will output the table contents when the value of V_CODE is equal to 21344. a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344; b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344; c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344; d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;

The ____ query will output the table contents when the value of V_CODE is not equal to 21344. a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344; b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344; c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344; d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;

The ____ query will output the table contents when the value of V_CODE is less than or equal to 21344. a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344; b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <=21344; c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344; d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;

The ____ query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1. a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1'; b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1] c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1) d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1}

The ____ mainframe query command will list all the rows in which the inventory stock dates occur on or after January 20, 2008. a. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= '01/20/2008' b. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= #01/20/2008# c. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE <= '20-JAN-2008' d. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= {01-20-2008}

A(n) ____ is an alternate name given to a column or table in any SQL statement. a. alias c. stored function b. data type d. trigger

The ____ command uses columns and column aliases to determine the total value of inventory held on hand. a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_ONHAND/P_PRICE FROM PRODUCT; b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_ONHAND=P_PRICE FROM PRODUCT; c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT; d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_ONHAND-P_PRICE FROM PRODUCT;

The ____ command uses columns and column aliases to determine the total value of inventory held on hand and to display the results in a column labeled TotValue. a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE FROM PRODUCT; b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE FROM PRODUCT; c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE FROM PRODUCT; d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE FROM PRODUCT;

____ is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288. a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288 b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288 c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288 d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288

The special operator used to check whether an attribute value is within a range of values is ____. a. BETWEEN c. LIKE b. NULL d. IN

The ____ special operator is used to check whether an attribute value is null. a. BETWEEN c. LIKE b. IS NULL d. IN

The special operator used to check for similar character strings is ____. a. BETWEEN c. LIKE b. IS NULL d. IN

The special operator used to check whether a subquery returns any rows is ____. a. BETWEEN c. LIKE b. EXISTS d. IN

The ____ command is used with the ALTER TABLE command to modify the table by deleting a column. a. DROP c. DELETE b. REMOVE d. ERASE

A table can be deleted from the database by using the ____ command. a. DROP c. MODIFY b. DELETE d. ERASE

The command 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 ____. a. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE; b. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE; c. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE; d. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;

The SQL command to output the contents of the Employee table sorted by last name, first name, and initial is ____. a. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; b. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; c. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; d. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

The ____ command is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another. a. SELECT ONLY V_CODE FROM PRODUCT; b. SELECT UNIQUE V_CODE FROM PRODUCT; c. SELECT DIFFERENT V_CODE FROM PRODUCT; d. SELECT DISTINCT V_CODE FROM PRODUCT;

The SQL aggregate function that gives the number of rows containing not null values for the given column is ____. a. COUNT c. MAX b. MIN d. SUM

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____. a. COUNT c. MAX b. MIN d. SUM

The SQL aggregate function that gives the average for the specific column is ____. a. COUNT c. MAX b. AVG d. SUM

The command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the value of V_CODE match is ____. a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;

The command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the VENDOR table, where the value of V_CODE match and the output is ordered by the Price is ____. a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY P_PRICE; b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY P_PRICE; c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY P_PRICE; d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY P_PRICE;

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

The basic SQL vocabulary has a fewer than ____________________ words.

A(n) ____________________ is a group of database objects, such as tables and indexes, that are related to each other.

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

U.S. state abbreviations are always two characters, so ____________________(2) is a logical choice for the data type representing a state column.

If your integer values are relatively small, use ____________________ instead of INT.

In a 1:M relationship, you must always create the table for the ____________________ side first.

____________________ words are words used by SQL to perform specific functions.

Using the ____________________ command, SQL indexes can be created on the basis of any selected attribute.

A common practice is to create a(n) ____________________ on any field that is used as a search key, in comparison operations in a conditional expression, or when you want to list rows in a specific order.

To delete an index, use the ____________________ command.

You can indicate just the attributes that have required values by listing the ____________________ inside parentheses after the table name.

A(n) ____________________ character is a symbol that can be used as a general substitute for other characters or commands.

A(n) ____________________, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

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

DATE() and SYSDATE are special functions that return today's date in MS Access and ____________________, respectively.

In SQL, all ____________________ expressions evaluate to true or false.

A specialty field in mathematics, known as ____________________ algebra, is dedicated to the use of logical devices.

If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.

A table can be deleted from the database by using the ____________________ command.

A(n) ____________________ order sequence can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Frequency distributions can be created quickly and easily using the SQL ____________________ clause.

The _____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

A(n) ____________________ is performed when data is retrieved from more than one table at a time.

An alias is especially useful when a table must be joined to itself in ____________________ queries.