Shared Flashcard Set

Details

Formatting
Formatting Readable Output
29
Other
Not Applicable
05/09/2005

Additional Other Flashcards

 


 

Cards

Term
Start or @
Definition
Executes a script file
Term
Column
Definition
Defines the appearance of column headings and the format of the column data.
Term
TTITLE
Definition
Adds a header to the top of each report page
Term
BTITLE
Definition
Adds a footer to the bottom of each report page.
Term
BREAK
Definition
Suppresses duplicated data for a specific column(s) when presented in a sorted order.
Term
COMPUTE
Definition
Performs coluculations in a report based on the AVG, SUM, COUNT, MIN, or MAX statistical function.
Term
SPOOL
Definition
Redirects output to a text file
Term
HEADING
Definition
Adds a column heading to a specified column
Term
FORMAT
Definition
Defines the width of columns and applies specific formats to columns containing numeric data.
Term
NULL
Definition
Indicates text to be substituted for NULL values in a specified column
Term
UNDERLINE
Definition
Specifies the symbol to be used to separate a colun heading from the contents of the column
Term
LINESIZE
Definition
Establishes the maximum number of characters that can appear on a single line of output.
Term
PAGESIZE
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
commit, rollback
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
database
Definition
A ____ transaction consists of a collection of DML statements that form a logical unit of work
Term
data consistency
Definition
Transactions ensure ___ in the event of a user process failure or a system failure.
Term
DML, DDL, DCL
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
Commit
Definition
What statement ends the current transaction by making all pending data changes permanent?
Term
savepoint
Definition
What statement marks a point within the current transaction?
Term
rollback
Definition
What statement ends the current transaction by discaring all pending changes?
Term
DDL, DCL, system crash
Definition
An automatic commit occurs under what 3 circumstances?
Term
When the system crashes
Definition
When does an automatic rollback occur?
Term
locked
Definition
The rows that are affected by DML statements are ____ from other users.
Term
do not
Definition
Other users ____ view the results of the DML statements by the current user.
Term
can
Definition
The current user ____ view the results of his/her DML statement by using the SELECT statement.
Supporting users have an ad free experience!