Exam 8: SQL Functions and Procedures

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

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

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

The process of combining two or more character columns into a single expression is called ____________________.

What are the three advantages of cursors?

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

In Oracle and SQL Server, the ____ function displays a value in uppercase letters.

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

A(n) ____________________ is a pointer to a row in the collection of rows retrieved by an SQL command.

In T-SQL, arguments should have the same data type and length as the particular column in a table that they represent.

In PL/SQL, procedural code appears between the BEGIN and END commands.

You use aggregate functions to perform calculations based on groups of records.

A(n) ____________________ is a computer that is connected to a network and has access through the server to the database.

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

Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed ____ characters.

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

A(n) ____________________ language is one in which you must give the computer the step-by-step process for accomplishing a task.

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

Name two reasons for creating a stored procedure.

A trigger is a pointer to a row in the collection of rows retrieved by an SQL command.