When would you use a NoSQL database, and when would using a relational database be better?
This question may seem similar to the one you were asked earlier in the interview. Interviewers will ask similar questions throughout the interview to explore a topic in more detail or calibrate your answers. This question helps them determine if you are fabricating some of the information you are providing and if you are being consistent throughout the interview. Keeping your answers brief and to the point and not making up answers if you don't understand the topic will ensure that you are consistent.
"Relational databases such as Oracle are based on transaction-oriented data stores and are the most commonly used for most applications. They are flexible and applicable to many different situations. The issues with relational databases are their performance and ability to scale when dealing with large data sets. NoSQL databases are more applicable in situations requiring high availability, applications dealing with terabytes or petabytes of data, and where querying and inserting information to and from the database is required."
