多项选择题
A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
单项选择题 WhendoesOracle9iflaganindexasbeingusedintheV$OBJECT_USAGEview?()
多项选择题 Whichtwoaretrueregardingexternaltables?()
单项选择题 Consider the following statement: SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (- 2> ownname => ‘OE’, - 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, - 4> method opt => ‘for all columns size AUTO’); What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option?()