Databases/MongoDB/Mongoose Flashcards

1
Q

What is SQL?

A

Structured Query Language. The language used for interacting with relational databases.

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

What is NoSQL?

A

A play on “SQL”, describing a type of database that doesn’t use SQL and is considered “non-relational”

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

The language used for interacting with relational databases

A

SQL

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

Another term for a non-relational database

A

NoSQL. This is just a play on the term SQL, but isn’t itself a real language.

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

What is a single resource called in a SQL database?

A

Record

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

What is a single resource called in a NoSQL database?

A

A document

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

What is the structure in a SQL/relational database called that contains multiple records?

A

Table

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

What is a table in a SQL database?

A

The structure in a relational database that contains multiple records

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

What is the structure in a NoSQL/non-relational database called that contains multiple documents?

A

Collection

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

What is a collection in a no-SQL database?

A

The structure in a non-relational database that contains multiple documents

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

What is a primary key?

A

In a SQL database, primary key refers to a record’s ID of the same table

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

What is a foreign key?

A

In a SQL database, foreign key refers to a record’s ID from another (foreign) table.

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

What is a model?

A

A representation of of the documents that will be saved to the database. Like a blueprint outlining all the properties of a database

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