SQL database administrator interview questions shared by candidates
If I face a total systems failure, what would I do?
It would depend on exactly what the failure was (power, connectivity, server, storage, cloud). In some circumstances, I could fire off virtual instances to take the load, move the cloud to online resources, or put up notices that resource X was available at URL Y, but Resource Z was down.
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??
See Interview Questions for Similar Jobs
- Medical Assistant
- Mechanical Engineer
- Dental Assistant
- Account Executive
- Graphic Designer
- Pharmacy Technician
- Administrative Assistant