Exam 7: Introduction to Structured Query Language (SQL)

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.

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?

SQL allows the use of logical restrictions on its inquiries such as OR,AND,and NOT.

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

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

To delete a row from the PRODUCT table,use the ____ command.

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

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

Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

In Oracle,the ____ command is used to change the display for a column,for example,to place a $ in front of a numeric value.

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

Which query will list all the rows in which the inventory stock dates occur on or after January 20,2010?

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

What command is used to save changes to the database? What is the syntax for this command?

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

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

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

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

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

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.