Interested to Buy Any Domain ? << Click Here >> for more details...
What are Stored Procedures and When would we Use Them?
- 1 Answers
- 2145 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
Precompiled sets of SQL statements that are kept in the database are called stored procedures. They
Encapsulate business logic and intricate SQL queries.
Reduce network traffic (client-server round trips) to boost performance.
By using parameterized queries to limit access to data, you may improve security.
Make sure it is reusable and consistent across many applications.
When carrying out repetitive operations like data validation, business rule enforcement, or batch processing, stored procedures are especially helpful.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define weak entity set.
What is oracle block?
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
What is an artificial (derived) primary key? When should it be used?
Explain about the case statement present in stored procedure?
How to select the first record in a given set of rows?
What is a candidate key in a database?
What is the purpose of queries in a database?
What is sql and where is it used?
i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.
Is filemaker pro a relational database?
What is optimization in database?
Is access a database?
What is dbms pdf?
Explain the hierarchical database?
