nerdexam
Oracle

1Z0-531 · Question #48

Which setting will give information about when a data block is calculated?

The correct answer is C. SET MSG DETAIL. The command SET MSG sets the level of messaging you want returned about calculations, and enables simulated calculations. SET MSG SUMMARY | DETAIL | ERROR | WARNS | INFO | NONE | ONLY; SET MSG DETAIL provides the same information as SUMMARY. In addition, it displays a detailed…

Calculations and Formulas

Question

Which setting will give information about when a data block is calculated?

Options

  • ASET MSG INFO;
  • BSET MSG SUMMARY;
  • CSET MSG DETAIL;
  • DSET MSG WARNING;

How the community answered

(51 responses)
  • A
    14% (7)
  • B
    8% (4)
  • C
    75% (38)
  • D
    4% (2)

Explanation

The command SET MSG sets the level of messaging you want returned about calculations, and enables simulated calculations. SET MSG SUMMARY | DETAIL | ERROR | WARNS | INFO | NONE | ONLY; SET MSG DETAIL provides the same information as SUMMARY. In addition, it displays a detailed information message every time Analytic Services calculates a data block.

Topics

#SET MSG DETAIL#calc script diagnostics#block calculation info#messaging settings

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice