Database Management System [DBMS]

 Basics of DBMS:

a. Define what a database is and explain its advantages.

b. Differentiate between DBMS and RDBMS.

Relational Database Concepts:

a. Define the terms: table, tuple, attribute, and primary key.

b. Explain the concept of normalization and its importance in a relational database.

SQL Queries:

a. Write an SQL query to retrieve all records from a table named "Employees."

b. Explain the differences between the WHERE and HAVING clauses in SQL.

Database Design:

a. What is the purpose of a foreign key in a relational database?

b. Describe the steps involved in the normalization process.

Transaction Management:

a. Define the ACID properties in the context of database transactions.

b. Explain the concepts of commit and rollback in a database transaction.

Indexing and Query Optimization:

a. Discuss the importance of indexing in a database.

b. Explain how the query optimizer works in a relational database system.

Concurrency Control:

a. What is a deadlock in the context of database concurrency?

b. Discuss the various methods of handling concurrent transactions.

Data Integrity and Constraints:

a. Explain the concept of referential integrity in a relational database.

b. Define the CHECK constraint in SQL.

NoSQL Databases:

a. Compare and contrast SQL and NoSQL databases.

b. Provide examples of NoSQL databases and their use cases.

Database Security:

a. Discuss the importance of database security.

b. Describe techniques for securing a database, including access control and encryption.