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


Please Help Members By Posting Answers For Below Questions

List various types of log-based recovery in DBMS.

576


What is the difference between a stored procedure and a query?

596


Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

594


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2107


What is a sequence? Explain it with one example?

651






How is image stored in database?

586


What is difference between clustered, non-clustered and unique index?

611


What is a database call?

562


how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1600


what is the role of auditor in auditing data oriented applications?

1935


What are the advantages of normalizing a database.

602


Explain partial key?

659


WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2487


Explain phantom deadlock?

787


What is Object Oriented model?

626