Which objects would be affected by this command?

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.)

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.)

A.
the materialized views based on the TRANS table

B.
the materialized views log of the TRANS table

C.
the TRANS table

D.
the B*Tree indexes on the TRANS table

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *