Database Concepts Interview Questions

What is database system? What is the basic need of database system?
What is a table? Define the dimensions and fact table? Discuss the different attributes of a table in a database system?
Explain data mining? Where can you use this process?
What is data warehousing? Explain the ETL process in data warehousing?
Explain indexing and what kind of different indexing is present in database system?
What is SQL? Explain its features?
Discuss RDBMS? Explain its characters and process?
Discuss Entity- Relationship diagram? Where these diagrams are used?
What is integrity? Explain referential integrity?
Give definition of key? Explain primary key, foreign key and alternate key?
What is constraint? What different constraints are present in a database system?
Discuss stored procedure? Where are these procedures needed?
Explain truncate and delete commands?
Give any two differences between normalization and demoralization? Explain the benefits of each?
What is DDL and DML? What is the difference between two?