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.