Exam 8: SQL Functions and Procedures

When you use a cursor, the ____________________ command opens the cursor and causes the query to be executed, making the results available to the procedure.

When you anticipate running a particular query often, you can improve overall performance by saving the query in a file called a routine.

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

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

DBMS_OUTPUT is a package that contains multiple procedures, including PUT_LINE.

A procedure that updates data is called a(n) ____________________ procedure.

A(n) ____ is a procedure that is executed automatically in response to an associated database operation.

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

Each procedure that you create in Oracle should end with a(n) ____________________.

PL/SQL can process only one record at a time.

In Access, use the & symbol to concatenate columns.

A(n) ____________________ is a procedure that is executed automatically in response to an associated database operation, such as an INSERT, UPDATE, or DELETE command.

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

In PL/SQL, you can ensure that a variable has the same data type as a particular column by using the ____ attribute.

PL/SQL, which was developed by Oracle as an extension of SQL, is an example of a procedural language.

In Oracle, to add a specific number of months to a date, use the ____ function.

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

In Oracle, SQL Server, and Microsoft Access, use the ____ function to round a numeric value to a desired number of decimal places.

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

To handle processing of errors, include an ABORT clause in a stored procedure.