Oracle Apps Technical Interview Question : PLSQL
1) What is Exception? User Defined Exception
2) Can we write commit in Trigger? How ?
3) Is commit Required to submit request from Trigger?
4) Commit/RollBack, Save Point?
5) Difference between VARRAY and Record Type? Advantage of both?
6) What is object types?
7) What are the attributes of PLSQL Table.
Ans:- .extend, .count, .delete, .prior, .next, .first, .last
8) What is the Difference between ROWType and Record Type?
9) What is Bulk Collect and its exception types, loop
10) What happen when Expception “When Others Then” placed above “When No_Data_Found”?
Ans:- It will Raise Exception.
No comments:
Post a Comment