Quiz for String Functions

Q1: Which function is used to concatenate strings in SQL?

A. LEN() B. JOIN() C. CONCAT() D. TRIM()

Q2: What does the SQL function LENGTH() return?

A. The number of characters in a string B. The number of bytes in a string C. The ASCII value of the string D. The first character of a string

Q3: Which function is used to combine two or more strings in SQL?

A. APPEND() B. CONCAT() C. MERGE() D. JOIN()

Q4: What is the output of LOWER('SQL')?

A. sql B. SQL C. Sql D. sQl

Q5: Which function is used to remove leading and trailing spaces?

A. REMOVE() B. STRIP() C. TRIM() D. DELETE()

Q6: What is the use of the UPPER() function?

A. Converts string to lowercase B. Removes spaces C. Converts string to uppercase D. Returns string length

Q7: What does the SUBSTRING() function do?

A. Deletes part of a string B. Replaces characters in a string C. Extracts part of a string D. Counts characters

Q8: Which function replaces a portion of a string with another string?

A. REPLACE() B. SWAP() C. CHANGE() D. UPDATE()

Q9: Which SQL function returns the position of a substring within a string?

A. FIND() B. POSITION() C. LOCATE() D. INDEX()

Q10: What is the output of REVERSE('SQL')?

A. QLS B. S L Q C. LQS D. LQS

Q11: What does the ASCII() function return?

A. Hexadecimal value of character B. Binary of character C. ASCII value of first character D. Character length

Q12: Which function is used to pad a string to a specified length?

A. PAD() B. LENGTH() C. LPAD() D. APPEND()

Q13: Which function capitalizes only the first letter of each word?

A. INITCAP() B. UPPER() C. TITLE() D. CAPITALIZE()

Q14: How many arguments does REPLACE() require?

A. 1 B. 2 C. 3 D. 4

Q15: What does CONCAT_WS() do?

A. Concatenates with space B. Concatenates with separator C. Concatenates with NULL D. Concatenates without spaces

Q16: Which function returns the number of bytes used by a string?

A. CHAR_LENGTH() B. OCTET_LENGTH() C. LENGTH() D. BYTE()

Q17: What is returned by LEFT('abcdef', 3)?

A. abc B. def C. cde D. fgh

Q18: Which function extracts characters from the right of a string?

A. LEFT() B. RIGHT() C. MID() D. SUBSTR()

Q19: Which SQL function can be used to repeat a string multiple times?

A. REPEAT() B. MULTI() C. DUPLICATE() D. EXPAND()

Q20: What is the result of CHAR(65)?

A. a B. B C. A D. 65

Q21: Which SQL function returns the Unicode code point of a character?

A. ORD() B. UNICODE() C. ASCII() D. CHAR()