Question 1

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 2

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

Accepted Answer

A) CALL 
B) ​RUN 
C) DO 
D) ​EXEC

Question 3

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 4

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

Accepted Answer

The answer of A(n)____________________ language is one in which you...

Question 5

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 6

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

Accepted Answer

The answer of A(n)____________________ is a computer that is connected...

Question 7

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 8

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

Accepted Answer

A) TODAYS_DATE 
B) ​CURRENT_DATE 
C) NOWDATE 
D) ​SYSDATE

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) REGULAR 
B) ​LOWER 
C) SMALL​ 
D) ​LCASE

Question 14

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

Accepted Answer

A) Dim 
B) ​Decl 
C) Var 
D) ​Declare

Question 15

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

Accepted Answer

A) CREATE ROUTINE 
B) ​CREATE SCRIPT 
C) CREATE PROCEDURE 
D) ​CREATE EXECUTABLE

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) TODAYS_DATE 
B) GETDATE()​ 
C) CURRENTDATE() 
D) ​SYSDATE

Question 18

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.

Accepted Answer

A) RETRIEVE 
B) ​FETCH 
C) GET 
D) ​ADVANCE

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) 15 
B) ​30 
C) 45 
D) ​60

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.