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

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…

Question

Exhibit

Options

How the community answered

Community Discussion