CRUD with SQLAlchemy — The Full Resource Pattern — Concept Check
Questions on CRUD with SQLAlchemy — The Full Resource Pattern. The complete CRUD recipe: Pydantic In/Out schemas with from_attributes, add/commit/refresh on create, exclude_unset for PATCH, IntegrityError → 409, and eager loading to kill N+1 queries.
Questions in this quiz
8 questions on CRUD with SQLAlchemy — The Full Resource Pattern — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.A developer is trying to create a new student entry but encounters an IntegrityError. What does this likely indicate?
- AThe email address is already registered.
- BThe student ID is invalid.
- CThe CGPA value is out of range.
- DThe database is down.
2.A service is experiencing slow performance when listing students and their offers. What could be the cause?
- AIncorrect database indexing.
- BExcessive logging in the application.
- CNetwork latency issues.
- DN+1 query problem due to lazy loading.
3.When updating a student record, which SQLAlchemy feature ensures only provided fields are updated?
- Aexclude_unset
- Bjoinedload
- Cfrom_attributes
- Dselectinload
4.What HTTP status code is returned when a student is successfully created?
- A201
- B404
- C200
- D409
5.A developer notices that deleting a student returns a 204 status code. What does this signify?
- AThe student was not found in the database.
- BAn error occurred during deletion.
- CThe deletion request is pending.
- DThe student was successfully deleted.
6.A student retrieval operation returns a 404 error. What is the most likely reason?
- AThe student record is locked.
- BThe request method is incorrect.
- CThe database connection failed.
- DThe student ID does not exist in the database.
7.What is the purpose of using selectinload in SQLAlchemy?
- ATo handle unique constraint violations gracefully.
- BTo prevent the N+1 query problem by eager loading related data.
- CTo validate data before committing to the database.
- DTo serialize ORM objects to JSON.
8.What happens when a PATCH request is made without any fields set in the payload?
- AAll fields are set to null in the database.
- BNo fields are updated, and the object remains unchanged.
- CA 400 error is returned due to invalid request.
- DThe object is deleted from the database.