DBMS Questions for Interview

E-R diagram also termed as Entity-Relationship diagram shows relationship between various tables in the database. The correct answer would be: E-R diagrams, short for Entity-Relationship diagrams, are visual representations used in database design to depict the logical structure of a database. They illustrate the entities within the system and the relationships between them. These diagrams … Read more

In 1969 Dr. E. F. Codd laid down some 12 rules which a DBMS should adhere in order to get the logo of a true RDBMS. Rule 1: Information Rule. “All information in a relational data base is represented explicitly at the logical level and in exactly one way – by values in tables.” Rule … Read more

DBMS provides a systematic and organized way of storing, managing and retrieving from collection of logically related information. RDBMS also provides what DBMS provides but above that it provides relationship integrity. So in short we can say: RDBMS = DBMS + REFERENTIAL INTEGRITY These relations are defined by using “Foreign Keys” in any RDBMS.Many DBMS … Read more

SQL stands for Structured Query Language.SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL stands for Structured Query Language. It’s a standard programming language specifically designed for managing and manipulating relational databases. With SQL, … Read more

Database provides a systematic and organized way of storing, managing and retrieving from collection of logically related information. Secondly the information has to be persistent, that means even after the application is closed the information should be persisted. Finally it should provide an independent way of accessing data and should not be dependent on the … Read more