Oracle
1Z0-082 · Question #78
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
The correct answer is 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. You've hit your weekly limit · resets 5am (America/New_York)
Manage Storage
Question
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
Options
- APrivate Temporary Tables (PTTS) store metadata in memory only
- BAn index created with the UNUSABLE attribute has no segment
- CIf they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next
- DAn index that is altered to be UNUSABLE will retain its segment
- EA table that is truncated will always have its segment removed
How the community answered
(34 responses)- A3% (1)
- B76% (26)
- D6% (2)
- E15% (5)
Explanation
You've hit your weekly limit · resets 5am (America/New_York)
Topics
#Private Temporary Tables#unusable index#segment creation#space management
Community Discussion
No community discussion yet for this question.