Which three statements are correct about temporary tables? (Choose three.)
A.
Indexes and views can be created on temporary tables
B.
Both the data and structure of temporary tables can be exported
C.
Temporary tables are always created in a user’s temporary tablespace
D.
The data inserted into a temporary table in a session is available to other sessions
E.
Data Manipulation Language (DML) locks are never acquired on the data of temporary tables
Temporary tables are temporary buffered tables, by running multiple DMLs.
The definition of a temporary table is visible to all sessions, but the data in a temporary table is visible only to the session that inserts the data into the table.
Indexes can be created on temporary tables.
By default, temporary table rows are in the User’s default temp space, but you can assign a temp table to another tablespace, when creating the temp table.