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…
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #12. The question stem and answer options stay visible for context.
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
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#table compression#tablespace inheritance#primary key constraints#index validity