Interested to Buy Any Domain ? << Click Here >> for more details...
What are Stored Procedures and When would we Use Them?
- 1 Answers
- 2729 Views
- I also Faced
- E-Mail Answers
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 |
What do you understand by fragmentation?
How data are stored in database?
What is difference between sql and rdbms?
What is progress open edge?
What is the purpose of normalization in dbms?
Where is database used?
what is the diff between dbms and rdbms(what are the 12 rilations in the rdbms).
What is dbms function?
Explain the components of rdbms?
Explain the concept of acid properties in dbms?
What is buffer manager?
What is normalisation and its type?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
