Relational Database Management System (RDBMS) Question:
What are stored-procedures? And what are the advantages of using them?
Answer:
Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.
| Previous Question | Next Question |
| Does PL/SQL support overloading? Explain? | Name two utilities that Oracle provides, which are use for backup and recovery? |