Blog

If the 800,000 record CORKBOARD file is sorted on CBID and we build a sparse index on it, then how many blocks will be needed for the index assuming that the index blocks are packed to capacity and a block pointer is 4 bytes?

Please refer to this diagram for the first 13 Questions. Click here to open it in a new tab.  (Remember you can use Ctrl-Tab to switch between tabs, even if Chrome is full-screen and they aren’t shown.)  Due to proctoring settings, you will not be able to set the exam tab and diagram tab side-by-side. You will need to switch tabs. The diagram says Q1-13, but as loaded, they will be Q2-14.

Which one of the following functional dependencies can be derived from F using only the combination of the reflexive and transitive inference rules?

What is the meaning of the functional dependency

True or false: it is allowable, according to the functional dependencies F, to have multiple tuples in the CORKBOARD relation with the same PushPinLink value.

Which of the following is/are true for the Boyce-Codd normal form (BCNF) relational decomposition?

Which attribute(s) is(are) fully functionally dependent on the set of attributes, ?

Which of the following is a key for CORKBOARD with respect to F?

A large industry leading firm has dramatically improved their cash conversion cycle. They are the dominant revenue source for their respective suppliers by a large margin. Their days of inventory on hand has remained stable throughout the period. Which scenario below is most likely?

A company has a P/E of 30, and the current price is $52.50. The company is committed to a dividend payout ratio of 45%. What is the expected dividend (rounded to 2 decimal places)?