Oracle Applications Software Developer I interview questions

Basic coding questions and some puzzles and basic knowledge of OOPS,DBMS and DS.

II. Technical Interview(F2F) : 1. Tell me something about yourself. 2. What will be the angle between hour hand and minute hand at 3:15 PM in a clock. 3. Write code to calculate angle between hour hand and minute hand at X:Y in a clock. Input: X, Y. Output: Angle b/w hands. 4. Puzzle: http://www.mathsisfun.com/puzzles/the-fly-and-the-trains.html 5. Puzzle: http://mkcohen.com/saturday-puzzle-9-apples-and-oranges 6. Implement stack using two queues. 7. Insert a node at nth position in a linked list. 8. Delete the node at nth position in a linked list. 9. Give an idea about BFS. 10. Interviewer asked me to write two SQL queries based on given two tables. 11. Explain normalization and its forms. 12. What is join? Why is it used? 13. What is ER diagram? 14. Explain CPU scheduling algorithms. III. Technical Interview(F2F) : 1. Find smallest and second smallest element in an array. http://www.geeksforgeeks.org/to-find-smallest-and-second-smallest-element-in-an-array/ 2. Find median of an array. Time complexity: O(n) 3. Detect and remove loop in a linked list. http://www.geeksforgeeks.org/detect-and-remove-loop-in-a-linked-list/ 4. http://www.geeksforgeeks.org/stock-buy-sell/ 5. Puzzle: http://www.crazyforcode.com/2-eggs-100-floors-puzzle/ IV. Technical Interview(F2F) : 1. Tell me about yourself. 2. Interviewer asked me about my project. 3. http://www.careercup.com/question?id=13364665 4. http://www.careercup.com/question?id=14260662 5. http://www.careercup.com/question?id=7853661