String Functions Quiz

Which function concatenates (combines) two or more strings into a single string?

• JOIN()

• CONCAT()

• MERGE()

• APPEND()

What does the LENGTH() function return?

• The number of words in a string.

• The number of characters in a string.

• The position of a substring within a string.

• The length of the longest word in a string.

Which function converts all characters in a string to lowercase?

• LOWERCASE()

• TO_LOWER()

• LOWER()

• SMALLER()

How do you extract a portion of a string starting at the 5th character and taking 3 characters?

• SUBSTRING(string, 5, 3)

• EXTRACT(string, 5, 3)

• CUT(string, 5, 3)

• PART(string, 5, 3)

What does the INSTR() function return?

• The length of a substring.

• The position of the first occurrence of a substring within a string.

• The number of occurrences of a substring within a string.

• The last occurrence of a substring within a string.

Which function removes leading and trailing spaces from a string?

• CLEAN()

• TRIM()

• REMOVE()

• STRIP()

How do you replace all occurrences of "example.com" with "newdomain.com" in a string?

• REPLACE(string, "example.com", "newdomain.com")

• SUBSTITUTE(string, "example.com", "newdomain.com")

• SWAP(string, "example.com", "newdomain.com")

• CHANGE(string, "example.com", "newdomain.com")

What does the REVERSE() function do?

• Reverses the order of words in a string.

• Reverses the order of characters in a string.

• Converts a string to uppercase.

• Converts a string to lowercase.

Which function pads a string with another string on the left?

• LPAD()

• RPAD()

• LEFTPAD()

• RIGHTPAD()

How do you return the first 5 characters from the left side of a string?

• LEFT(string, 5)

• RIGHT(string, 5)

• SUBSTRING(string, 1, 5)

• Both a) and c)