SQL Developer Interview Questions | Glassdoor

SQL Developer Interview Questions

126

SQL developer interview questions shared by candidates

Top Interview Questions

Sort: Relevance Popular Date

During phone interview, which was from India. The Interviewer was asking a series of SQL questions.

1 Answer

The phone call was cutting in and out and the call dropped twice. The interviewer was very hard to understand, and they based that on their selection

What's the longest piece of code you've written?

1 Answer

Nothing much really but one individual ask more nuts and bold questions. What is the size of big int or 10 min to build tree structure

2 Answers

What is the ascii code for line feed?

1 Answer

If I knew what the cross apply operator was

2 Answers

We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??

1 Answer

What's the difference between TRUNCATE and DELETE

1 Answer

How to remove duplicate records

2 Answers
110 of 126 Interview Questions