Data Analytics Intership Quiz-9

What function is used to concatenate two strings in SQL?

• CONCAT

• JOIN

• MERGE

• ADD

What is the purpose of the INSTR function in SQL?

• Returns the position of the first occurrence of a substring in a string

• Increments the value of a numeric column

• Checks if a string is NULL

• Returns the intersection of two sets

Which function is used to replace occurrences of a specified string with another string in SQL?

• SWAP

• CHANGE

• REPLACE

• SUBSTITUTE

What is the role of the LOWER function in SQL?

• Converts a string to lowercase

• Finds the lowest value in a column

• Extracts the leftmost characters from a string

• Reverses the order of characters in a string

Which SQL operator is used for pattern matching in strings?

• LIKE

• MATCH

• FIND

• SEARCH

What is the purpose of the SUBSTRING function in SQL?

• Extracts a substring from a string

• Converts a string to uppercase

• Finds the position of a substring in a string

• Removes leading and trailing spaces

Which SQL function is used to find the length of a string?

• LEN

• LENGTH

• CHAR_LENGTH

• STRLEN

What does the TRIM function do in SQL?

• Removes specified characters from the beginning and end of a string

• Truncates a string to a specified length

• Transposes the characters in a string

• Converts a string to uppercase

Which SQL function is used to return the right part of a string?

• RIGHT

• RTRIM

• SUBSTRING

• RIGHTSTR

Which function is used to convert a string to uppercase in SQL?

• UPPER

• UCASE

• CAPITALIZE

• CASEUP