ALTER SESSION SET NEW_DATE_FORMAT =

ALTER SESSION SET CUR_DATE_FORMAT =

ALTER SESSION SET NLS_DATE_FORMAT =

ALTER SESSION SET SESS_DATE_FORMAT =

32767

1024

255

32765

10000000

1000000

100000

1000

TO_CHAR, INOUT

PROC, PACKAGE

PRAGMA, MULTI_ROW

SELECT, EXCEPTION

SET AUTOTRACE TRACEONLY

SET AUTOTRACE ON

SET AUTOTRACE ON STATISTICS

SET AUTOTRACE ON EXPLAIN

Comment marker

Not equal to operator

Label delimiter

Greater than or equal to operator

RAISE_APPLICATION_ERROR(-21001);

RAISE_APPLICATION_ERROR(-20001,'An error has occurred');

RAISE_APPLICATION_ERROR(-21001,'An error has occurred');

RAISE_APPLICATION_ERROR(-20001);

SQL%ROWCOUNT

SQL%COUNT

SQL%FOUND

SQL%NUM_ROWS

Disk space associated with an AMP is divided into three areas: system, permanent and spool

Parallelism is achieved through operating system time slicing

The AMP’s access data from their associated vdisks as required.

The PE’s communicate with the AMP’s across the BYNET

Teradata SQL Assistant

BTEQ

Teradata Manager

TDQM

Temporary space is spool space currently not used

Temporary space is permanent space currently not used.

Temporary space is subtracted from SysAdmin

Temporary space is assigned at the table level.

Customer applications drive the processes.

Relational databases are more flexible than other types.

Businesses are able to quickly respond to changing conditions

It is built to reflect business application models.

A primary Index is a physical mechanism.

There is a limit to the number of columns in a Primary Index.

A Primary Index requires uniqueness

A Primary Index value can not be null.

The order of rows in a table is arbitrary

A table can contain only one row formats

The order of rows in a table is keyed to Primary Index.

A table can contain multiple row formats

Shared everything

Shared memory

Shared nothing

Shared data

A row is one instance of all columns.

Row sequence is specified.

Duplicate rows are allowed in a table.

Rows can have different formats.

Transactions are write intensive

The number rows per transaction is large

Transactions typically occur within seconds, not minutes

The number of rows per transaction is small

A NUPI requires less disk space to store the data row.

A NUPI may be more effective for query access and joins.

A NUPI query amplifies the optimization process in the PE.

A NUPI provides better data distribution

BTEQ

Teradata SQL Assistant

Teradata Manager

TDQM

Tpump

BulKLoad

FastLoad

MultiLoad