Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 20 of 81

MySQL Functions — Question 2

Back to all questions
2
Question

Question 2

Which of the following is not a text function ?

  1. TRIM()
  2. TRUNCATE()
  3. LEFT()
  4. MID()
Answer

TRUNCATE()

Reason — TRUNCATE() is a numeric function that returns a number with some digits truncated, whereas TRIM(), LEFT(), and MID() are text functions.