• different types of SQL commands
• Explain DML
• Explain DDL
• Explain DCL
• Explain TCL
• How do you decide between SQL and NoSQL databases in system design?
• Explain database indexing
• Explain how database indexing works
• Explain the trade off in database indexing
• Explain the CAP theorem and its implications
• When do you prefer ACID and BASE properties in databases?
• Explain about ACID Properties
• Explain BASE Properties
• Types of NoSQL databases
• 3-Schema Architecture
• scalar functions
• Types of Scalar Functions in PostgreSQL
• composite key
• What are constraints?
• Explain different constraints