Which two statements are true about space-saving features in an Oracle Database?

Oracle 1z0-082 Question Answer

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

Private Temporary Tables (PTTS) store metadata in memory only

An index created with the UNUSABLE attribute has no segment

If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

An index that is altered to be UNUSABLE will retain its segment

A table that is truncated will always have its segment removed

1z0-082 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"