Match the following SQL functions to their descriptions.
|
Functions |
Descriptions |
||
|
A. |
length() |
I. |
Finds the position of a substring within a string. |
|
B. |
lower() |
II. |
Converts all characters in a string to lowercase. |
|
C. |
concat() |
III. |
Concatenates two or more strings into one string. |
|
D. |
position() |
IV. |
Returns the number of characters in a string. |
Choose the correct answer from the options given below:
1
A - IV, B - II, C - III, D - I
2
A - III, B - I, C - II, D - IV
3
A - I, B - IV, C - II, D - III
4
A - II, B - IV, C - I, D - III