A stored process was a group of SQL and PL/SQL orders that perform certain employment
The application does not accumulate
6. What exactly is kept procedure? It’s created, accumulated, and you can kept in this new database, and can end up being carried out from the a user otherwise databases app.
8. What is the access to finally? In the long run can be used in conjunction with was cut off. Whether the exemption are thrown or perhaps not, ultimately block could well be executed.
They are not without difficulty extensible: Nothing is like inheritance on DTD world
17. What is the difference in DTD and Outline? Schemas have quite ancient program of data kind of. Schemas commonly modular, so it’s quite difficult so you can reuse area of the DTD.
24. What is mode during the Databases? A features is a lot like a kept Techniques. Area of the difference between him or her would be the fact a features production an excellent value, and you can a stored process does not. Another change is how a features are entitled. It can return a regard, getting invoked courtesy a choose demand, and you will be used in data that have another function.
—————————————- Issues and you may Resources: 1) Polymorphism (overloading, overriding, societal, static) 2) Serialization (measures, coding) 3) Collection (Interfaces, Categories, duplications, null away from techniques, null out-of opinions, buy, synchronized) 4) a) Synchronized. b) What is the diff. between synchronized stop, and you can snychronized strategy? c) What’s the other anywhere between process and you can threads? 5) Exception to this rule (are, catch, in the end, toss, sets, user-laid out along with) Sorts of difference? Diff. between Error and you will Difference? 6) ConnectionPooling 7) String (Target, LiteralPool, Means, == ) 8) User interface 9) Abstract group (Diff. anywhere between abstract group, interface), what is the accessibility conceptual classification, when tend to you utilize it? 10) Packages 11) coffee.lang 
