Stored Procedures Interview Questions And Answers

Stored Procedures Interview Questions list for experienced

  1. Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger?
  2. How one call DDL statement using stored procedures in Oracle?
  3. What is the difference between \"IS\" and \"AS\" while creating procedure. Ex:- create procedure IS or AS
  4. what is the difference between stored procedures and stored functions in ORACLE
  5. Explain the benefits of running stored procedure on a database engine?
  6. how many types of stored procedure?
  7. Explain about the implementation of business logic in Stored procedures?
  8. How can we call stored procedures inside store procedures?
  9. what is the Difference between View and Stored Procedure?
  10. Explain about the RETURN statement?
  11. What is stored procedure?
  12. Explain about the implementation of stored procedures?
  13. What is the difference between a user defined function and a Stored procedure?
  14. State about the security aspects of stored procedures?
  15. Does storing of data in stored procedures increase the access time? Explain?
  16. State the different extensions for stored procedures?
  17. Explain about the process which takes place to execute a Stored routine?
  18. Explain about recursive stored procedures?

Stored Procedures interview questions and answers on advance and basic Stored Procedures with example so this page for both freshers and experienced condidate. Fill the form below we will send the all interview questions on Stored Procedures also add your Questions if any you have to ask and for apply in Stored Procedures Tutorials and Training course just send a mail on info@pcds.co.in in detail about your self.

Top Stored Procedures interview questions and answers for freshers and experienced

What is Stored Procedures ?

Answer : A subroutine available to applications accessing a relational database system.

Questions : 1 :: Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger?

Cannot perform commit or rollback because they are part of triggering sql statements hence don't need to save the transaction by...View answers

Questions : 2 :: How one call DDL statement using stored procedures in Oracle?

Yes, we can call DDL command using EXECUTE IMMEDIATE command

Questions : 3 :: What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS


Both are equivalent .. Just replacement of DECLARE keyword in declarative section.

Questions : 4 :: what is the difference between stored procedures and stored functions in ORACLE

Both(functions and Procedures) are the Oracle Objects that work explicitly towards database objects like Tables,Views.The diff. b/t Stored Procedures and Functions 1) The procedures doesn't return...View answers

Questions : 5 :: Explain the benefits of running stored procedure on a database engine?

Stored procedures can run directly run on a data base engine. In industries where automation is the key a stored procedure can run entirely on the data base provided to it and this runs on a...View answers

Questions : 6 :: how many types of stored procedure?


Stored Procedure are of two type1-user define stored procedure2- System define Stored procedure

Questions : 7 :: Explain about the implementation of business logic in Stored procedures?

Stored procedures implement business logic into the database. It is embedded as API and this reduces the implementation of Logic code again explicitly. Implementation of business logic internally...View answers

Questions : 8 :: How can we call stored procedures inside store procedures?

Alter procedure CallAnotherProcedureasexec sp_helptext CallAnotherProcedure

Questions : 9 :: what is the Difference between View and Stored Procedure?


What is the difference between View and Stored Procedure? Can views accept input parameters as stored procedure? If yes,how could I do that? I am new to database and working on MS SQL,if someone...View answers

Questions : 10 :: Explain about the RETURN statement?

A RETURN statement is used to terminate the execution of a stored function. This inturn returns a value of expr to the function caller. In a stored function there should be at least a single return...View answers

Questions : 11 :: What is stored procedure?

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a...View answers

Questions : 12 :: Explain about the implementation of stored procedures?

Implementation of stored procedure varies for different databases and vendors. Stored procedures are very flexible and they can be implemented in variety of languages. Stored procedures written in...View answers

Questions : 13 :: What is the difference between a user defined function and a Stored procedure?

A user defined function and stored procedures are almost similar but there exists a difference between their implementation procedures in the code. Stored procedure needs to be invoked whereas a UDF...View answers

Questions : 14 :: State about the security aspects of stored procedures?

Stored procedures should be written very carefully because they store complex and logical data. Security permissions should be very finely applied and this is possible by carefully written code....View answers

Questions : 15 :: Does storing of data in stored procedures increase the access time? Explain?

Data stored in stored procedures can be retrieved much faster than the data stored in SQL database. Data can be precompiled and stored in Stored procedures. This reduces the time gap between query...View answers

Questions : 16 :: State the different extensions for stored procedures?

Most of the database systems have proprietary and vendor based extensions. Microsoft allows procedures to be written using Transact-SQL. Oracle calls its extension as PL/SQL. DB2 has its extension as...View answers

Questions : 17 :: Explain about the process which takes place to execute a Stored routine?

CREATE PROCEDURE and CREATE FUNCTION statement are used to create stored routine. It can act as a function or a procedure. A procedure can be called by using a call statement and pass output with the...View answers

Questions : 18 :: Explain about recursive stored procedures?

Recursive stored procedures are used for performing repetitive tasks. Recursive feature is disabled by default but can be activated by using the following command on the server...View answers
More Question

Ask your interview questions on Stored Procedures

Write Your comment or Questions if you want the answers on Stored Procedures from Stored Procedures Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---