The two statements that are true about shrinking a segment online are:
E. To shrink a table it must have row movement enabled
F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
The other statements are false:
A. It is not possible to shrink either indexes or Index Organized Tables (IOTs) - It is possible to shrink indexes and IOTs, but it is more complex than shrinking a table.
B. It always eliminates all migrated rows if any exist in the table - Shrinking a segment does not always eliminate all migrated rows. Only migrated rows that are no longer referenced by any other rows will be eliminated.
C. To shrink a table it must have a PRIMARY KEY constraint - It is not necessary for a table to have a PRIMARY KEY constraint to be shrunk.
D. To shrink a table it must have a UNIQUE KEY constraint - It is not necessary for a table to have a UNIQUE KEY constraint to be shrunk.
This section is not available anymore. Please use the main Exam Page.1z0-082 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
you1234
Highly Voted 3 years, 12 months agoEkos
3 years, 6 months agoama
3 years, 12 months agoleozanon94
3 years agoLalala8
Most Recent 8 months, 4 weeks agoOracle2020
10 months, 1 week agoauwia
11 months, 3 weeks agoKuraudio
1 year, 6 months ago