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.

What is the difference between a nonprocedural language and a procedural language? Give an example of each.

In SQL Server, you can use the ____ function to obtain today's date.

A client is a computer that is connected to a network and has access through the server to the database.

To create a stored procedure in Oracle, use the ____________________ command.

In Microsoft Access, programs are written in ____________________, which does not support embedded SQL commands directly in the code.

In Microsoft Visual Basic, use the ____ statement to create a string variable.

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

The ADD_MONTHS function has one argument.

____________________ is the procedural language that SQL Server uses.

In Microsoft Access, you can use the ____ function to obtain today's date.

To add a specific number of days to a date, you must use a function.

PL/SQL commands have a certain format and cannot include any blank lines in the code.

The UPPER function allows you to manipulate numeric data.

To close a cursor and deactivate it, use the ____________________ command.

In Microsoft Access, you must store an SQL command in a string variable.

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

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

When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.

Microsoft Access supports triggers.