Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Technical Interview > SQL, noSQL > Flashcards

SQL, noSQL Flashcards

1
Q

What databases have you worked on ?

A
  • MongoDB
  • Cassandra
  • Neo 4J
  • Redis
  • Elastic Search
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What did you use MongoDB for ?

A

JSON Storage (document storage), good read/write balance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What did you use Cassandra for ?

A
  • Large data storage

- Very good write performances and scalability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What did you use Redis for ?

A
  • For Caching mostly
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What did you use Elastic Search for ?

A
  • Index of metadatas for Operator UI

- Logging and monitoring with Graphana, Kibana

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which database needs pre-defined schemas ?

A

SQL Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which database requires data to follow the same structure ?

A

SQL Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which DBs are vertically scalable ?

A

SQL Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Define vertically scalable

A

Can increase load on a single server with increase of CPU, RAM, SSD.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Give me SQL Databases ?

A
  • My SQL

- Oracle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is a nonSQL database ?

A
  • Dynamic schema for unstructured data
  • can be column oriented
  • can be document oriented
  • can be graph based
  • can be key-value
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Give 4 advantages of nonSQL databases ?

A
  • Can create documents without having to define their structure first ?
  • Each document can have its own unique architecture
  • Syntax can vary from database to database
  • Can add fields as you go
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How scalable are non-SQL databases ?

A

Horizontally Scalable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Define Horizontally Scalable

A
  • You can handle more by shardig

- you can add more servers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Why is Mongo DB a good choice for businesses ?

A
  • It can scale easily for rapid growths
  • it can handle no clear schema definition for dynamic data handling
  • if you cannot define a schema for your dv
  • if your schema continues to change
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the main difference between REDIS and MongoDB ?

A
  • Redis is a key/value storage

- Mongo is a document store

17
Q

What is the main advantage of MongoDB ?

A

Best at structuring or modeling information with relations between them

18
Q

What is the main advantage of Redis ?

A

It’s awesome at storing unrelated pieces of information with rapidly changing data

19
Q

What is etcd ?

A

Its a general substrate for large scale distributed systems

20
Q

Whad are the advantages of the etcd cluster ?

A
  • key-value storage with stability
  • scalability
  • performances
21
Q

Give me 3 examples of best Redis Usage ?

A
  1. Real-time analytics
  2. Leaderboards
  3. Real time communications
22
Q

What format are data stored in Mongo DB ?

A

JSON

23
Q

What replication is MongoDB built on ?

A

Master/Slave replication with auto failover

24
Q

Which DB uses javascript expressions as queries ?

A

MongoDB

25
Q

What is Mongo best usage ?

A
  • CRM systems

- simple CMS systems

26
Q

Does MongoDB manage versioning ?

A

Yes

Technical Interview (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions