Quiz for Scalar Functions

Q1: What is true about scalar functions in SQL?

A. They return multiple rows B. They return one value for each row C. They are used in GROUP BY only D. They require JOINs

Q2: Which scalar function returns the length of a string in characters?

A. LENGTH() B. CHAR_LENGTH() C. SIZE() D. STRLEN()

Q3: Which SQL scalar function is used to convert a string to uppercase?

A. LOWER() B. INITCAP() C. UPPER() D. CAPITAL()

Q4: Which function is used to return the current system date and time?

A. SYSDATE() B. NOW() C. GETDATE() D. CURRENT_TIMESTAMP()

Q5: What does the ABS() function return?

A. Absolute value B. Square root C. Rounded value D. Negative value

Q6: Which function is used to extract a substring from a string in SQL?

A. SUBSTRING() B. STRSLICE() C. CHAR_SLICE() D. MIDSTR()

Q7: Which function rounds a numeric value to the nearest integer?

A. FLOOR() B. ROUND() C. CEIL() D. TRUNC()

Q8: Which scalar function removes leading and trailing spaces from a string?

A. TRIM() B. REMOVE() C. CLEAN() D. CUT()

Q9: What is the result of CEIL(5.2)?

A. 5 B. 6 C. 5.2 D. 4

Q10: What does the LOWER() function do?

A. Converts to uppercase B. Extracts lowercase characters C. Converts to lowercase D. Removes lowercase letters

Q11: Which scalar function returns the remainder of a division?

A. MOD() B. DIV() C. REMAINDER() D. RATIO()

Q12: What is the result of FLOOR(7.9)?

A. 7 B. 8 C. 9 D. 6

Q13: Which function can be used to replace characters in a string?

A. REPLACE() B. SUBSTITUTE() C. CHANGE() D. MODIFY()

Q14: What does INITCAP() function do?

A. Capitalizes first letter of each word B. Converts all letters to lowercase C. Converts all letters to uppercase D. Returns first character only

Q15: Which scalar function returns a portion of a string starting from a position?

A. MID() B. CHARAT() C. SUBSTRING() D. POSITION()

Q16: Which function would you use to concatenate two strings?

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

Q17: Which function pads a string with characters on the left?

A. LEFTPAD() B. PADLEFT() C. RPAD() D. LPAD()

Q18: Which function returns the ASCII value of the first character of a string?

A. ASCII() B. ORD() C. CHARVAL() D. CODE()

Q19: Which function returns a character based on the ASCII code?

A. CHR() B. ASCII() C. CHAR() D. CODE()

Q20: Which function returns the numeric value of pi in SQL?

A. PI() B. PI_VALUE() C. MATH_PI() D. CONSTANT_PI()