DCA - TCS Digital Interview Questions 2025

DCA Interview

1. What is DBMS and what are its advantages?
2. What is a primary key and how is it different from a foreign key?
3. What is normalization and why is it important in DBMS?
4. What are the different types of normalization and explain each of them?
5. What is a transaction in DBMS and what are its properties?
6. What is concurrency control in DBMS and how is it implemented?
7. What is a join in DBMS and what are its types?
8. What is an index in DBMS and why is it used?
9. What are the different types of indexes and explain each of them?
10. What is a view in DBMS and why is it used?
11. What are the different types of views and explain each of them?
12. What is a trigger in DBMS and why is it used?
13. What are the different types of triggers and explain each of them?
14. What is a stored procedure in DBMS and why is it used?
15. What is a cursor in DBMS and how is it used?
16. What is a subquery in DBMS and what are its types?
17. What is a deadlock in DBMS and how is it prevented?
18. What is a constraint in DBMS and what are its types?
19. What is a database schema and how is it different from a database instance?
20. What is a backup and recovery in DBMS and why is it important?
21. What is a log file in DBMS and why is it used?
22. What is a database trigger and what is its purpose?
23. What is a data dictionary in DBMS and why is it important?
24. What is normalization and what are its different forms?
25. What is a data model and what are its types?
26. What is a relational database and what are its advantages?
27. What is a NoSQL database and what are its advantages?
28. What is ACID in DBMS and why is it important?
29. What is the difference between a clustered and a non-clustered index?
30. What is a database replication and what is its purpose?