PrepAway - Latest Free Exam Questions & Answers

What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to popul

What happens when the STATISTICS USE PROFILE option is provided with a LOAD command
that will be used to populate a column-organized table and a statistics profile does not exist?

PrepAway - Latest Free Exam Questions & Answers

A.
A warning is returned and no statistics are collected.

B.
An error is returned and the table is placed in “load pending” state.

C.
A statistics profile is automatically generated before the load is allowed to continue.

D.
The Load utility uses the same RUNSTATS command options as those used during an
automatic runstats operation.


Leave a Reply