1 1 vote Which of the following statement is/are true? For any data file it is possible to construct two separate sparse first level indexes on different keys. For any data file, it is possible to construct two separate dense first level indexes on different keys. For any data file, it is possible to construct a sparse first level index and a dense second level index,both should be useful. All the above Databases made-easy-test-series databases indexing + – shivangi5 1.2k views answer comment Share Follow Print See all 5 Comments 5 5 Comments reply Show 2 previous comments shivangi5 commented Dec 4, 2017 reply Follow flag @Anu ans is 2... 0 0 replyShare Anu007 commented Dec 4, 2017 reply Follow flag Sry for previous answer: i didn't see option fully / 1 level index can be sparse or dense but second level index must be sparse . hence 3rd is wrong . For any data file, it is possible to construct two separate dense first level indexes on different keys. example (A,B,C) A is key now make index on B and C will give you two dense index but both at 1st level. for 1st option explaination given by nitish 0 0 replyShare sachin486 commented Oct 3, 2020 reply Follow flag 1 level index can be sparse or dense but second level index must be sparse can you please explain it? 0 0 replyShare Please log in or register to add a comment.
