---

View the Exhibit and examine the properties of the USERS tablespace.  You execute the following statement to shrink the TRANS table existing on the USERS tablespace：  SQL> ALTER TABLE trans SHRINK SPACE CASCADE;  Which objects would be affected by this command？ （）
A:the TRANS table
B:the B*Tree indexes on the TRANS table
C:the materialized views log of the TRANS table
D:the materialized views based on the TRANS table
E:the large object （LOB） segments of the TRANS table

---

出自：Oracle认证

显示答案