Download to read offline
Uploaded byManish Tiwari
Interview Question, Oracle PLSQL, PLSQL Developer
The document provides a series of interview questions and answers related to Oracle PL/SQL, presented by Manish Tiwari, an assistant professor and software engineer. Key topics covered include differences between anonymous and named blocks, types of cursors, triggers, and various Oracle functions. It serves as a resource for interview preparation in the domain of Oracle PL/SQL.
More Related Content
Similar to Interview Question, Oracle PLSQL, PLSQL Developer
Interview Question, Oracle PLSQL, PLSQL Developer
- 1.
- 2. manishtiwarise.blogspot.in 2 Presentation By Manish Tiwari, AssistantProfessor, Software Engineer, Computer Science and Application
- 3. 2. WhatsApp: ? manishtiwarise.blogspot.in 3 4.Blog: manishtiwarise.blogspot.in 3. Email: tiwarikmanish@gmail.com 1. Twitter: @manishtiwarise 5. Slide Share: https://www.slideshare.net/tiwarikmanish Find Notes at
- 4. manishtiwarise.blogspot.in 4 Today’s Agenda 3. InterviewQuestions for Oracle PLSQL
- 5. manishtiwarise.blogspot.in 5 1. Tell meabout yourself ?
- 6. manishtiwarise.blogspot.in 6 Q. 2. Whatis difference between Anonymous block and Named Block ? Anonymous Block: Named Blocked: Answer is
- 7. manishtiwarise.blogspot.in 7 Q. 3 Whatare the different types of the cursor ?
- 8. manishtiwarise.blogspot.in 8 Q. 4 Whatare the ref cursor?
- 9. manishtiwarise.blogspot.in 9 Q. 5 Whatis trigger ?
- 10. manishtiwarise.blogspot.in 10 Q. 6 Howmany types of trigger are in the oracle database?
- 11. manishtiwarise.blogspot.in 11 Q. 7 Whatis mutating errors?
- 12. manishtiwarise.blogspot.in 12 Q. 8 Whatis difference between procedure and function?
- 13. manishtiwarise.blogspot.in 13 Q. 8 Howmany types of trigger are in the oracle database?
- 14. manishtiwarise.blogspot.in 14 Q. 9 Whatare predefined exception, name any two?
- 15. manishtiwarise.blogspot.in 15 Q. 10 Explainsubstr function?
- 16. manishtiwarise.blogspot.in 16 Q. 11 Explaininstr function ?
- 17. manishtiwarise.blogspot.in 17 Q. 12 Writea code to count number of commas in string “A,B,C,D,” .
- 18. manishtiwarise.blogspot.in 18 Q. 13 Whatis different between %Type and %RowType ? %rowtype: This is structure is used to define records like table or views. This contains single for entire database object. Answer is %type: It is used to define individual field of database.
- 19. manishtiwarise.blogspot.in 19 Q. 14 Howmany triggers can be applied on table? 12 triggers. Answer is
- 20. manishtiwarise.blogspot.in 20 Q. 15 Whatis different between package specification and package body ? Package Specification: It contains only definition of database objects like variable, records types, procedure and function etc. Answer is Package Body: This contains actual code.
- 21. manishtiwarise.blogspot.in 21 Q. 16 Whatis different types of cursor? 1. Implicit Cursor 2. Explicit Cursor Answer is
- 22. manishtiwarise.blogspot.in 22 Q. 17 Whatis pragma autonomous transaction? Answer is
- 23. manishtiwarise.blogspot.in 23 Q. 18 Canwe use commit in trigger ? No, There is no need to use commit in trigger because trigger are auto committed. Answer is
- 24. manishtiwarise.blogspot.in 24 Q. 19 Canwe call procedure into function ? Answer is
- 25. manishtiwarise.blogspot.in 25 Q. 20 Whatis partition? Answer is
- 26. manishtiwarise.blogspot.in 26 Q. 21 Namesome predefined package used in oracle Answer is DBMS_OUTPUT, DBMS_UTILITY, DBMS_STATS, DBMS_PIPE etc
- 27. Thank You Job Routerand All the participant for listening me silently manishtiwarise.blogspot.in 27