Oracle Database Administration I — Question 2

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

Answer options

• A. Private Temporary Tables (PTTS) store metadata in memory only
• B. An index created with the UNUSABLE attribute has no segment
• C. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
• D. An index that is altered to be UNUSABLE will retain its segment
• E. A table that is truncated will always have its segment removed

Correct answer: A, B

Explanation

Option A is correct because Private Temporary Tables (PTTs) indeed store metadata only in memory, enhancing performance. Option B is also correct since an index marked as UNUSABLE does not have a segment associated with it, meaning it does not consume space. Options C, D, and E are incorrect as they describe incorrect behaviors regarding the lifecycle of Private Temporary Tables and the properties of indexes.