Brainscape's Knowledge GenomeTM

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


See full index

CSCI 112 > 02 - NoSQL: Not Only SQL > Flashcards

02 - NoSQL: Not Only SQL Flashcards

1
Q

T/F

NoSQL is BASE compliant

A

T

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

T/F

NoSQL databases are usually normalized.

A

F
non-normalized

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

Explain

CAP Theorem

A

For any distributed system, you can only have two of the three properties simultaneously.

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

In its DEFAULT mode of operations, which properties does MongoDB implement?

A

Partition Tolerance
Consistency

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

The BASE property that states the system may change over time even without input

A

Soft-State

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

List

CAP Theorem

A

Consistency
Availability
Partition Tolerance

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

Define

Consistency

A

Ensuring that every request​ receives the most recent write

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

Define

Availability

A

Ensuring that all systems produce a non-error response

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

Define

Partition Tolerance

A

Ensuring that the system can survive the loss of a partition

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

List

ACID Compliance

A

Atomic
Consistent
Isolated
Durable

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

Define

Atomic - ACID Compliance

A

Complete success or failure

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

Define

Consistent - ACID

A

Data always follows schema and always returns the correct result

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

Define

Isolated

A

One transaction cannot interfere with another

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

Define

Durable

A

Ensure that changes are permanent

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

List

BASE

A

Basic Availability
Soft-state
Eventual consistency

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

Define

Basic Availability - BASE

A

Highly available

17
Q

Define

Soft-state - BASE

A

System may change over time even without input

18
Q

Define

Eventual consistency - BASE

A

System will be consistent over time as long as there is no more additional input

19
Q

Differentiate: SQL vs NoSQL

Representation

A

SQL: Multiple tables, each containing columns and rows
NoSQL: Collection of documents; single table with keys and values

20
Q

SQL vs NoSQL

Primary Informer

A

SQL: Entities
NoSQL: Access patterns

21
Q

SQL vs NoSQL

Data Design

A

SQL: Normalized relational or dimensional data warehouse
NoSQL: Denormalized document, wide column or key value

22
Q

SQL vs NoSQL

Query Style

A

SQL: Language: SQL
NoSQL: Language: multiple depending on database service

23
Q

SQL vs NoSQL

Scaling

A

SQL: Vertical scaling
NoSQL: Horizontal scaling

CSCI 112 (7 decks)

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