Exam 8: SQL Functions and Procedures

Although Access does not support stored procedures,you can achieve some of the same convenience by creating a(n)____________________ query that prompts the user for the arguments you would otherwise use in a stored procedure.

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

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

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

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

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

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

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

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

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

In SQL Server,you delete a cursor by using the ____________________ command.

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

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

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

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

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

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

When you use a cursor in a procedure,the ____ command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables.

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

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