Interview Questions - DBMS Basics

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.

It is a program module that provides the interface between the low-level data stored in database, application programs and queries submitted to the system.

It is a program module, which is responsible for fetching data from disk storage into main memory and deciding what data to be cache in memory.

It is a program module, which ensures that database, remains in a consistent state despite system failures and concurrent transaction execution proceeds without conflicting.