Exam 8: SQL Functions and Procedures

To remove extra spaces to the right of a value,for example,the value in a FIRST_NAME column,use the ____ function.

____________________ is the procedural language that SQL Server uses.

What are the three advantages of cursors?

You cannot use functions in WHERE clauses.

To handle processing of errors,include a(n)____________________ clause in stored procedure.

In T-SQL,all arguments start with the ampersand (&)symbol.

In SQL Server,the cursor property ____________________ means that the cursor is used for retrieval purposes only.

Microsoft Access supports triggers.

Oracle,SQL Server,and Access all use the ADD_MONTHS function to add the number of months to a date.

To create a stored procedure,use the CREATE PROCEDURE command.

The UPPER function allows you to manipulate numeric data.

In Microsoft Access,the ____ function displays a value in uppercase letters.

In procedural languages,you can accomplish many tasks using a single command.

A function can have more than one argument.

To call a procedure in SQL Server,use the EXEC command.

In Oracle and SQL Server,use the ____ function to truncate everything to the right of the decimal point.

If a price is 24.95,the function ROUND(PRICE,0)would result in 24.

In SQL Server,use the & symbol to concatenate columns.

In the function UPPER(LAST_NAME),the item in parentheses (LAST_NAME)is called the ____________________ for the function.

In Access,use the & symbol to concatenate columns.