Oracle
1Z0-074 · Question #12
U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low. You execute commands: Which three statements are…
The correct answer is A. The primary key constraints on T1 are dropped C. T1 is in the TBS_CMP tablespace E. T1 is in uncompressed format. Explanation/Reference:
Managing Schema Objects
Question
U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low. You execute commands:
Which three statements are true? (Choose three.)
Exhibit
Options
- AThe primary key constraints on T1 are dropped
- BT1 is in the TBS_UNCMP tablespace
- CT1 is in the TBS_CMP tablespace
- DT1 is in compressed format
- ET1 is in uncompressed format
- FAll indexes on T1 remain valid
How the community answered
(28 responses)- A82% (23)
- B7% (2)
- D4% (1)
- F7% (2)
Explanation
Explanation/Reference:
Topics
#table compression#tablespace inheritance#primary key constraints#index validity
Community Discussion
No community discussion yet for this question.