1.
Define a temp table
Sign in to unlock
Get unlimited access to all questions and answers
Get lifetime access
Track progress
Save time
The fastest way to prepare
for a tech interview
Check our curated list of full-stack, data structures & software architecture interview questions and answers for developers
Web & Mobile dev Web & Mobile dev
Data structures & Algorithms Data structures
Software Architecture Design patterns
ADO.NET
Android
Angular AngularJS ASP.NET ASP.NET MVC ASP.NET Web API
C#
CSS
DevOps
Entity Framework
Flutter
Git
Golang
GraphQL
HTML5
Ionic
Java
JavaScript
jQuery
Kotlin
Laravel
LINQ
MongoDB .NET Core
Node.js
OOP
PHP
PWA
Python
React
React Native
Reactive Programming
Redis
Redux
Ruby
Ruby on Rails
Testing
Spring
SQL
T-SQL
TypeScript
UX Design
Vue.js
WCF
Web Security
WebSockets
Xamarin SQL interview questions.
Only challenges
- 2.
What is a view?
Answer:
- 3.
What is PRIMARY KEY?
Answer:
- 4.
What is blocking?
Answer:
- 5.
What is Normalization?
Answer:
- 6.
What is the difference between WHERE clause and HAVING clause?
Answer:
- 7.
What is DEFAULT?
Answer:
- 8.
What is FOREIGN KEY?
Answer:
- 9.
What’s the difference between a local temp table and a global temp table?
Answer:
- 10.
How can a column with a default value be added to an existing table?
Answer:
- 11.
Is table size reduced, when you delete data from the table?
Answer:
- 12.
Define ACID Properties
Answer:
- 13.
Discuss INNER JOIN ON vs WHERE clause
Answer:
- 14.
What is the difference between “INNER JOIN” and “OUTER JOIN”?
Answer:
- 15.
What is the difference between JOIN and UNION?
Answer:
- 16.
What is the difference between UNION and UNION ALL?
Answer:
- 17.
What are the advantages of using Stored Procedures?
Answer:
- 18.
How do I perform an IF…THEN in an SQL SELECT?
Answer:
- 19.
What is the difference between inner and outer join?
Answer:
- 20.
Describe the difference between truncate and delete
Answer:
- 21.
What is Denormalization?
Answer:
- 22.
What are the difference between clustered and a non-clustered index?
Answer:
- 23.
How a database index can help performance?
Answer:
- 24.
What is a cursor how does it work?
Answer:
- 25.
What are row constructors?
Answer:
- 26.
Explain Function vs. Stored Procedure in SQL Server
Answer:
- 27.
What is collation?
Answer:
- 28.
Finding duplicate values in a SQL table
Answer:
- 29.
How to select first 5 records from a table?
Answer:
- 30.
How does a hash table index work?
Answer:
- 31.
How do I UPDATE from a SELECT in SQL Server?
Answer:
- 32.
What is a filegroup?
Answer:
- 33.
What is the cost of having a database index?
Answer:
- 34.
How does truncate and delete operation effect Identity?
Answer:
- 35.
What are DMV's and DMF's?
Answer:
- 36.
How does B-trees index work?
Answer:
- 37.
How deadlock is resolved?
Answer:
- 38.
What are statistics?
Answer:
- 39.
What is a linked server?
Answer:
- 40.
Explain the difference between exclusive lock and update lock
Answer:
- 41.
What is the difference among UNION, MINUS and INTERSECT?
Answer:
- 42.
How can we transpose a table using SQL (changing rows to column or vice-versa) ?
Answer:
- 43.
What's the difference between a primary key and a unique key?
Answer:
- 44.
Name types of Triggers
Answer:
- 45.
Explain a usage difference between user defined functions and stored procedures
Answer:
- 46.
What is Optimistic Locking and Pessimistic locking?
Answer:
- 47.
Select first row in each GROUP BY group (greatest-n-per-group problem)?
Answer:
- 48.
How does database indexing work?
Answer:
- 49.
What are some other types of indexes?
Answer:
- 50.
Name some disadvantages of a hash index
Answer:
- 51.
How does primary key constraint and unique key constraint effect null?
Answer:
- 52.
How can I do an UPDATE statement with JOIN in SQL?
Answer:
- 53.
How to generate row number in SQL Without ROWNUM
Answer:
- 54.
What would happen without an index?
Answer:
- 55.
Delete duplicate values in a SQL table
Answer:
- 56.
Insert results of a stored procedure into a temporary table
Answer:
One tip that got me hired by Google, Microsoft, and Stripe
I've worked for Microsoft, Google, Stripe, and received offers from many other companies. One thing I learned when I was interviewing myself is that standard interview tips are woefully inadequate.
Reverse Tech Interview: Questions to Stump an Interviewer
Few people want to get into an uncomfortable environment or an unprofitable company with no prospects. If you’re wondering how to get a real feel for a company during an interview, you’re welcome. I’ll give a list of questions that interviewers don’t usually expect...
How to become a programmer, move to the US, and get a dream job
Are you curious about what you need to do to earn more than $15.000 a month, drive a Tesla, live in sunny California, and work at Google, Apple, Facebook, or Amazon?
11 Reactive Systems interview questions and answers for software engineers Reactive Systems
Reactive systems are an architectural style that allows multiple individual applications to blend into one unit, reacting to their environment, while staying aware of each other. Here is a list of coding interview questions on Reactive Systems to help you get ready for your next data struc...
Reactive Systems
34 Microservices interview questions and answers for software engineers Microservices
Microservice architecture – a variant of the service-oriented architecture structural style – arranges an application as a collection of loosely coupled services. In a microservices architecture, services are fine-grained and the protocols are lightweight. Here is a list of coding intervie...
Microservices
7 Layering & Middleware interview questions for developers Layering & Middleware
Middleware in the context of distributed applications is software that provides services beyond those provided by the operating system to enable the various components of a distributed system to communicate and manage data. Middleware supports and simplifies complex distributed application...
Layering & Middleware
55 Docker interview questions and answers for software engineers Docker
Docker is a set of platform as a service products that use OS-level virtualization to deliver software in packages called containers. Here is a list of coding interview questions on Docker to help you get ready for your next data structures interview in 2021.
Docker
23 Databases interview questions and answers for software engineers Databases
A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques. Here is a list of coding interview questions on Databases to help you g...
Databases
21 Concurrency interview questions and answers for software engineers Concurrency
In computer science, concurrency is the ability of different parts or units of a program, algorithm, or problem to be executed out-of-order or in partial order, without affecting the final outcome. Here is a list of coding interview questions on Concurrency to help you get ready for your n...
Concurrency
13 CAP Theorem interview questions and answers for software engineers CAP Theorem
In theoretical computer science, the CAP theorem, also named Brewer's theorem after computer scientist Eric Brewer, states that it is impossible for a distributed data store to simultaneously provide more than two out of the following three guarantees: Consistency: Every read receives the ...
CAP Theorem
Load more posts
Features
Access all answers
Get the inside track on what to expect in your next tech interview. We offer you a collection of high quality technical interview questions to help you prepare for your next coding interview.
Track progress
A smart interface helps you track your progress and focus on the topics you need. You can search through questions or sort them by difficulty or type.
Save time
Save tens of hours searching for information on hundreds of low-quality sites designed to drive traffic and make money from advertising.
Land a six-figure job at one of the top companies.
Prepare for a technical interview
Get hired with our
tech interview questions & answers
