MySQL – Numeric Functions MCQ

MySQL – Numeric Functions MCQ

1 / 24

1. What is the primary purpose of MySQL numeric functions?

2 / 24

2. Which MySQL function returns the absolute value of a number?

3 / 24

3. What does the ROUND() function in MySQL do?

4 / 24

4. Which MySQL function returns the smallest integer greater than or equal to a number?

5 / 24

5. What is the purpose of the FLOOR() function in MySQL?

6 / 24

6. Which MySQL function raises a number to a specified power?

7 / 24

7. What does the SQRT() function in MySQL calculate?

8 / 24

8. Which MySQL function generates a random floating-point value between 0 and 1?

9 / 24

9. In MySQL, what does the CEIL() (or CEILING()) function return?

10 / 24

10. Which numeric function is often used for summarizing and analyzing numeric data in MySQL?

11 / 24

11. What is the primary use of the FORMAT() function in MySQL?

12 / 24

12. When working with floating-point numbers in MySQL, what should you be cautious about?

13 / 24

13. Which numeric function in MySQL is used for scientific calculations involving squares and roots?

14 / 24

14. In MySQL, what do trigonometric functions like SIN(), COS(), and TAN() primarily deal with?

15 / 24

15. Which MySQL function returns the sine of an angle in radians?

16 / 24

16. What does the ASIN() function in MySQL do?

17 / 24

17. Which MySQL function is used to calculate the square root of a number?

18 / 24

18. What is the primary benefit of using the RAND() function in MySQL?

19 / 24

19. When using numeric functions on large datasets in MySQL, what should you be mindful of?

20 / 24

20. Which MySQL numeric function can be used for formatting numeric values as strings with thousands separators?

21 / 24

21. What is the purpose of using trigonometric functions like COS() and TAN() in MySQL?

22 / 24

22. In MySQL, what is the primary use of the ACOS() function?

23 / 24

23. Which numeric function in MySQL returns the tangent of an angle in radians?

24 / 24

24. How can you ensure data accuracy and security when applying numeric functions in MySQL?

Your score is

0%