ExamQuestions.com

Register
Login
Oracle Database Administration I Exam Questions

Oracle

Oracle Database Administration I

24 / 52

Question 24:

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