Quiz on SQL String Functions

What does the CONCAT() function do in SQL?

What is returned by the query: SELECT LENGTH(‘SQL123’);?

What does SUBSTRING(‘DataFlair’, 5, 5) return?

Which function converts all characters to uppercase?

What is the output of SELECT LOWER(‘SQL QUIZ’);?

What does TRIM(‘ SQL ‘) do?

Which function removes characters from the right side of a string?

What is the result of REPLACE(‘data_flair’, ‘_’, ‘ ‘)?

Which function gives the position of a substring within a string?

What does REVERSE(‘SQL’) return?

How can you extract the last 3 characters from the string ‘DataFlair’?

Which function returns the number of bytes used by a string (not characters)?

What does CHAR_LENGTH(‘💻SQL’) return in most Unicode-aware DBs?

Which function removes characters only from the beginning of a string?

Which string function can be used to pad a string to a desired length?