MCQ King
Oracle – Functions
1 / 25
1. What does the Oracle SQL function “TO_CHAR” do?
2 / 25
2. In Oracle SQL, what is the purpose of the “ROUND” function?
3 / 25
3. Which Oracle SQL function is used to extract a substring from a string?
4 / 25
4. What does the “NVL” function in Oracle SQL do?
5 / 25
5. In Oracle SQL, what is the primary purpose of the “TO_DATE” function?
6 / 25
6. Which Oracle SQL function is used to find the length of a string?
7 / 25
7. What is the primary role of the “TRUNC” function in Oracle SQL?
8 / 25
8. In Oracle SQL, what does the “COALESCE” function do?
9 / 25
9. Which Oracle SQL function is used to concatenate two or more strings?
10 / 25
10. What is the primary purpose of the “SYSDATE” function in Oracle SQL?
11 / 25
11. In Oracle SQL, what is the purpose of the “LEAST” function?
12 / 25
12. Which Oracle SQL function is used to find the largest value in a list of expressions?
13 / 25
13. What does the “UPPER” function in Oracle SQL do?
14 / 25
14. In Oracle SQL, what is the primary purpose of the “TO_NUMBER” function?
15 / 25
15. Which Oracle SQL function is used to find the greatest value in a list of expressions?
16 / 25
16. What is the primary role of the “MOD” function in Oracle SQL?
17 / 25
17. In Oracle SQL, what does the “INITCAP” function do?
18 / 25
18. Which Oracle SQL function is used to calculate the absolute value of a number?
19 / 25
19. What does the Oracle SQL function “TRIM” do?
20 / 25
20. In Oracle SQL, what is the purpose of the “ABS” function?
21 / 25
21. Which Oracle SQL function is used to find the least value in a list of expressions?
22 / 25
22. What is the primary role of the “CEIL” function in Oracle SQL?
23 / 25
23. In Oracle SQL, what does the “INSTR” function do?
24 / 25
24. Which Oracle SQL function is used to round a numeric value to the nearest integer?
25 / 25
25. What is the primary purpose of the “SUBSTR” function in Oracle SQL?
Your score is
Restart quiz