DBMS Basics - Interview Questions and Answers

  1. What is Relationship set?
    The collection (or set) of similar relationships.
  2. What is Relationship type?
    Relationship type defines a set of associations or a relationship set among a given set of entity types.
  3. What is degree of Relationship type?
    It is the number of entity type participating.
  4. What is DDL (Data Definition Language)?
    A data base schema is specifies by a set of definitions expressed by a special language called DDL.
  5. What is VDL (View Definition Language)?
    It specifies user views and their mappings to the conceptual schema.
  6. What is SDL (Storage Definition Language)?
    This language is to specify the internal schema. This language may specify the mapping between two schemas.