DBMS Basics - Interview Questions and Answers

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.

It is a program module, which manages the allocation of space on disk storage and data structure used to represent information stored on a disk.

It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to access data.

Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These types of procedures are not available for reference from other Oracle tools. Another limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

PL/SQL uses cursors for all database information accesses statements. The language supports the use two types of cursors
1.) Implicit
2.) Explicit