Databases/MongoDB/Mongoose

Question 1

What is SQL?

Answer 1

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

Question 2

What is NoSQL?

Answer 2

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

Question 3

The language used for interacting with relational databases

Answer 3

SQL

Question 4

Another term for a non-relational database

Answer 4

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

Question 5

What is a single resource called in a SQL database?

Answer 5

Record

Question 6

What is a single resource called in a NoSQL database?

Answer 6

A document

Question 7

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

Answer 7

Table

Question 8

What is a table in a SQL database?

Answer 8

The structure in a relational database that contains multiple records

Question 9

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

Answer 9

Collection

Question 10

What is a collection in a no-SQL database?

Answer 10

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

Question 11

What is a primary key?

Answer 11

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

Question 12

What is a foreign key?

Answer 12

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

Question 13

What is a model?

Answer 13

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