Interview Question, Oracle PLSQL, PLSQL Developer

This presentation show different questions are asked in interviews for post of SQL, PLSQL Developer in IT Industry. This gives in idea how question fired to candidates.

1. Interview Question manishtiwarise.blogspot.in 1 Oracle PLSQL

2. manishtiwarise.blogspot.in 2 Presentation By Manish Tiwari , Assistant Professor, Software Engineer, Computer Science and Application

3. 2. WhatsApp : ? manishtiwarise.blogspot.in 3 4. Blog : manishtiwarise.blogspot.in 3. Email : [email protected] 1. Twitter : @ manishtiwarise 5. Slide Share : https ://www.slideshare.net/tiwarikmanish Find Notes at

4. manishtiwarise.blogspot.in 4 Today’s Agenda Interview Questions for Oracle PLSQL

5. manishtiwarise.blogspot.in 5 1. Tell me about yourself ?

6. manishtiwarise.blogspot.in 6 Q. 2. What is difference between Anonymous block and Named Block ? Anonymous Block: Named Blocked: Answer is

7. manishtiwarise.blogspot.in 7 Q. 3 What are the different types of the cursor ?

8. manishtiwarise.blogspot.in 8 Q. 4 What are the ref cursor?

9. manishtiwarise.blogspot.in 9 Q. 5 What is trigger ?

10. manishtiwarise.blogspot.in 10 Q. 6 How many types of trigger are in the oracle database?

11. manishtiwarise.blogspot.in 11 Q. 7 What is mutating errors?

12. manishtiwarise.blogspot.in 12 Q. 8 What is difference between procedure and function?

13. manishtiwarise.blogspot.in 13 Q. 8 How many types of trigger are in the oracle database?

14. manishtiwarise.blogspot.in 14 Q. 9 What are predefined exception, name any two?

15. manishtiwarise.blogspot.in 15 Q. 10 Explain substr function?

16. manishtiwarise.blogspot.in 16 Q. 11 Explain instr function ?

17. manishtiwarise.blogspot.in 17 Q. 12 Write a code to count number of commas in string “A,B,C,D,” .

18. manishtiwarise.blogspot.in 18 Q. 13 What is 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 How many triggers can be applied on table? 12 triggers. Answer is

20. manishtiwarise.blogspot.in 20 Q. 15 What is 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 What is different types of cursor? Implicit Cursor Explicit Cursor Answer is

22. manishtiwarise.blogspot.in 22 Q. 17 What is pragma autonomous transaction? Answer is

23. manishtiwarise.blogspot.in 23 Q. 18 Can we 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 Can we call procedure into function ? Answer is

25. manishtiwarise.blogspot.in 25 Q. 20 What is partition? Answer is

26. manishtiwarise.blogspot.in 26 Q. 21 Name some predefined package used in oracle Answer is DBMS_OUTPUT, DBMS_UTILITY, DBMS_STATS, DBMS_PIPE etc

27. Thank You Job Router and All the participant for listening me silently manishtiwarise.blogspot.in 27