Help with Database Questions

Posted by Jahrule under Interview Questions on 8/17/2013 | Points: 10 | Views : 1550 | Status : [Member] | Replies : 0
1. You are given a table (A, B, C) where A is a low-cardinality attribute, B is a high-cardinality attribute, C is a numerical variable. You're asked to produce cross-tabulation of sum of C by both A and B and show resultant table in Excel spreadsheet. Would you choose to show A as columnar dimension? Why?

2.What key mathematical property of a field is used in deciding if it should belong to an index?

3.What is the general class of dependencies which uniquely identify every record in a table?


(No response found.)

Login to post response