Question 1

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

Accepted Answer

The answer of What is the difference between a nonprocedural...

Question 2

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

Accepted Answer

The answer of A(n)____________________ is a procedure that is executed...

Question 3

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

Accepted Answer

The answer of In Microsoft Access,programs are written in ____________________,which...

Question 4

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

Accepted Answer

The answer of To close a cursor and deactivate it,use...

Question 5

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

Accepted Answer

The answer of In SQL Server,the cursor property ____________________ means...

Question 6

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

Accepted Answer

The answer of A procedure that updates data is called...

Question 7

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.

Accepted Answer

The answer of Although Access does not support stored procedures,you...

Question 8

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

Accepted Answer

The answer of In SQL Server,you delete a cursor by...

Question 9

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

Accepted Answer

The answer of To create a stored procedure in Oracle,use...

Question 10

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

Accepted Answer

The answer of Each procedure that you create in Oracle...

Question 11

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

Accepted Answer

The answer of When you use a cursor,the ____________________ command...

Question 12

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

Accepted Answer

The answer of A(n)____________________ is a pointer to a row...

Question 13

What are the three advantages of cursors?

Accepted Answer

The answer of What are the three advantages of cursors?...

Question 14

Name two reasons for creating a stored procedure.

Accepted Answer

The answer of Name two reasons for creating a stored...

Question 15

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

Accepted Answer

The answer of To handle processing of errors,include a(n)____________________ clause...

Quiz 8: SQL Functions and Procedures