Mathematical and String Functions Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering SQL Language for NoSQL API

What you'll be asked

  1. Which SQL function is used to return the length of a string in a NoSQL API query?
  2. If you need to round the value 15.768 to two decimal places, which function should you use?
  3. Which function would you use to extract a specific portion of a string starting from a defined position?
  4. What is the result of the expression ABS(-10.5) + CEIL(2.1)?
  5. You have a field 'product_code' containing values like 'A-123', 'B-456'. You want to find the index position of the hyphen character. Which function is most appropriate?

Answers and explanations come after you submit.