Exam 7: Introduction to Structured Query Language (SQL)

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.

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 ____.

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

Which query will output the table contents when the value of V_CODE is not equal to 21344?

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

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

The query 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 values of V_CODE match and the output is ordered by the price is ____.

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

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

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.

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

To list the contents of a table,you must use the DISPLAY command.

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

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

A database language enables the user to create database and table structures to perform basic data management chores.

Some RDBMSs,such as Oracle,automatically ____ data changes when issuing data definition commands.

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

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

SQL requires the use of the ADD command to enter data into a table.

An alias is especially useful when a table must be joined to itself in a(n)____________________ query.