Database Interview Questions

5,611 database interview questions shared by candidates

1. Very specific database related problem in MongoDB. Given a collection, a set of indexes and a set of queries, would adding a particular index help and why? 2. Given a set of index servers in a data center that has 2 GBPS ethernet WAN capacity, describe a most efficient way to transfer the index files (100 M each) to a set of 10 web servers in a different data center with equivalent receiving ethernet speed at the same time without any data loss. 3. What are some of the Percona utilities that you have used for MySQL and the monitoring tools. Why do you like a certain tool better over the other? (mainly to describe the features of the tool used). 4. Describe the architectural strategy or options to design your data servers in such a way that for those candidates to access their resume data that is stored in a remote data center after they have moved to a different geographic region that is closer to another data center, is the most optimal.
avatar

Database Engineer

Interviewed at Indeed

3.8
May 10, 2015

1. Very specific database related problem in MongoDB. Given a collection, a set of indexes and a set of queries, would adding a particular index help and why? 2. Given a set of index servers in a data center that has 2 GBPS ethernet WAN capacity, describe a most efficient way to transfer the index files (100 M each) to a set of 10 web servers in a different data center with equivalent receiving ethernet speed at the same time without any data loss. 3. What are some of the Percona utilities that you have used for MySQL and the monitoring tools. Why do you like a certain tool better over the other? (mainly to describe the features of the tool used). 4. Describe the architectural strategy or options to design your data servers in such a way that for those candidates to access their resume data that is stored in a remote data center after they have moved to a different geographic region that is closer to another data center, is the most optimal.

They want to know what experience you have (of course) but aren't specifically looking for you to say you're a computer science guru. Mainly they want to get a sense of your character and work ethic. They might ask how you'd respond in some example situations regarding design or how you might interact with a client. They may show you a web site and ask for your opinion on usability or what alterations you might make, and why.

Database Manager

Interviewed at LightsAmerica

4
Apr 11, 2016

They want to know what experience you have (of course) but aren't specifically looking for you to say you're a computer science guru. Mainly they want to get a sense of your character and work ethic. They might ask how you'd respond in some example situations regarding design or how you might interact with a client. They may show you a web site and ask for your opinion on usability or what alterations you might make, and why.

Viewing 951 - 960 interview questions

Glassdoor has 5,611 interview questions and reports from Database interviews. Prepare for your interview. Get hired. Love your job.