SQL
DB Interview Questions
Databases What is a “database”? What is a “database management system”? What is a “relational data model”? Define the terms “simple”, “composite”, “candidate”, and “alternate” key. What is a “primary key”? What are the criteria for its selection? What is a “foreign key”? What is “normalization”? What normal forms exist? What is “denormalization”? What is it applied for? What types of relationships exist in a database? Provide examples. What are “indexes”?