Databases Interview Questions | Glassdoor

Databases Interview Questions

59

interview questions shared by candidates

Databases Interview Questions

Sort: RelevancePopular Date

What are some of the things you might consider when designing a database?

2 Answers

(Books have been written about this). "Normalization vs. denormalization, data model accurately reflects problem domain, adaptability / maintainability, performance, indexing, partitioning.

The key aspects to consider are normalization vs. denormalization, partitioning, data model accurately reflects problem domain, adaptability and maintainability, performance, and indexing

How well can you come up to speed working with Ruby and in a custom non-relational database environment?

1 Answer

Write a SQL command that returns users' order history and the total cost of each order including shipping. There are 3 tables: users table, orders table, order details table.

3 Answers

If you have two SQL database tables that are not joined together, how would you create another table to join them.

3 Answers

You have gained access to a Web server with a SQL backend. What SQL command could be used to gain access to the SQL database's underlying Operating System?

2 Answers

I was asked about how to avoid data corruption in relational databases. (very broadly, not specifics)

2 Answers

How to you pick up (almost) real-time changes from database tables?

2 Answers

What databases have you worked with

1 Answer

In a general book shop setting, can you bring the necessary spectrum of knowledge: (a) Will you be able to engage the interest of a toddler, an eight-year-old, a teen, and their parents? The erudite and the common? Mystery or history? (b) Do you know enough about the world to satisfy every taste, within reason? (c) Are you willing, within reason, to drop any feelings or opinions that may incline you to censor the reading materials you offer - or special order if they are too offensive to live on your shelves?

1 Answer

Describe your experience with databases.

1 Answer
110 of 59 Interview Questions