1. What is DBMS?
A DBMS (Database Management System) is software that allows users to create,
store, manage, and retrieve data efficiently from databases.
2. What is a database?
A database is an organized collection of related data stored electronically for easy
access, management, and updating.
3. What is a data model?
A data model defines how data is structured, related, and manipulated within a
database system.
4. What is an entity?
An entity is any real-world object or concept that can have data stored about it in a
database, such as a student or product.
5. What is an attribute?
An attribute is a property or characteristic of an entity — for example, a student
entity might have Name, ID, and Age attributes.
6. What is a primary key?
A primary key is a unique field or combination of fields that identifies each record
in a table.
7. What is a foreign key?
A foreign key is a field in one table that links it to the primary key of another table
to maintain relationships between data.
8. What is normalization?
Normalization is the process of organizing data in tables to reduce redundancy and
improve data integrity.
9. What is a transaction?
A transaction is a sequence of operations performed as a single logical unit of
work within a database.
10. What are ACID properties?
ACID stands for Atomicity, Consistency, Isolation, and Durability — the four
properties that ensure reliable transaction processing.
, 11. What is a relational database?
A relational database stores data in tables (relations) consisting of rows and
columns, where each table represents an entity.
12. What is SQL?
SQL (Structured Query Language) is the standard language used to manage and
manipulate relational databases.
13. What is a view in SQL?
A view is a virtual table created from a query; it displays data from one or more
tables without storing it physically.
14. What is a join in SQL?
A join combines data from two or more tables based on a related column between
them.
15. What is a deadlock?
A deadlock occurs when two or more transactions hold resources that the others
need, causing each to wait indefinitely.
16. What is data integrity?
Data integrity refers to maintaining accuracy, consistency, and reliability of data
throughout its lifecycle.
17. What is a schema?
A schema is the overall logical design or blueprint of a database that defines its
structure, tables, and relationships.
18. What is a trigger?
A trigger is a stored program that automatically executes in response to specific
events on a table (like insert or update).
19. What is indexing?
Indexing is the process of creating data structures to speed up data retrieval
operations in a database.
20. What is a distributed database?
A distributed database stores data across multiple physical locations but appears as
a single logical database to users.
A DBMS (Database Management System) is software that allows users to create,
store, manage, and retrieve data efficiently from databases.
2. What is a database?
A database is an organized collection of related data stored electronically for easy
access, management, and updating.
3. What is a data model?
A data model defines how data is structured, related, and manipulated within a
database system.
4. What is an entity?
An entity is any real-world object or concept that can have data stored about it in a
database, such as a student or product.
5. What is an attribute?
An attribute is a property or characteristic of an entity — for example, a student
entity might have Name, ID, and Age attributes.
6. What is a primary key?
A primary key is a unique field or combination of fields that identifies each record
in a table.
7. What is a foreign key?
A foreign key is a field in one table that links it to the primary key of another table
to maintain relationships between data.
8. What is normalization?
Normalization is the process of organizing data in tables to reduce redundancy and
improve data integrity.
9. What is a transaction?
A transaction is a sequence of operations performed as a single logical unit of
work within a database.
10. What are ACID properties?
ACID stands for Atomicity, Consistency, Isolation, and Durability — the four
properties that ensure reliable transaction processing.
, 11. What is a relational database?
A relational database stores data in tables (relations) consisting of rows and
columns, where each table represents an entity.
12. What is SQL?
SQL (Structured Query Language) is the standard language used to manage and
manipulate relational databases.
13. What is a view in SQL?
A view is a virtual table created from a query; it displays data from one or more
tables without storing it physically.
14. What is a join in SQL?
A join combines data from two or more tables based on a related column between
them.
15. What is a deadlock?
A deadlock occurs when two or more transactions hold resources that the others
need, causing each to wait indefinitely.
16. What is data integrity?
Data integrity refers to maintaining accuracy, consistency, and reliability of data
throughout its lifecycle.
17. What is a schema?
A schema is the overall logical design or blueprint of a database that defines its
structure, tables, and relationships.
18. What is a trigger?
A trigger is a stored program that automatically executes in response to specific
events on a table (like insert or update).
19. What is indexing?
Indexing is the process of creating data structures to speed up data retrieval
operations in a database.
20. What is a distributed database?
A distributed database stores data across multiple physical locations but appears as
a single logical database to users.
