DBMS Interview Questions and Answers



1. What is DBMS ?

Answer : DBMS is represented by the DataBase Management...



2. Characteristics of DBMS ?

    A) non-redundant
    B) data independence
    C) increased security
    D) all the above

Answer : D) all the above...



3. Design a database for a hierarchical data like country, state, zone, street etc., The tags and length of the hierarchy are not specific and they can change anytime ?

Answer : Hierarchical data is a common relational data pattern for representing tree-like data structures...



4. What is Normalization ?

Answer : Normalization is the process of reorganizing data in a database...



5. What is indexing in database ?

Answer : Indexing is the One of the ways that will optimize the database searching...




Related Searches to DBMS Interview Questions and Answers