What is procedure in database?



What is procedure in database?..

Answer / Kumari Ritu

A procedure in a database is a set of SQL statements or logic that can be executed as a single unit. Procedures are used to encapsulate complex logic, improve code reusability, and simplify maintenance tasks. They can accept parameters and return results. Some databases refer to procedures as stored procedures, functions, or user-defined functions (UDF).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

Describe the Process of Connecting a Database to a Data Analysis Tool.

1 Answers  


Describe the differences between vertical and horizontal portioning.

1 Answers  


What is an extensible database?

1 Answers  


Explain a database server?

1 Answers  


What is pcbs (program communication blocks)?

1 Answers  


What are the disadvantages of a database?

1 Answers  


What is index hunting and how does it help in improving query performance?

1 Answers  


What is rdbms and its features?

1 Answers  


when All datafiles related to a Tablespace are removed ?

1 Answers  


How do you open .db files?

1 Answers  


What is meant by database system?

1 Answers  


What are the differences between a dbms and rdbms?

1 Answers  


Categories