Sign in to unlock

Get unlimited access to all questions and answers

checked

Get lifetime access

checked

Track progress

checked

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

T-SQL interview questions

T-SQL interview questions.

Only challenges
Topic progress: 0%
  • 1.

    Is it possible to rename a database? If so, how would you rename the database?

    premium question
    completed

    Answer:

  • 2.

    Mention what is TOP in TSQL?

    premium question
    completed

    Answer:

  • 3.

    What is TSQL Window functions?

    premium question
    completed

    Answer:

  • 4.

    Explain what are the differences between SQL and T-SQL?

    premium question
    completed

    Answer:

  • 5.

    What are the new error handling commands introduced with SQL Server 2005 and beyond?

    premium question
    completed

    Answer:

  • 6.

    Could you explain the difference between Primary Key and Unique Index?

    premium question
    completed

    Answer:

  • 7.

    Name 5 commands that can be used to manipulate text in T-SQL code

    premium question
    completed

    Answer:

  • 8.

    When should I use primary key or index?

    premium question
    completed

    Answer:

  • 9.

    Mention what are the limitations of IDENTITY column?

    premium question
    completed

    Answer:

  • 10.

    What are the three ways that Dynamic SQL can be issued?

    premium question
    completed

    Answer:

  • 11.

    What are the two commands to remove all of the data from a table? Are there any implications with the specific commands?

    premium question
    completed

    Answer:

  • 12.

    Mention what is subquery?

    premium question
    completed

    Answer:

  • 13.

    Mention what is OFFSET-FETCH filter in tsql?

    premium question
    completed

    Answer:

  • 14.

    How can you delete duplicate records in a table with no primary key?

    premium question
    completed

    Answer:

  • 15.

    Mention what are the Join Types in TSQL?

    premium question
    completed

    Answer:

  • 16.

    What are types of XML indexes in SQL Server?

    premium question
    completed

    Answer:

  • 17.

    Is there a difference between T-SQL linked server and a synonym?

    premium question
    completed

    Answer:

  • 18.

    What are the practical differences between COALESCE() and ISNULL(,'')?

    premium question
    completed

    Answer:

  • 19.

    Mention what does the T-SQL command IDENT_CURRENT does?

    premium question
    completed

    Answer:

  • 20.

    Mention what is uncommittable transactions?

    premium question
    completed

    Answer:

  • 21.

    In what version of SQL Server were synonyms released, what do synonyms do and when could you make the case for using them?

    premium question
    completed

    Answer:

  • 22.

    What two commands were released in SQL Server 2005 related to comparing data sets from two or more separate SELECT statements?

    premium question
    completed

    Answer:

  • 23.

    What's the difference between TRUNCATE and DELETE in SQL?

    premium question
    completed

    Answer:

  • 24.

    Mention what are ROLLUP and CUBE in T-SQL?

    premium question
    completed

    Answer:

  • 25.

    What are bitwise operators and what is the value from a database design perspective?

    premium question
    completed

    Answer:

  • 26.

    How can you capture the length of a column when it is a Text, NText and/or Image data type?

    premium question
    completed

    Answer:

  • 27.

    Provide an example of Left Outer Join with Exclusions

    premium question
    completed

    Answer:

  • 28.

    What is the use of GO in Transact SQL?

    premium question
    completed

    Answer:

  • 29.

    What is the difference between EXEC vs sp_executesql?

    premium question
    completed

    Answer:

  • 30.

    Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?

    premium question
    completed

    Answer:

  • 31.

    What do Clustered and Non clustered index actually mean?

    premium question
    completed

    Answer:

  • 32.

    What is the difference between PARTITION BY and GROUP BY

    premium question
    completed

    Answer:

  • 33.

    What is the native system stored procedure to issue a command against all databases?

    premium question
    completed

    Answer:

  • 34.

    Is it correct/best practice to have the TRY/CATCH block inside the transaction or should the transaction be inside the TRY block?

    premium question
    completed

    Answer:

  • 35.

    What are the best practices for using a GUID as a primary key, specifically regarding performance?

    premium question
    completed

    Answer:

  • 36.

    From a T-SQL perspective, how would you prevent T-SQL code from running on a production SQL Server?

    premium question
    completed

    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 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

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

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 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

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

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

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

folder icon

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.

graph icon

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.

clock icon

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.

amazon logo facebook logo google logo microsoft logo uber logo
Prepare for a technical interview

Get hired with our
tech interview questions & answers