Exhibit： View the Exhibit and examine the properties of

多项选择题

Exhibit： 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 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

相关考题

多项选择题 YourdatabaseoperatesinARCHIVELOGmodeandallthetablespacesareonline.Duetoausererror，youdecidedtoperformanincompleterecovery.Whichtwotaskswouldyouberequiredtoperformintherecoveryprocess？（）

单项选择题 In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）

单项选择题 YounoticedthatlargememoryallocationsfortheOraclebackupandrestoreoperationsarecausingaperformanceoverheadonthesharedpool.Whichmemorystructurewouldyouconfiguretoavoidthisperformanceoverhead？（）

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064

1z0-043