Part 1 : Basics 

---

 

Basic DBMS Questions

1. What is a Database?
   → Define what a database is and why it is used.

2. What is DBMS?
   → Explain the purpose of a Database Management System.

3. What are the advantages of using DBMS over a file system?
   → Example: data consistency, integrity, security, etc.

4. What is a primary key?
   → Define and explain with an example.

5. What is a foreign key?
   → Explain how it helps maintain relationships between tables.

6. What are the different types of database models?
   → Examples: Hierarchical, Network, Relational, Object-Oriented.

7. What is normalization?
   → Explain the process and purpose of reducing redundancy.

8. What are the different types of SQL commands?
   → Examples: DDL, DML, DCL, TCL.

9. What is a join in SQL? Name its types.
   → INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

10. What is the difference between DBMS and RDBMS?
    → Example: RDBMS supports relations and constraints; DBMS may not.

---

 

Part 2 : Advanced : 

---

1. What do you mean data independence? Explain.

   ---

2. Define database languages.

   ---

    

3. Define super key, candidate key, Primary key, and unique key.

   ---

    

4. Discuss Relational Database Model concept in detail.

   ---

    

5. Define the database management system and differentiate it from the file processing system.

   ---

    

6. Who is a DBA? What are the responsibilities of a DBA?

   ---

    

7. Define single-valued, multi-valued, derived, and composite attributes with suitable examples.

   ---

    

8. What do you mean by constraints? Discuss Key Constraints, Entity Integrity Constraints, and Domain constraints with suitable examples.

   ---

    

9. What is SQL? Define characteristics of SQL in detail.

   ---

    

10. Draw the overall structure of DBMS and explain its various components in detail.

    ---

     

11. Explain different Components of an ER Diagram with their Notation. Also make an ER Diagram for Employee Project Management System.

    ---

     

12. What do you mean by schema? explain Three level data abstraction architecture.

    ---

     

13. What is aggregate function? explain with suitable examples.

    ---

     

14. Consider the following schema for institute library:

Student (RollNo, Name, Father_ Name, Branch)

Book (ISBN, Title, Author, Publisher)

Issue (RollNo, ISBN, Date-of –Issue)

Write the following queries in SQL and relational algebra:

List roll number and name of all students of the branch ‘CSE’.

 II. Find the name of student who has issued a book published by ‘ABC’ publisher.

 III. List title of all books and their authors issued to a student ‘RAM’.

 IV. List title of all books issued on or before December 1, 2020.

 V.         List all books published by publisher ‘ABC’

---

15. Consider the above relational database, where the primary keys are underlined. Give an expression in the SQL query to express each of the above  queries.

    ---

 

 

Normalisation