Stored Procedures Interview Questions
- What is cursors?
- Explain about cursors?
- What is stored procedure?
- What is a stored procedure?
- How will you raise an error in Sql?
- Explain about the RETURN statement?
- What are the uses of stored procedure?
- How to create procedure in Sql server?
- Explain about the properties of Cursors?
- Explain about recursive stored procedures?
- Where the procedures are stored in database?
- Difference between view and stored procedure?
- How you will return XML from Stored Procedure?
- What are the different types of Storage Procedure?
- When do one need to recompile stored procedure?
- How do you notify DBPAK about Stored Procedure?
- State the different extensions for stored procedures?
- When would you use stored procedure or functions?
- State about the security aspects of stored procedures?
- Explain about the implementation of stored procedures?
- How will know whether the SQL statements are executed?
- How can I call function in a stored procedure in SQL Server?
- What are external procedures? Why and when they are used?
- How do I mark the stored procedure to automatic execution?
- Explain about the case statement present in stored procedure?
- How do you find which procedures are being used in database?
- What are the difference between a function and a stored procedure?
- What is the difference between procedures and functions and triggers?
- Explain the benefits of running stored procedure on a database engine?
- Explain about the process which takes place to execute a stored routine?
- Explain about the implementation of business logic in stored procedures?
- Does storing of data in stored procedures increase the access time? Explain?
- What is the difference between stored procedures and stored functions in ORACLE?
- What is the difference between a users defined function and a stored procedure?
- Explain about the difficulties faced by the database developer in implementing pre compiled statements?