Test Your MySQL String Functions Knowledge with This Quiz

Progress

True / False

MySQL's CONCAT function can concatenate more than two strings.

True False

The CONCAT function in MySQL can concatenate multiple strings, not limited to just two.

True / False

The LOWER function in MySQL converts a string to uppercase.

True False

The LOWER function converts a string to lowercase. The function to convert a string to uppercase is UPPER.

True / False

In MySQL, LENGTH function returns the length of a string in characters.

True False

The LENGTH function returns the number of characters in a string.

True / False

MySQL's TRIM function can remove specified characters from both ends of a string.

True False

The TRIM function can remove specified leading and trailing characters from a string.

True / False

The INSTR function in MySQL is case-sensitive when searching for a substring within a string.

True False

The INSTR function is case-sensitive. For case-insensitive searches, the LOCATE function can be used.

True / False

In MySQL, the RPAD function adds characters to the right side of a string until it reaches a specified length.

True False

The RPAD function pads the right side of a string with specified characters to reach a certain length.

True / False

The CHAR_LENGTH function in MySQL returns the number of bytes in a string.

True False

The CHAR_LENGTH function returns the number of characters in a string, not bytes. The LENGTH function returns the number of bytes.

True / False

MySQL's SUBSTRING_INDEX function can be used to extract a substring from a string, based on a delimiter.

True False

The SUBSTRING_INDEX function extracts a substring from a string before a specified number of occurrences of a delimiter.

True / False

In MySQL, the REPLACE function can replace all occurrences of a substring within a string.

True False

The REPLACE function replaces all occurrences of a specified substring with another substring within a string.

Q10

True / False

The REGEXP operator in MySQL can be used for case-insensitive pattern matching by default.

True False

By default, the REGEXP operator in MySQL is case-sensitive. To perform case-insensitive pattern matching, the REGEXP BINARY operator or a case-insensitive collation can be used.

Q11

Single Choice

Which MySQL function is used to return the length of a string?

CHAR_LENGTH() STRING_LENGTH() LEN()LENGTH()

The LENGTH() function returns the number of characters in a string. For example, LENGTH('MySQL') returns 5.

Q12

Single Choice

How do you convert a string to uppercase in MySQL?

UPPERCASE() TO_UPPER() UPPER()CAPITALIZE()

The UPPER() function converts all characters in a string to uppercase. For example, UPPER('hello') returns 'HELLO

Q13

Single Choice

Which function in MySQL is used to extract a substring from a string?

SUBSTR() GET_SUBSTR() STRING_PART()SUBSTRING()

The SUBSTRING() function extracts a substring from a string. For example, SUBSTRING('MySQL', 1, 2) returns 'My'.

Q14

Single Choice

Given the SQL query SELECT LEFT('Hello World', 5);, what is the output?

Hel Hello Hello WorldWorld

The LEFT() function returns the first N characters from a string, where N is specified. In this case, it returns the first 5 characters of 'Hello World'.

Q15

Single Choice

What does the SUBSTRING_INDEX() function do?

Returns a substring from the start of a string Returns a substring from the end of a string Returns a substring before a specified delimiterReplaces a substring with another string

The SUBSTRING_INDEX() function returns a substring from a string before a specified number of occurrences of a delimiter.

Q16

Single Choice

How do you replace occurrences of 'old' with 'new' in a string using MySQL?

REPLACE() SUBSTITUTE() CHANGE()SWAP()

The REPLACE() function in MySQL replaces all occurrences of a substring within a string with another substring.

Q17

Single Choice

Given the query SELECT REPEAT('Hi!', 3);, what is the result?

Hi!Hi!Hi! Hi Hi Hi Hi! Hi!Hi!Hi!Hi! Hi!

The REPEAT() function repeats a string a specified number of times. Here, 'Hi!' is repeated 3 times

Q18

Single Choice

How can you extract the last 3 characters from the string 'abcdef' in MySQL?

RIGHT('abcdef', 3) SUBSTRING('abcdef', -3) LEFT('abcdef', 3)MID('abcdef', -3, 3)

The RIGHT() function extracts the last N characters from a string. In this case, it extracts the last 3 characters of 'abcdef'.

Q19

Single Choice

Which MySQL function would you use to find the position of the first occurrence of 'X' in the string 'Hello World'?

LOCATE() POSITION() INSTR()SEARCH()

The LOCATE() function returns the position of the first occurrence of a substring within a string. INSTR() is also valid but LOCATE() is commonly used.

Q20

Single Choice

Which function returns the part of the string starting from the 4th character up to the end in MySQL?

MID('abcdefgh', 4) SUBSTRING('abcdefgh', 4) RIGHT('abcdefgh', LENGTH('abcdefgh') - 3)SUBSTR('abcdefgh', 4)

The SUBSTRING() function extracts a portion of a string starting from a specified position. If the length is not specified, it returns from the start position to the end of the string.

Q21

Multiple Choice

Which SQL query uses the CONCAT() function to concatenate first name and last name into a full name?

SQL Code

SELECT CONCAT(first_name, ' ', last_name) AS full_name
FROM employees;

SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees; SELECT CONCAT_WS(' ', first_name, last_name) AS full_name FROM employees; SELECT CONCAT(first_name, last_name) AS full_name FROM employees;SELECT CONCAT(first_name, '-', last_name) AS full_name FROM employees;

The CONCAT() function is used to concatenate two or more strings into a single string, separated by the specified delimiter.

Q22

Multiple Choice

Identify the SQL query that uses the SUBSTRING() function to extract the first 3 characters of the product name.

SQL Code

SELECT SUBSTRING(product_name, 1, 3) AS short_name
FROM products;

SELECT SUBSTRING(product_name, 1, 3) AS short_name FROM products; SELECT LEFT(product_name, 3) AS short_name FROM products; SELECT SUBSTRING(product_name, 0, 3) AS short_name FROM products;SELECT MID(product_name, 1, 3) AS short_name FROM products;

The SUBSTRING() function is used to extract a part of a string, starting from a specified position for a specified length.

Q23

Multiple Choice

Which SQL query uses the REPLACE() function to replace spaces in product names with underscores?

SQL Code

SELECT REPLACE(product_name, ' ', '_') AS modified_name
FROM products;

SELECT REPLACE(product_name, ' ', '_') AS modified_name FROM products; SELECT REPLACE(product_name, '_', ' ') AS modified_name FROM products; SELECT REPLACE(product_name, ' ', '-') AS modified_name FROM products;SELECT REPLACE(product_name, '-', '_') AS modified_name FROM products;

The REPLACE() function is used to replace all occurrences of a specified substring within a string with another substring.

Q24

Multiple Choice

Determine the SQL query that uses the LOWER() function to convert product names to lowercase.

SQL Code

SELECT LOWER(product_name) AS lowercase_name
FROM products;

SELECT LOWER(product_name) AS lowercase_name FROM products; SELECT LCASE(product_name) AS lowercase_name FROM products; SELECT LOWERCASE(product_name) AS lowercase_name FROM products;SELECT LOWER(product_name) AS lowercase_name FROM products WHERE product_name LIKE 'A%';

The LOWER() function is used to convert all characters in a string to lowercase.

Q25

Multiple Choice

Which SQL query uses the UPPER() function to convert customer names to uppercase?

SQL Code

SELECT UPPER(customer_name) AS uppercase_name
FROM customers;

SELECT UPPER(customer_name) AS uppercase_name FROM customers; SELECT UCASE(customer_name) AS uppercase_name FROM customers; SELECT UPPERCASE(customer_name) AS uppercase_name FROM customers;SELECT UPPER(customer_name) AS uppercase_name FROM customers WHERE customer_name LIKE 'J%';

The UPPER() function is used to convert all characters in a string to uppercase.

Q26

Multiple Choice

Which SQL query uses the LENGTH() function to find the length of the product names?

SQL Code

SELECT product_name, LENGTH(product_name) AS name_length
FROM products;

SELECT product_name, LENGTH(product_name) AS name_length FROM products; SELECT product_name, CHAR_LENGTH(product_name) AS name_length FROM products; SELECT product_name, LEN(product_name) AS name_length FROM products;SELECT product_name, LENGTH(product_name) AS name_length FROM products WHERE LENGTH(product_name) > 10;

The LENGTH() function returns the number of characters in a string.

Q27

Multiple Choice

Identify the SQL query that uses the INSTR() function to find the position of the first occurrence of 'a' in the product name.

SQL Code

SELECT product_name, INSTR(product_name, 'a') AS position
FROM products;

SELECT product_name, INSTR(product_name, 'a') AS position FROM products; SELECT product_name, POSITION('a' IN product_name) AS position FROM products; SELECT product_name, LOCATE('a', product_name) AS position FROM products;SELECT product_name, FIND_IN_SET('a', product_name) AS position FROM products;

The INSTR() function returns the position of the first occurrence of a substring within a string.

Q28

Multiple Choice

Which SQL query uses the TRIM() function to remove leading and trailing spaces from product names?

SQL Code

SELECT TRIM(product_name) AS trimmed_name
FROM products;

SELECT TRIM(product_name) AS trimmed_name FROM products; SELECT TRIM(BOTH ' ' FROM product_name) AS trimmed_name FROM products; SELECT TRIM(LEADING ' ' FROM product_name) AS trimmed_name FROM products;SELECT TRIM(TRAILING ' ' FROM product_name) AS trimmed_name FROM products;

The TRIM() function removes all specified leading and trailing characters (by default, spaces) from a string.

Q29

Multiple Choice

Determine the SQL query that uses the LPAD() function to left-pad product names with asterisks (*) to a total length of 10 characters.

SQL Code

SELECT LPAD(product_name, 10, '*') AS padded_name
FROM products;

SELECT LPAD(product_name, 10, '*') AS padded_name FROM products; SELECT RPAD(product_name, 10, '*') AS padded_name FROM products; SELECT LPAD(product_name, 10, '-') AS padded_name FROM products;SELECT LPAD(product_name, 8, '*') AS padded_name FROM products;

The LPAD() function left-pads a string with another string (repeatedly, if needed) until the string reaches the specified length.

Q30

Multiple Choice

Which SQL query uses the REVERSE() function to reverse the characters in the customer name?

SQL Code

SELECT REVERSE(customer_name) AS reversed_name
FROM customers;

SELECT REVERSE(customer_name) AS reversed_name FROM customers; SELECT REVERSE(product_name) AS reversed_name FROM customers; SELECT REVERSE(customer_name) AS reversed_name FROM customers WHERE LENGTH(customer_name) > 5;SELECT REVERSE(customer_name) AS reversed_name FROM customers WHERE customer_name LIKE 'A%';

The REVERSE() function returns the reverse order of characters in a string.

MySQL Database Quiz Questions