A list of the top 10 DBMS interview questions and answers is given below.
Q1. What is Database?
Database is a collection of related data. It is the electronic equivalent of a file
cabinet. A database management system (DBMS) or database manager is a
program that sets up or structures a database.
Q2. What is DBMS?
“A DBMS is a collection of interrelated data and a set of programs to access those
data.” DBMS is a system that allows inserting, deleting, and updating
databases. DBMS acts as an interface between the application program and the
operating system to access or manipulate the database.
Q3. What is RDBMS? How is it different from DBMS?
A Relational Database Management System (RDBMS) is a database management
system that is based on the relational model as introduced by Dr. E.F. Codd.
RDBMS stores data in the form of related tables. An important feature of relational
systems is that a single database can be spread across several tables.
Q4. What is the main difference between a file processing system and
a DBMS?
File Management system Like C, C++, Cobol
1. Small System
2. The problem of data isolation is found.
3. Simple Structure.
4. Single User.
5. Data Redundancy problem is found.
6. Few Files.
7. Often PC-based.
8. Security of data is not good.
9. Accessing databases is comparatively difficult.
DBMS Like SQL, Oracle
1. Large System
2. The problem of data isolation is not found.
3. Complex Structure.
4. Multiple User.
5. Data Redundancy problem is not found.
6. Many Users.
7. Mini Mainframe-based.
8. Security of data is good.
9. Accessing databases is easier.
Q5. What are super, primary, candidate, and foreign keys?
Q1. What is Database?
Database is a collection of related data. It is the electronic equivalent of a file
cabinet. A database management system (DBMS) or database manager is a
program that sets up or structures a database.
Q2. What is DBMS?
“A DBMS is a collection of interrelated data and a set of programs to access those
data.” DBMS is a system that allows inserting, deleting, and updating
databases. DBMS acts as an interface between the application program and the
operating system to access or manipulate the database.
Q3. What is RDBMS? How is it different from DBMS?
A Relational Database Management System (RDBMS) is a database management
system that is based on the relational model as introduced by Dr. E.F. Codd.
RDBMS stores data in the form of related tables. An important feature of relational
systems is that a single database can be spread across several tables.
Q4. What is the main difference between a file processing system and
a DBMS?
File Management system Like C, C++, Cobol
1. Small System
2. The problem of data isolation is found.
3. Simple Structure.
4. Single User.
5. Data Redundancy problem is found.
6. Few Files.
7. Often PC-based.
8. Security of data is not good.
9. Accessing databases is comparatively difficult.
DBMS Like SQL, Oracle
1. Large System
2. The problem of data isolation is not found.
3. Complex Structure.
4. Multiple User.
5. Data Redundancy problem is not found.
6. Many Users.
7. Mini Mainframe-based.
8. Security of data is good.
9. Accessing databases is easier.
Q5. What are super, primary, candidate, and foreign keys?
