Tag Archives: spacesaving

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

Which two statements are true about space-saving features in an Oracle Database? (Choose two.) A. A table that is truncated will always have its segment removed 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… Read More »

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

Which two statements are true about space-saving features in an Oracle Database? (Choose two.) A. Private Temporary Tables (PTTS) store metadata in memory only B. An index that is altered to be UNUSABLE will retain its segment C. A table that is truncated will always have its segment removed D. If they exist for a session, Private Temporary… Read More »