Databases
The vast majority of software written by Software Development Engineers (SDEs) is stored on data-storage systems. A lot of the issues faced by techs come from figuring out the best way to get and hold data for the future. You’ll need to be familiar with the general concepts of databases and their uses. The more familiar you are with the trade-offs that exist between a relational database and a non-relational database, the better off you’ll be.
Topics |
Link |
---|---|
1. What are the advantages of DBMS over traditional file-based systems? | Link |
2. What are super, primary, candidate, and foreign keys? | Link |
3.What is database normalization? | Link |
4. Why is the use of DBMS recommended? Explain by listing some of its major advantages. | Link |
5. What are the differences between DDL, DML, and DCL in SQL? | Link |
6. What is the difference between having and where clause? | Link |
7. How to print duplicate rows in a table? | Link |
8. What is Join? | Link |
9.What is a view in SQL? How to create a view? | Link |
10. What is the difference between Trigger and Stored Procedure? | Link |
11. What is a transaction? What are ACID properties? | Link |
12. What are clustered and non-clustered Indexes? | Link |
13. What is CLAUSE in SQL? | Link |
14. Why are cursors necessary in embedded SQL? | Link |
15. What is the purpose of normalization in DBMS? | Link |
16. What is the difference between a database schema and a database state? | Link |
17. Explain the concepts of a Primary key and a Foreign Key. | Link |
18.What are the main differences between the Primary key and the Unique Key? | Link |
19. What is the use of the DROP command and what are the differences between DROP, TRUNCATE, and DELETE commands? | Link |
20. Explain Entity, Entity Type, and Entity Set in DBMS. | Link |
21. What are the different levels of abstraction in the DBMS? | Link |
22. What is the E-R model in the DBMS? | Link |
23. What is a functional dependency in the DBMS? | Link |
24. What are 1NF, 2NF, 3NF, and BCNF in DBMS? | Link |
25. What is RDBMS? | Link |
26. What are the different types of relationships in the DBMS? | Link |
27. What is the main goal of RAID technology? | Link |
Top Software Development Topics to prepare for Interview
Software development refers to a set of computer science activities dedicated to the process of creating, designing, deploying, and supporting software.
Table of Content
- Programming language
- Data structures
- Algorithms
- System Design
- Coding
- Object-oriented design
- Databases
- Distributed computing
- Operating systems
- Internet topics
- General machine learning and artificial intelligence
- Conclusion