Architecture
- Explain partitioning in SQL databases.
- Explain the difference between snapshot isolation and serializable isolation.
- Explain the difference between soft delete and hard delete.
- How can you design a database schema for high scalability?
- How do you handle large-scale data migrations in SQL?
- How do you implement concurrency in SQL?
- How do you manage large datasets in SQL?
- How do you perform a database migration?
- What are the pros and cons of using triggers in SQL databases?
- What is the difference between vertical and horizontal scaling in databases?