Q: What will be the output value for see_soundex and sea_soundex?
SELECT
SOUNDEX('see') see_soundex,
SOUNDEX('sea') sea_soundex;
A: sea_soundex and see_soundex values will be same.
Q: What is the minimum value stored by signed TINYINT?
A: -128
Q: Which function deletes a part of a string and then insert another substring into the string starting at a specified position?
A: STUFF
Q: The maximum value that can be specified for the size of VARCHAR is _____________.
A: 65535
Q: Which SQL function is used to return the length of a string?
A: LEN
Q: Which mode does not remove trailing spaces when CHAR values are retrieved?
A: PAD_CHAR_TO_FULL_LENGTH
Q: Which function returns the starting position of the first occurrence of a pattern in a string?
A: PATINDEX
Q: Which SQL function is used to remove all leading and trailing spaces from a string?
A: TRIM
Q: The function of CONCAT_WS is
A: Concatenate multiple strings with a separator into a single string.
Q: The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________.
A: 5