Choose all the correct options

Question

examine this command: which three statements are true about the effect of this command? (choose three.)

Accepted Answer

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

Accepted Answer

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

Accepted Answer

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

Answer

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

Answer

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

Examine this command: