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 the 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.
Duplicate with Q25
A – you can create indexes, views, triggers on temporary tables, correct
B – you can use export and import tool to import the table definitions and data export, errors, data can not be exported.
C – a temporary table is placed in the user’s current user’s temporary table space.
D – Data in a temporary table is based on a session or a transaction, other sessions do NOT have access to it.
E – in a temporary table, DML locks never needed.
Temporary tables can be dedicated to the transaction, but also dedicated to the session. For transaction processing dedicated to temporary table, the data present in the duration of the transaction; for the session dedicated to the temporary table, the data exist during the session. In both cases, the insertion of data specific to the session session. Each session can only see and modify its own data. Therefore, the temporary table data obtained from DML locks are not possible.