Some of the technical interview questions are:
- What functions does an operating system have?
- What’s the difference between PRIMARY and UNIQUE key constraints?
- How do you get rid of a table’s duplicate row?
- What is the purpose of the SQL Profiler?
- What is a stored procedure, exactly? Use an example to demonstrate your point.
- What is the difference between a process and a thread?
- What are the benefits of using a thread? What does multithreading look like in practise?
- What is the difference between multi-processing and multitasking?
- What is the difference between a stack and a queue, and what are their applications?
- What is indexing, and what are its benefits and drawbacks?
- What is De-Normalization and what role does it play in society?
- What Are the Different Objects in a Database Management System?
- What is the difference between Self-Join and Outer Join, and how do you use them?
- Give an example of a SQL query that employs an outer join.