0 votes 0 votes TRUE/FALSE: statement 1: secondary index may or may not be dense. statement 2: disk is considered as the maximum size of virtual memory. Databases file-indexing virtual-memory + – aambazinga asked Jan 8, 2019 aambazinga 636 views answer comment Share Follow See all 7 Comments See all 7 7 Comments reply pawan kumarln commented Jan 8, 2019 reply Follow Share false true 0 votes 0 votes Lakshman Bhaiya commented Jan 8, 2019 reply Follow Share Can you explain $1^{st}?$ 0 votes 0 votes pawan kumarln commented Jan 8, 2019 reply Follow Share secondary index always be dense 0 votes 0 votes aambazinga commented Jan 8, 2019 reply Follow Share yeah secondary index always dense. that's true. this is because, secondary index is defined over unordered attributs, and we can't sparse index on unordered attribute. this is what i know. but according to me, second statement is partially true, not whole. because, size of virtual memory is limited both by the "addressing scheme of the processor" as well as "the amount of the secondary memory". so just taking one condition under consideration is not true. isn't it? 1 votes 1 votes Shamim Ahmed commented Jan 8, 2019 reply Follow Share @aambazinga addressing scheme of the processor What do you mean by this? 0 votes 0 votes aambazinga commented Jan 8, 2019 reply Follow Share @Shamim Ahmed it means number of bits in the address generated by the processor. because, suppose processor generates L bits address. so no matter how big is the disk, we can't have virtual memory more than 2^L bits. i think size of the virtual address should be min{size of address issued by the processor, size of the virtual memory}. 0 votes 0 votes Shamim Ahmed commented Jan 8, 2019 reply Follow Share Yes. You are right 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes False,Secondary index is always dense True,Seconadry memory limits the size of virtual memory Psy Duck answered Dec 4, 2022 Psy Duck comment Share Follow See all 0 reply Please log in or register to add a comment.