Quiz for Numeric Functions

Q1: Which SQL function returns the smallest integer greater than or equal to a number?

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

Q2: Which function returns the absolute value of a number?

A. ABS() B. MOD() C. ROUND() D. CEIL()

Q3: Which SQL function is used to round a number to the nearest integer?

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

Q4: What does the MOD(n, m) function return?

A. n divided by m B. remainder of n/m C. quotient of n/m D. m divided by n

Q5: Which function returns the smallest integer greater than or equal to a number?

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

Q6: What does the FLOOR() function do?

A. Rounds to nearest integer B. Returns fractional part C. Returns lowest integer <= number D. Returns highest integer >= number

Q7: Which function truncates a number to a specified decimal place without rounding?

A. ROUND() B. TRUNC() C. MOD() D. ABS()

Q8: Which function returns the square root of a number?

A. SQUARE() B. ROOT() C. SQRT() D. POW()

Q9: How to return the power of a number in SQL?

A. POW(n, m) B. EXP(n, m) C. SQUARE(n, m) D. POWER(n, m)

Q10: Which function returns the exponential value of a number?

A. EXP() B. LOG() C. MOD() D. ABS()

Q11: Which SQL function returns the natural logarithm of a number?

A. LOG10() B. LOG() C. LN() D. EXP()

Q12: Which function returns base-10 logarithm in SQL?

A. LN() B. LOG() C. LOG10() D. EXP()

Q13: What does the SIGN() function return?

A. Sign of number B. Magnitude C. Absolute value D. Remainder

Q14: Which function returns the cube root of a number in PostgreSQL?

A. SQRT() B. CUBEROOT() C. CBRT() D. POWER()

Q15: Which function returns a random value between 0 and 1?

A. RAND() B. RANDOM() C. NEWID() D. ABS()

Q16: Which SQL function returns the number with specified precision?

A. ROUND(number, decimals) B. FLOOR(number, decimals) C. TRUNC(number) D. ABS(number, decimals)

Q17: Which function is used to calculate modulus of two numbers?

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

Q18: Which function returns the largest value in a column?

A. MAX() B. SUM() C. AVG() D. COUNT()

Q19: What does the AVG() function return?

A. Maximum value B. Minimum value C. Average value D. Total count

Q20: Which function returns the total sum of a numeric column?

A. SUM() B. COUNT() C. AVG() D. TOTAL()

Q21: Which function is used to count all rows in a table?

A. MAX() B. SUM() C. COUNT() D. AVG()