Question 8 of 32beginner🔧 ApplyVery Short1 mark

Write the output produced by the following SQL statement: SELECT ROUND(342.9234,-1);

Correct Answer

340

Exercise: EXERCISE | Q: 2(b) | (Page 46)
For More Understanding

Explanation

The ROUND() function with a negative second argument rounds the number to the left of the decimal point. ROUND(342.9234, -1) rounds 342.9234 to the nearest 10. Since 342.9234 is closer to 340 than to 350, the output is 340.

Solution Steps

  1. Step 1: Identify the function ROUND(number, decimals) where decimals = -1

  2. Step 2: A negative value (-1) means round to the nearest 10 (1 position left of decimal)

  3. Step 3: 342.9234 rounded to nearest 10 = 340

PreviousNext