Ansys·Software Engineer·Technical Phone Screen
- What is the difference between a primary key and a foreign key, and what constraints does each one impose?
- Write SELECT, JOIN, and GROUP BY queries against a provided schema.
- Explain the difference between mutable and immutable types in Python, and describe how lists differ from tuples.
- How does variable scoping work in Python, and how does Python handle references vs. copies?
- Read these short Python code snippets and predict what each one outputs.
“Straightforward definition question.”