Sql Interview Questions | Glassdoor

Sql Interview Questions

115

interview questions shared by candidates

Sql Interview Questions

Sort: RelevancePopular Date

What command would you use to retrieve one row of data from a table using SQL?

1 Answer

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 is the difference between a right join and an inner join?

1 Answer

What is a stored procedure ?

1 Answer

What is the difference between an inner and an outer join.

1 Answer

If a parent record was accidentally deleted without removing the child records, what query could you use to determine what records were "orphaned".

1 Answer

What is a Common Table Expression?

1 Answer

link two tables together in MySQL.

1 Answer

Please point out the coding errors or bugs in this SQL example.

1 Answer

Do you have experience with writing SQL

1 Answer
6170 of 115 Interview Questions