Examine this statement and output: Now, examine these desired output values: Which statement updates the table data as require

Question

Exhibit

Options

• AUPDATE exam_result SET score=TRUNCATE
• BUPDATE examresult SET score=ROUND(CEIL(score
• CUPDATE exam_result SET score=CEIL(TRUNCATE(sco
• DUPDATE exam_result SET score=CEIL(ROUND(score,1));
• EUPDATE exam_result SET score=ROUND(score,1);
• FUPDATE exam_result SET score=TRUNCATE(score,1);

• A
  3% (1)
• C
  11% (4)
• D
  3% (1)
• E
  83% (29)

Explanation

ROUND(score, 1) performs standard mathematical rounding to one decimal place (e.g., 3.76 → 3.8), which matches the desired output values shown in the question.

Why the distractors fail:

• A - TRUNCATE is written without arguments, making it syntactically invalid.
• B - Uses the wrong table name (examresult instead of exam_result) and has incomplete/unclosed syntax.
• C - Incomplete syntax (sco is truncated), and nesting CEIL around TRUNCATE would produce incorrect integer-biased results.
• D - CEIL(ROUND(score,1)) first rounds to one decimal, then CEIL forces it up to the nearest whole integer, destroying decimal precision entirely.
• F - TRUNCATE(score, 1) simply chops off digits after the first decimal without rounding (e.g., 3.76 → 3.7, not 3.8), producing values that differ from the expected output.

Memory tip: Think of ROUND as a fair judge (goes up or down based on the next digit) and TRUNCATE as a harsh cutter (always drops what follows). When exam output shows values like 3.8 from 3.76, "fair rounding" is required - reach for ROUND.

No community discussion yet for this question.