Sql database administrator Interview Questions | Glassdoor

Sql database administrator Interview Questions

81

sql database administrator interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

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

2 Answers

Without being able to restructure the existing schema your only choice is to de-normalize the data. When the data gets loaded on that weekly schedule, also build a flat table so there are no relationships being built.

Create a denormalized view with indexes on it for most frequently asked questions and read directly from that!

Do you like cats?

2 Answers

Index tipping

1 Answer

what I do at Downtime.

1 Answer

Cluster environment experience

1 Answer

How would I handle a performance issue

1 Answer

None that I could not answer with conviction or clarification.

1 Answer

Easy stuff. Nothing tough at all in the technical interview.

1 Answer

will you be able to do help desk job?

1 Answer

How much experience do you have with data warehousing?

1 Answer
110 of 81 Interview Questions