DBMS Basics - Interview Questions and Answers

  1. What is Buffer Manager?
    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.
  2. What is Transaction Manager?
    It is a program module, which ensures that database, remains in a consistent state despite system failures and concurrent transaction execution proceeds without conflicting.
  3. What is File Manager?
    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.
  4. What is Authorization and Integrity manager?
    It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to access data.
  5. What are stand-alone procedures?
    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.
  6. What are cursors give different types of cursors?
    PL/SQL uses cursors for all database information accesses statements. The language supports the use two types of cursors
    1.) Implicit
    2.) Explicit