W10 Quiz

Question 1

In order to access a request’s body data, the request must first pass through which middleware?

Accepted Answer

express.json()

Question 2

Using the res.json() method will set the Content-Type header to JSON on the:

Accepted Answer

Response

Question 3

Express routes should be ordered from specific to generic

Accepted Answer

True

Question 4

How many JOIN statements can you have in one query?

Accepted Answer

Any number

Question 5

Who is pictured? (one of Jojo's favorite historical figures)

Accepted Answer

Dmitri, Harry Potter, The Boy Who Lived, Composer of a famous 22-measure ostinato theme

Question 6

What is Express?

Accepted Answer

A backend framework to develop servers and APIs

Question 7

Given a table “puppies” with 10 records, what would the statement "DELETE FROM puppies;" do?

Accepted Answer

Delete all puppies

Question 8

A Many to Many relationship does NOT need a JOIN table

Accepted Answer

False

Question 9

Which SQL keyword is used to sort the result-set?

Accepted Answer

ORDER BY

Question 10

How many arguments does an error handling middleware take in?

Accepted Answer

4

Question 11

True or False? This will SUCCESSFULLY insert data

Accepted Answer

False

Question 12

When defining a column on a table, which piece of information is listed after the column name?

Accepted Answer

Data Type

Question 13

Which keyword would you use to restrict the maximum number of results of a query to a specific number?

Accepted Answer

LIMIT

Question 14

What&#x27;s one way to define a foreign key when creating a table? (SQL)

Accepted Answer

user_id INTEGER REFERENCES users (id)

Question 15

Which of these is NOT a valid SQL query operator?

Accepted Answer

MATCHES

Question 16

Which SQL keyword is used to assign a new value when updating a record?

Accepted Answer

SET

Question 17

Franco once had as a pet which speedy dog breed?

Accepted Answer

Afghan Hound, Italian Greyhound, Whippet, Border Collie

Question 18

By default, query results are ordered by their primary key in DESCENDING order (highest to lowest)

Accepted Answer

False

Question 19

The next() function is required to send a request from one middleware to another

Accepted Answer

True

Question 20

What does RDBMS stand for?

Accepted Answer

Relational Database Management System

Question 21

Which of these did Anthony NOT have as a pet growing up?

Accepted Answer

Rabbit, Hamster, Bird, Gecko

Question 22

Given an endpoint with a path of “/users/:id”, how would you retrieve the id value?

Accepted Answer

req.params.id

Questions 22