X hits on this document

Word document

For the exam you should be able to - page 11 / 11

40 views

0 shares

0 downloads

0 comments

11 / 11

13. Three file storage mechanisms are heap files, sorted files and hashed files.

   Give advantages and disadvantages of each.  Make your answers specific with

   respect to normal DB operations such a searching for a particular record,

   or scanning all of the records, etc.

14. We discussed three representations for data entries in an index file.

   Define these three possible representations and discuss advantages and

   disadvantages of each representation and when they would be appropriate.

15. Define the following properties of indexes:

    clustered versus clustered

    dense versus sparse

    primary versus secondary

Document info
Document views40
Page views40
Page last viewedSat Dec 10 15:23:57 UTC 2016
Pages11
Paragraphs265
Words2948

Comments