What is Stored procedure ?
Answer Posted / ravishankar
Stored procedures are pre-compiled object in the Database
which is used to reduce the network traffic.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the various types of normalization.
What are the most common databases?
What are different types of joins used in?
what is transaction state, buffer management, shadow paging
How to shrink a database?
What advantages does DBMS have over traditional file systems?
What is difference between clustered, non-clustered and unique index?
Explain inner and outer joins with examples.
Explain normalization in one line?
Under which circumstance should you create an index on a table?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What are the advantages of views in a database?
List various types of log-based recovery in DBMS.
How does database replication work?
Which database does facebook use?