Exam 8: SQL Functions and Procedures

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

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

To handle processing of errors,include an ABORT clause in a stored procedure.

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

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

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

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

In Oracle and SQL Server,the ____ function displays a value in lowercase letters.

The ADD_MONTHS function has one argument.

In Oracle,to add a specific number of months to a date,use the ____ function.​

In Microsoft Access,you must store an SQL command in a string variable.

DBMS_OUTPUT is a package that contains multiple procedures,including PUT_LINE.

The process of combining two or more character columns into a single expression is called ____________________.

A(n)____ is a procedure that is executed automatically in response to an associated database operation.

In Oracle and SQL Server,the ____ function displays a value in uppercase letters.