Test Your Understanding

Duration: 30 Minutes

Section 1: Database

1. What is a database?
2. List 2 or more types of database
3. What is a primary key in a database?
4. Assume you have a table called `POST`, write an SQL statement to fetch all posts.
5. What is CRUD in the context of database operations?

Section 2: APIs

1. What is an API?
2. Name four HTTP methods used in RESTful APIs and briefly explain their purposes.
3. What does the HTTP status code 404 indicate?
4. Explain the difference between PUT and CREATE HTTP methods.
5. What category of status codes does the 2xx series represent?

Section 3: FastAPI

Write a short essay on FastAPI, what it is, how it is installed and its alternatives.

Section 4: SQLAlchemy

1. What is an ORM?
2. What is SQLAlchemy?
3. How do you install SQLAlchemy?
4. What is the difference between ORM models and Pydantic models?