PLSQL Interview Questions

1) What is a Cursor and Cursor Types?

2) What is FOR UPDATE and WHERE CURRENT Clauses?

3) Differences between Procedure and Function?

4) Can we create Package Specification without package Body?

5) What is Forward Declaration in packages?

6) What are the packages you are using?

7) What are the main advantages of Packages?

8) What is the use NOCOPY?

9) Can we use OUT and INOUT Parameter in Functions?

10) What is BULK COLLECT and BULK BIND?

11) What are the cursors attributes?

12) What is save Exception?

13) What is Exception and types of Exceptions?

14) What is Raise_application_error?

15) What is PRAGMA EXCEPTION_INIT?

16) What is PRAGMA Autonomous transaction?

17) What is Global Temporary Table?

18) What are the types of Collections and Differences between all these?

19) What is Insead of Trigger?

20) What is Mutating Table Error?

21) How to debug a procedure?

22) What are the differences between BINARY_INTEGER and PLS_INTEGER?

23) Can we use TCL ( Commit, ROLLBAK) in Triggers?

24) What are the types of Triggers?

25) What are the types of System Triggers?