SQL String Functions Basics Quiz

1. What does the UPPER() function do in SQL?

Converts text to uppercase letters

Removes spaces from text

Counts characters in text

Reverses the order of text

The UPPER() function in SQL transforms all lowercase letters in a string to their uppercase equivalents. This is useful for standardizing text data, ensuring consistency in comparisons, and making data more readable. It does not alter spaces, count characters, or reverse text order.

Explanation

The UPPER() function in SQL transforms all lowercase letters in a string to their uppercase equivalents. This is useful for standardizing text data, ensuring consistency in comparisons, and making data more readable. It does not alter spaces, count characters, or reverse text order.

2. Which function returns the number of characters in a string?

COUNT()

LENGTH()

SIZE()

CHARS()

LENGTH() is the function used in many programming languages and databases to determine the number of characters in a given string. It counts all characters, including spaces and punctuation, providing an accurate representation of the string's size. Other options like COUNT() and SIZE() do not specifically measure character count in strings.

Explanation

LENGTH() is the function used in many programming languages and databases to determine the number of characters in a given string. It counts all characters, including spaces and punctuation, providing an accurate representation of the string's size. Other options like COUNT() and SIZE() do not specifically measure character count in strings.

3. What is the result of LOWER('DATABASE')?

DATABASE

Database

DaTaBaSe

D-A-T-A-B-A-S-E

The LOWER function converts all uppercase letters in a string to their lowercase equivalents. In this case, applying LOWER to 'DATABASE' changes all the letters to lowercase, resulting in 'database'.

Explanation

The LOWER function converts all uppercase letters in a string to their lowercase equivalents. In this case, applying LOWER to 'DATABASE' changes all the letters to lowercase, resulting in 'database'.

4. The SUBSTRING() function extracts ______ from a string.

The SUBSTRING() function is used in programming and database queries to retrieve a specific portion of a string. By specifying the starting position and the length, it extracts a sequence of characters, allowing for manipulation and analysis of text data. This functionality is essential for tasks such as data formatting and parsing.

Explanation

The SUBSTRING() function is used in programming and database queries to retrieve a specific portion of a string. By specifying the starting position and the length, it extracts a sequence of characters, allowing for manipulation and analysis of text data. This functionality is essential for tasks such as data formatting and parsing.

Submit

5. Which function combines two or more strings together?

MERGE()

JOIN()

CONCAT()

COMBINE()

CONCAT() is a function used in various programming and database languages to concatenate, or join, two or more strings into a single string. It takes multiple string inputs and merges them without any additional characters, making it a straightforward choice for combining text.

Explanation

CONCAT() is a function used in various programming and database languages to concatenate, or join, two or more strings into a single string. It takes multiple string inputs and merges them without any additional characters, making it a straightforward choice for combining text.

6. What does TRIM() remove from a string?

All vowels

Leading and trailing spaces

Duplicate characters

Numbers only

TRIM() is a function used in programming and databases to eliminate unwanted spaces from the beginning and end of a string. This ensures that the string is clean and formatted correctly, making it easier to work with in various applications, such as user input validation and data processing.

Explanation

TRIM() is a function used in programming and databases to eliminate unwanted spaces from the beginning and end of a string. This ensures that the string is clean and formatted correctly, making it easier to work with in various applications, such as user input validation and data processing.

7. SELECT LENGTH('HELLO') returns ______ .

The LENGTH function in SQL calculates the number of characters in a given string. In this case, 'HELLO' consists of five characters: H, E, L, L, and O. Therefore, when executing SELECT LENGTH('HELLO'), it returns 5, indicating the total character count.

Explanation

The LENGTH function in SQL calculates the number of characters in a given string. In this case, 'HELLO' consists of five characters: H, E, L, L, and O. Therefore, when executing SELECT LENGTH('HELLO'), it returns 5, indicating the total character count.

Submit

8. The REPLACE() function substitutes ______ characters with new ones.

The REPLACE() function is designed to search for specific characters or substrings within a given text and replace them with new characters or substrings. In this context, "old" refers to the original characters being replaced, highlighting the function's role in text manipulation by substituting outdated or unwanted elements with updated ones.

Explanation

The REPLACE() function is designed to search for specific characters or substrings within a given text and replace them with new characters or substrings. In this context, "old" refers to the original characters being replaced, highlighting the function's role in text manipulation by substituting outdated or unwanted elements with updated ones.

Submit

9. Which statement correctly uses CONCAT to join 'Hello' and 'World'?

SELECT CONCAT('Hello', 'World');

SELECT JOIN('Hello', 'World');

SELECT MERGE('Hello', 'World');

SELECT COMBINE('Hello', 'World');

CONCAT is a standard SQL function used to concatenate two or more strings. In this case, SELECT CONCAT('Hello', 'World') correctly combines the two strings into one, resulting in 'HelloWorld'. The other options use incorrect functions that do not exist in SQL, making them invalid.

Explanation

CONCAT is a standard SQL function used to concatenate two or more strings. In this case, SELECT CONCAT('Hello', 'World') correctly combines the two strings into one, resulting in 'HelloWorld'. The other options use incorrect functions that do not exist in SQL, making them invalid.

10. SUBSTRING('DATABASE', 1, 4) returns ______ .

The SUBSTRING function extracts a portion of a string based on specified starting position and length. In this case, it starts at position 1 of the string 'DATABASE' and retrieves 4 characters, resulting in 'DATA'.

Explanation

The SUBSTRING function extracts a portion of a string based on specified starting position and length. In this case, it starts at position 1 of the string 'DATABASE' and retrieves 4 characters, resulting in 'DATA'.

Submit

11. The INSTR() function finds the ______ of a character in a string.

The INSTR() function is used in programming to determine the specific location or index of a given character within a string. By returning the position, it allows users to identify where the character first appears, enabling further manipulation or analysis of the string based on that information.

Explanation

The INSTR() function is used in programming to determine the specific location or index of a given character within a string. By returning the position, it allows users to identify where the character first appears, enabling further manipulation or analysis of the string based on that information.

Submit

12. True or False: UPPER() and LOWER() modify the original data in the table.

True

False

UPPER() and LOWER() are functions used to transform text data to uppercase or lowercase, respectively. However, these functions do not alter the original data stored in the database; they only return a modified version of the data for display or processing purposes. Therefore, the original data remains unchanged.

Explanation

UPPER() and LOWER() are functions used to transform text data to uppercase or lowercase, respectively. However, these functions do not alter the original data stored in the database; they only return a modified version of the data for display or processing purposes. Therefore, the original data remains unchanged.