Export Transform Load

Extract Track Load

Extract Tool Load

Extract Transform Load

True

False

by global variables

by setting package configurations in child package

by setting package configurations in parent package

by Execute Package task

Logical

Extended Logical

Physical

Extended Physical

True

False

Maximum Number of NULLs

Access Frequency

Change Rating

Typical Rows Per Value

They don't have to be a Primary Index column

They are not allowed to be a Primary Index column.

They are required to be a Non-Unique Primary Index

You can only specify one Identity Column per table.

The buckets containing the AMP numbers where the data is stored.

The USI column value

The Row ID of the base row.

The Secondary Index Row ID.

The Integer Type of all Value-Ordered NUSIs.

They eliminate Full Table Scans.

Duplicate row checks are avoided.

There is no overhead involved.

They are best used for range queries.

You cannot insert rows with a duplicate USI value.

True

False

All columns required by the query are available via the Primary index.

All columns required by the query are available via a Join Index.

All columns required by the query are available via the Hash Index

The PE covers the query by looking into cache to see if the same query has been run in the last 240 minutes. If it has been cached the PE doesn't have to generate steps for the AMPs.

Join Indexes have repeating values.

Join Indexes do not have repeating values.

Join Indexes are updated automatically when their underlying rows change

Join Indexes are not updated automatically when their underlying rows change.

Downtime

Stability

Performance

Volatility

True

False

BETWEEN

IN

HAVING

ALIAS

each SELECT statement within the UNION has the same number of columns

The columns have similar data types

the columns in each SELECT statement are in same order.

None

MAX( )

MID( )

SUM( )

NOW( )

True

False

True

False

INIT call gets the database availability status

It is not advisable to use GOBACK for ending an IMS COBOL program

If the SSA contains only the segment name, byte 9 must contain a blank

Basic checkpoint calls do not support GSAM files