Term
|
Definition
|
|
Term
|
Definition
| Defines the appearance of column headings and the format of the column data. |
|
|
Term
|
Definition
| Adds a header to the top of each report page |
|
|
Term
|
Definition
| Adds a footer to the bottom of each report page. |
|
|
Term
|
Definition
| Suppresses duplicated data for a specific column(s) when presented in a sorted order. |
|
|
Term
|
Definition
| Performs coluculations in a report based on the AVG, SUM, COUNT, MIN, or MAX statistical function. |
|
|
Term
|
Definition
| Redirects output to a text file |
|
|
Term
|
Definition
| Adds a column heading to a specified column |
|
|
Term
|
Definition
| Defines the width of columns and applies specific formats to columns containing numeric data. |
|
|
Term
|
Definition
| Indicates text to be substituted for NULL values in a specified column |
|
|
Term
|
Definition
| Specifies the symbol to be used to separate a colun heading from the contents of the column |
|
|
Term
|
Definition
| Establishes the maximum number of characters that can appear on a single line of output. |
|
|
Term
|
Definition
| Establishes the maximum number of lines that can appear on one page of output. |
|
|
Term
| What is the syntax for a column command? |
|
Definition
| COLUMN [columnname|columnalias] [option] |
|
|
Term
|
Definition
| What command(s) relaese row locks assigned to a table because of DML statements? |
|
|
Term
| INSERT, UPDATE, DELETE, MERGE |
|
Definition
| DML stands for Data Manipulation Language and includes 4 actions which are... |
|
|
Term
|
Definition
| A ____ transaction consists of a collection of DML statements that form a logical unit of work |
|
|
Term
|
Definition
| Transactions ensure ___ in the event of a user process failure or a system failure. |
|
|
Term
|
Definition
| What are the 3 different types of transactions? |
|
|
Term
commit or rollback
DDL statement
DCL statement
user exits or system fails |
|
Definition
| A database transaction begins with the first executable SQL statement, and ends with 1 or the following 4 event: |
|
|
Term
Savepoints prevent total loss of work already entered
rollback retores the data to a state before any changes were made so data changed can be restored
commit is an explicit end of a transaction and under the control of the user. |
|
Definition
| What are 3 advantages of using savepoints, commits, and rollbacks? |
|
|
Term
|
Definition
| What statement ends the current transaction by making all pending data changes permanent? |
|
|
Term
|
Definition
| What statement marks a point within the current transaction? |
|
|
Term
|
Definition
| What statement ends the current transaction by discaring all pending changes? |
|
|
Term
|
Definition
| An automatic commit occurs under what 3 circumstances? |
|
|
Term
|
Definition
| When does an automatic rollback occur? |
|
|
Term
|
Definition
| The rows that are affected by DML statements are ____ from other users. |
|
|
Term
|
Definition
| Other users ____ view the results of the DML statements by the current user. |
|
|
Term
|
Definition
| The current user ____ view the results of his/her DML statement by using the SELECT statement. |
|
|
