Relational Database Management System (RDBMS) Question:

Download Job Interview Questions and Answers PDF

What are stored-procedures? And what are the advantages of using them?

RDBMS Interview Question
RDBMS Interview Question

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.

Download RDBMS Interview Questions And Answers PDF

Previous QuestionNext Question
Does PL/SQL support overloading? Explain?Name two utilities that Oracle provides, which are use for backup and recovery?