Multiple choice technology databases

Which function is used to extract characters from a text field?

  1. len()

  2. MID()

  3. FORMAT()

  4. NOW()
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The MID() function in SQL extracts a substring from a text field, typically with parameters for the starting position and length. While syntax varies by database (SUBSTRING in standard SQL, SUBSTR in Oracle), MID() is the correct answer among the options provided. len() returns length, FORMAT() changes display format, and NOW() returns current timestamp.

Keep practicing — related questions