Essential RDBMS Interview Questions and Answers
1. What is RDBMS?
Answer (1 Mark): RDBMS (Relational Database Management System) is a database system that stores data in tables and maintains relationships between the tables.
Probability: ⭐⭐⭐⭐⭐ (Very High – 90%)
2. What is a database?
Answer (1 Mark): A database is an organized collection of related data stored electronically for easy access and management.
Probability: ⭐⭐⭐⭐⭐ (Very High – 85%)
3. What is a Database Management System (DBMS)?
Answer (1 Mark): A DBMS is software that allows users to create, manage, store, and retrieve data from a database.
Probability: ⭐⭐⭐⭐⭐ (Very High – 90%)
4. Who introduced the relational model?
Answer (1 Mark): The relational model was introduced by Edgar F. Codd in 1970.
Probability: ⭐⭐⭐⭐ (High – 75%)
5. What is a table in RDBMS?
Answer (1 Mark): A table is a collection of related data organized in rows and columns.
Probability: ⭐⭐⭐⭐⭐ (Very High – 85%)
6. What is a row in a table?
Answer (1 Mark): A row represents a single record in a table.
Probability: ⭐⭐⭐⭐ (High – 70%)
7. What is a column in a table?
Answer (1 Mark): A column represents an attribute or field of a table.
Probability: ⭐⭐⭐⭐ (High – 70%)
8. What is a primary key?
Answer (1 Mark): A primary key is a field that uniquely identifies each record in a table and cannot be null or duplicate.
Probability: ⭐⭐⭐⭐⭐ (Very High – 95%)
9. What is a foreign key?
Answer (1 Mark): A foreign key is a field in one table that refers to the primary key of another table.
Probability: ⭐⭐⭐⭐⭐ (Very High – 90%)
10. What is a one-to-many relationship?
Answer (1 Mark): In a one-to-many relationship, one record in a table is related to many records in another table.
Probability: ⭐⭐⭐⭐ (High – 75%)
11. What is SQL?
Answer (1 Mark): SQL (Structured Query Language) is a standard language used to create and manage relational databases.
Probability: ⭐⭐⭐⭐⭐ (Very High – 95%)
12. What is Data Definition Language (DDL)?
Answer (1 Mark): DDL is a part of SQL used to define and modify database structures such as tables.
Probability: ⭐⭐⭐⭐ (High – 80%)
13. What is Data Manipulation Language (DML)?
Answer (1 Mark): DML is a part of SQL used to insert, update, delete, and retrieve data from tables.
Probability: ⭐⭐⭐⭐ (High – 80%)
14. What is data integrity in RDBMS?
Answer (1 Mark): Data integrity ensures that the data in a database is accurate, consistent, and reliable.
Probability: ⭐⭐⭐⭐ (High – 75%)
15. How does RDBMS ensure data security?
Answer (1 Mark): RDBMS ensures data security through authentication, user roles, and access control privileges.
Probability: ⭐⭐⭐ (Moderate – 65%)
16. What is transaction management?
Answer (1 Mark): Transaction management ensures that database operations follow ACID properties for reliability.
Probability: ⭐⭐⭐⭐ (High – 75%)
17. What is backup and recovery?
Answer (1 Mark): Backup and recovery are processes used to restore data in case of system failure or data loss.
Probability: ⭐⭐⭐ (Moderate – 60%)
18. Mention one advantage of RDBMS.
Answer (1 Mark): One advantage of RDBMS is reduced data redundancy.
Probability: ⭐⭐⭐⭐ (High – 70%)
19. Mention one limitation of RDBMS.
Answer (1 Mark): One limitation of RDBMS is high setup and maintenance cost.
Probability: ⭐⭐⭐ (Moderate – 60%)
20. Why is RDBMS important for NSQF IT & ITES students?
Answer (1 Mark): RDBMS helps students develop essential database management skills required for IT and ITES jobs.