Exam 8: SQL Functions and Procedures

When you need to complete tasks that are beyond the capabilities of SQL,you need to use a procedural language.

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

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

In Oracle,SQL Server,and Microsoft Access,use the ____ function to round a numeric value to a desired number of decimal places.

In PL/SQL,you can ensure that a variable has the same data type as a particular column by using the ____ attribute.

PL/SQL,which was developed by Oracle as an extension of SQL,is an example of a procedural language.

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

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

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

A client is a computer that is connected to a network and has access through the server to the database.

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

PL/SQL commands have a certain format and cannot include any blank lines in the code.

You use aggregate functions to perform calculations based on groups of records.

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

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.

In T-SQL,arguments should have the same data type and length as the particular column in a table that they represent.

Name two reasons for creating a stored procedure.

To add a specific number of days to a date,you must use a function.

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