Interested to Buy Any Domain ? << Click Here >> for more details...
What are Stored Procedures and When would we Use Them?
- 1 Answers
- 3043 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 are the disadvantage in file processing system?
How do you invoke datastage using unix?
What is sorting in dbms?
What is the use of NOARCHIEVELOG parameter in Database?
Who has the largest database?
What integrity rules exist in the dbms?
When is functional dependency said to be the fully functional dependency?
What are the different type of relationships in the dbms?
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What is meant by database system?
Name the two files that are created when you generate a form ?
-
Oracle (3253) - 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)
