Databases

Question 1

What is a popular relational database?

Answer 1

MySQL

Question 2

What is a popular key-value store database?

Answer 2

Dynamo

Question 3

What is a popular document database?

Answer 3

MongoDB

Question 4

What is a popular wide-column database?

Answer 4

Cassandra

Question 5

What is a popular graph database?

Answer 5

Neo4J

Question 6

Can you alter a SQL/relational DB schema?

Answer 6

Yes, but requires modifying the entire DB and going offline

Question 7

When can you add columns to a NoSQL schema?

Answer 7

On the fly

Question 8

In a NoSQL DB, does each entity need to contain data for each column?

Answer 8

No

Question 9

What type of DB has more powerful querying?

Answer 9

SQL/Relational

Question 10

How do you scale a relational DB?

Answer 10

Vertically by increasing horsepower of hardware like higher memory, CPU

Question 11

What is the downside of scaling a (relational) DB vertically?

Answer 11

Expensive

Question 12

Can you scale a relational DB across multiple servers?

Answer 12

Yes, but challenging and time consuming

Question 13

How do you scale a non-relational DB?

Answer 13

Horizontally by adding more servers

Question 14

What type of DB is cheaper to scale

Answer 14

Non-relational

Question 15

What type of DB is better for ACID compliancy and data reliability

Answer 15

Relational

Question 16

Non-relational DBs sacrifice ACID compliance for what?

Answer 16

Performance and scalability

Question 17

What kind of DB is preferred for ecommerce/finance?

Answer 17

SQL

Question 18

Why would ecommerce and finance prefer SQL DBs?

Answer 18

ACID compliance

Question 19

When you do not want data to be the bottleneck, which type of DB to choose?

Answer 19

NoSQL

Question 20

When storing large volumes of data that have little to no structure, which DB?

Answer 20

NoSQL

Question 21

Which DB when you want to easily and cheaply scale

Answer 21

NoSQL

Question 22

Which DB is better for rapid development?

Answer 22

NoSQL