1 votes 1 votes 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 asked Dec 4, 2017 • edited Mar 7, 2019 by Aditi Singh shivangi5 615 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply Show 2 previous comments shivangi5 commented Dec 4, 2017 reply Follow Share @Anu ans is 2... 0 votes 0 votes Anu007 commented Dec 4, 2017 reply Follow Share 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 votes 0 votes sachin486 commented Oct 3, 2020 reply Follow Share 1 level index can be sparse or dense but second level index must be sparse can you please explain it? 0 votes 0 votes Please log in or register to add a comment.
