ColdFusion Question:
Download Questions PDF

What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?

Answer:

Stored procedures abstract database logic from server side code. They also offer performance benefits in pushing application logic to the database side.

The disadvantage is that if they are poorly written then they can hinder database performance and make development a little more obfuscated.

Download ColdFusion Interview Questions And Answers PDF

Previous QuestionNext Question
How can you clear the cache?How would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it?