Interested to Buy Any Domain ? << Click Here >> for more details...
What are Stored Procedures and When would we Use Them?
- 1 Answers
- 2753 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 is normalization? What are different type of normalization?
What are database data types?
What is optimization in database?
When do you get a .PLL extension ?
What is stored in a database?
What are the main functions of a database management system?
Explain all codd's rules for relational database system?
Is it possible to declare or create a cursor for update of table? If no tell me why?
What are the 5 major parts of a database system?
Mention the differences between union and union all
write a query to Find the Maximun second value in table?
How a Store Procedure called with a cursor out parameter.?
-
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)
