Which of the following statement(s) is/are correct regarding single row functions in structured query language?
Which of the following statement(s) is/are correct regarding single row functions in structured query language?
I. INSERT() is a numeric function.
II. ROUND() is a numeric function.
III. LENGTH() is a character function.
Show answerHide answer
Correct answer: (B) Both II and III
Explanation
ROUND() is a numeric function and LENGTH() is a character function. INSERT() (e.g., in MySQL) is a string function, not a numeric one.