Tag: databases

Secondary Index

First unique column in the table

Primary key

First non-unique coulmn in the table

Permanent Table

Set Table

Multiset Table

Volatile Table

Volatile Temporary Table

Global Temporary table

MultiSet Table

Permanent Table

Temporary Space

Spool Space

Permanent Space

Any of the above

Temporary Space

Spool Space

Permanent Space

Any of the above

Permanent Table and Stored Procedure

Permanent View and Stored Procedure

Macros and Stored Procedure

None of the above

Volatile Table

Global Temporary table

MultiSet Table

Permanent Table

Secondary Index

First unique column in the table

Primary key

First non-unique coulmn in the table

Volatile Temporary Table

Global Temporary table

MultiSet Table

Permanent Table

Temporary Space

Spool Space

Permanent Space

Any of the above