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 tableB.the B*Tree indexes on the TRANS tableC.the materialized views log of the TRANS tableD.the materialized views based on the TRANS tableE.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 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

相关考题

单项选择题 View the Exhibit and examine the properties of the TT tablespace. Using Database Control， you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5：00 p.m. every Friday. When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）

单项选择题 Youhavespecifiedthewarningandcriticalthresholdvaluesofanapplicationtablespacetobe60%and70%，respectively.Fromthetablespacespaceusagemetrics，youfindthattheactualspaceusagehasreachedthespecifiedwarningthresholdvalue，butnoalertshavebeengenerated.Whatcouldbethereasonforthis？（）

单项选择题 InanOracle10gdatabase，theinmemorystatisticsaregatheredatregularintervalsandusedtoperformgrowthtrendanalysisandcapacityplanningofthedatabase.Whichcomponentstoresthesestatistics？（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

1z0-043