Oracle Exam 1Z0-082 Topic 12 Question 79 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 79
Topic #: 12

Which two are true about shrinking a segment online? (Choose two.)

AIt is not possible to shrink either indexes or Index Organized Tables (IOTs)

BIt always eliminates all migrated rows if any exist in the table

CTo shrink a table it must have a PRIMARY KEY constraint

DTo shrink a table it must have a UNIQUE KEY constraint

ETo shrink a table it must have row movement enabled

FIt must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Show Suggested Answer

Suggested Answer: E, F

by Ahmed at Aug 29, 2023, 02:18 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!