Database Administrator (DBA) Question:
Download Job Interview Questions and Answers 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 Question | Next Question |
| Give the reasoning behind using an index. | What type of index should you use on a fact table? |