What is database seeding
· SQL & Databases
Populate databases with initial or test data using seed scripts and fixtures for development and testing.
Category: SQL & Databases
50 questions in SQL & Databases.
How to implement soft deletes
· SQL & Databases
Preserve deleted rows for audit and recovery by implementing soft deletes with a flag or timestamp column.
What is denormalization and when to use it
· SQL & Databases
Learn when to intentionally introduce redundancy to improve read performance in relational databases.
How to choose data types for columns
· SQL & Databases
Select efficient and appropriate data types for columns based on domain, size, precision, and performance.
What are database relationships
· SQL & Databases
Understand the three fundamental database relationships and how they shape schema design.
How to model many to many relationships
· SQL & Databases
Implement many-to-many relationships in relational databases using junction tables and composite keys.
What is the difference between primary key and foreign key
· SQL & Databases
Compare primary keys and foreign keys and understand their roles in uniquely identifying rows and linking tables.
What are database constraints
· SQL & Databases
Enforce rules at the database level using constraints to maintain valid and consistent data.
How to design ER diagrams
· SQL & Databases
Model entities, attributes, and relationships visually using Entity-Relationship diagrams before building schemas.
What is database normalization
· SQL & Databases
Understand normalization forms and how they reduce redundancy and improve data integrity in relational databases.