Oracle Academy Quiz Part 3 🎓| SQL Interview Questions 🧩| Single Row Functions

Single-row functions return a single result row for every row of a queried table or view. These functions can appear in select lists, WHERE clauses, START WITH and CONNECT BY clauses, and HAVING clauses.
1. The function TO_DATE('15-JAN-2023', 'DD-MON-YYYY') converts:
2. Which function would you use to find the position of a substring within a string?
3. The function ROUND(SYSDATE, 'MONTH') will round the date to the nearest:
4. Which of the following functions converts a string to lowercase in Oracle?
5. The function CEIL(4.2) will return:
6. The REPLACE('apple', 'p', 'b') function will return:
7. What does the function CHR(65) return?
8. The function ABS(-15) returns:
9. Which function removes leading characters from a string?
10. What does the SIGN(-10) function return?

Welcome to QueryHub! 🎓🔍 Dive deep into the world of databases with our channel, where the mission is to Ask, Learn, and Excel. Whether you're a beginner or a seasoned pro, our videos provide insightful tutorials, expert tips, and comprehensive guides to help you master database technologies.

Don't forget to Like, Comment, and Subscribe for the latest updates and exclusive content! 🌟📊

🔔 Connect with us on social media:

Join our community, hit the subscribe button, and let's make learning databases fun and interactive! 🚀✨

#QueryHub #DatabaseTutorials #LearnWithRaj #asklearnexcel