Which three statements are correct about temporary tables?

Which three statements are correct about temporary tables? (Choose three.)

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


chu

chu

The answer is:
A.
Indexes and views can be created on temporary tables

C.
Temporary tables are always created in a user’s temporary tablespace

E.
Data Manipulation Language (DML) locks are never acquired on the data of temporary
tables