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? (Choose all that apply.)

Question

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? (Choose all that apply.)

Accepted Answer

C. the TRANS table D. the B*Tree indexes on the TRANS table

Answer

A. the materialized views based on the TRANS table

Answer

B. the materialized views log of the TRANS table

Answer

E. the large object (LOB) segments of the TRANS table

1Z0-043 Question #176: Real Exam Question with Answer & Explanation

Question

Exhibit

Options

Community Discussion