While creating a table Primary key is defined but not Primary Index, then this will be considered as Primary Index
Secondary Index
First unique column in the table
Primary key
First non-unique coulmn in the table
Statistics cannot be collected on this table
Permanent Table
Set Table
Multiset Table
Volatile Table
This temporary table will not be dropped once the session is signed off
Volatile Temporary Table
Global Temporary table
MultiSet Table
Volatile temporary table is materialized at
Temporary Space
Spool Space
Permanent Space
Any of the above
Intermediate results of the user query is materialized at
An USER cannot have these if Permanent space is not allocated to it
Permanent Table and Stored Procedure
Permanent View and Stored Procedure
Macros and Stored Procedure
None of the above
This table will have duplicate rows