Which two are true about global temporary tables?

Oracle 1z0-071 Question Answer

They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.

Backup and recovery operations are available for these tables.

If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.

Their data is always stored in the default temporary tablespace of the user who created them.

Indexes can be created on them.

If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.

1z0-071 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"