Interview Questions - DBMS Basics

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