Question 1

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 2

You can use a stored procedure to update data but not to delete data.

Accepted Answer

A) True 
 B)False

Question 3

You can embed SQL commands in Access programs similarly to the way you can in PL/SQL and T-SQL.

Accepted Answer

A) True 
 B)False

Question 4

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,...

Question 5

SQL Server uses an extended version of SQL called T-SQL or Transact-SQL.

Accepted Answer

A) True 
 B)False

Question 6

In SQL Server and Microsoft Access, to add a specific number of months to a date, use the ____ function.

Accepted Answer

A)  MONTHS 
B)  DATEADD() 
C)  ADD_MONTHS 
D)  CALC_MONTHS

Question 7

To truncate (remove) everything to the right of the decimal point, use the TRUNCATE function.

Accepted Answer

A) True 
 B)False

Question 8

Oracle uses ____________________ as an extension of SQL to accomplish procedural tasks.

Accepted Answer

The answer of Oracle uses ____________________ as an extension of...

Question 9

To concatenate columns in Oracle, you type two ____________________ between the column names.

Accepted Answer

The answer of To concatenate columns in Oracle, you type...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

A function can have more than one argument.

Accepted Answer

A) True 
 B)False

Question 12

SQL is a powerful ____________________ language in which you communicate tasks to the computer using simple commands.

Accepted Answer

The answer of SQL is a powerful ____________________ language in...

Question 13

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

Accepted Answer

The answer of In SQL Server, you deactivate a cursor...

Question 14

You cannot use functions in WHERE clauses.

Accepted Answer

A) True 
 B)False

Question 15

In SQL Server, the INSERTED table is a temporary system table that contains a copy of the values that the last SQL command inserted.

Accepted Answer

A) True 
 B)False

Exam 8: SQL Functions and Procedures

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.

You can use a stored procedure to update data but not to delete data.

You can embed SQL commands in Access programs similarly to the way you can in PL/SQL and T-SQL.

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.

SQL Server uses an extended version of SQL called T-SQL or Transact-SQL.

In SQL Server and Microsoft Access, to add a specific number of months to a date, use the ____ function.

To truncate (remove) everything to the right of the decimal point, use the TRUNCATE function.

Oracle uses ____________________ as an extension of SQL to accomplish procedural tasks.

To concatenate columns in Oracle, you type two ____________________ between the column names.

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

A function can have more than one argument.

SQL is a powerful ____________________ language in which you communicate tasks to the computer using simple commands.

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

You cannot use functions in WHERE clauses.

In SQL Server, the INSERTED table is a temporary system table that contains a copy of the values that the last SQL command inserted.