Interested to Buy Any Domain ? << Click Here >> for more details...
What are Stored Procedures and When would we Use Them?
- 1 Answers
- 2549 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 the use of Snapshot?
Explain atomicity and aggregation?
Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.
What is like operator for and what are wild cards?
Describe a subquery.
Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz
Explain the term generalization.
what is the difference between delete and truncate?
What is view dbms?
Briefly describe the three types of sql commands.
Explain what are called fat clients and fat servers?
What do you mean by Checkbox ?
-
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)
