Give the reasoning behind using an index.

[nandagopal]

Faster access to data blocks in a table.

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

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

. What type of index should you use on a fact table?

A Bitmap index.

Give two examples of referential integrity constraints.

A primary key and a foreign key.

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.