Stored Procedures Interview Questions

[coolinterview]

STORED PROCEDURES INTERVIEW QUESTIONS   Download Free Interview Questions eBook of 500 Questions (If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolIntervi...@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.) Stored Procedures Interview Questions Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger? http://www.coolinterview.com/interview/12519/   How one call DDL statement using stored procedures in Oracle? http://www.coolinterview.com/interview/29173/   What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS http://www.coolinterview.com/interview/7751/   what is the difference between stored procedures and stored functions in ORACLE http://www.coolinterview.com/interview/10631/   Explain the benefits of running stored procedure on a database engine? http://www.coolinterview.com/interview/23024/   how many types of stored procedure? http://www.coolinterview.com/interview/31126/   Explain about the implementation of business logic in Stored procedures? http://www.coolinterview.com/interview/23023/   How can we call stored procedures inside store procedures? http://www.coolinterview.com/interview/12326/   what is the Difference between View and Stored Procedure? http://www.coolinterview.com/interview/18090/   Explain about the RETURN statement? http://www.coolinterview.com/interview/23027/   What is stored procedure? http://www.coolinterview.com/interview/7753/   Explain about the implementation of stored procedures? http://www.coolinterview.com/interview/23018/   What are external procedures ? Why and when they are used? http://www.coolinterview.com/interview/10630/   What is the difference between a user defined function and a Stored procedure? http://www.coolinterview.com/interview/40311/   Explain the benefits of running stored procedure on a database engine? http://www.coolinterview.com/interview/40318/   State about the security aspects of stored procedures? http://www.coolinterview.com/interview/23020/   What is the difference between stored procedures and stored functions in ORACLE http://www.coolinterview.com/interview/7752/   Does storing of data in stored procedures increase the access time? Explain? http://www.coolinterview.com/interview/23021/   Explain about the process which takes place to execute a Stored routine? http://www.coolinterview.com/interview/23026/