STORED PROCEDURES Database Interview Questions [12 Questions]

  1. Difference between View and Stored ProcedureWhat 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 could suggest me good reference websites then that would be great.
  2. Can you call procedure in functions
  3. What is PRAGMA AUTONOMOUS_TRANSACTION ?
    How to use that ?
  4. Why the stored functions can not be called from DML Statements? Why cant we modify the database by function?
  5. What is the difference between "stored procedure" and "dynamic SQL" ?
  6. You must first Login or Register to view all 12 questions from this category.


    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.