What is data modelling concepts?
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What is rank in database?
What are the drawback of rdbms?
Mention the differences between unique key and primary key
What does a database contain?
Explain the functionality of dml compiler.
What is dbms used for?
What is 3 level architecture dbms?
List few restrictions that are imposed while creating views?
How to lock records in a table?
What is buffer manager?
what is scan listener.
What is normal form in dbms?
What is denormalization and why would someone consider doing so?