How does a database store data?
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What is a system concept?
Describe a subquery.
What is db dialect?
Explain what are triggers and rules?
What do you understand by unique key?
Define b-trees.
What is normalization and why it is used?
What is normalization? What are different type of normalization?
Enlist the various relationships of database.
What are dml and ddl statements?
What do you mean by dml compiler?