Database Administrator (DBA) Question:
Download Questions PDF

Give the two types of tables involved in producing a star schema and the type of data they hold.

Answer:

Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
Give the reasoning behind using an index.What type of index should you use on a fact table?