问题

Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’ ‘CUSTOMERS’ ‘PUBLISH’ ‘false’);Which three statements are true about the effect of this command?()

Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS （‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command？()

A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

参考答案

您可能感兴趣的试题

（)类文件不易被感染上病毒A.COMB.EXEC.TXTD.BOOT

答案解析
不属于常见的文本格式有（)A、TXTB、EXEC、DOCD、WPS

答案解析
existA. experience B. examine C. excite D. explode

答案解析
existA. experience B. examine C. excite D. explode

答案解析
You may examine whether air is leaking from the t

答案解析
Examine the data in the EMPLOYEES table:Which three subqueries work? ()

答案解析

Examine this command:SQL &gt; exec DBMS_STATS.SET_TABLE_PREFS (‘SH’ ‘CUSTOMERS’ ‘PUBLISH’ ‘false’);Which three statements are true about the effect of this command?()

Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’ ‘CUSTOMERS’ ‘PUBLISH’ ‘false’);Which three statements are true about the effect of this command?()