Explain why a secondary, unclustered index must be dense.
What will be an ideal response?
A dense index is an index whose entries are in 1-1 correspondence with the corresponding records in the data ?le. A secondary, unclustered index must be dense since data records are ordered di?erently from index entries and hence there is no way to ?nd a record if no index entry refers to it.
You might also like to view...
Describe the main characteristics of the Relational Data Model, including the properties of relations and the rules for relational integrity.
What will be an ideal response?
Given the following rpcinfo -p command sample output, describe the purpose of each column. programversprotoportservice1000004tcp111portmapper1000051udp41254mountd1000211udp4650nlockmgr1000032tcp2049nfs1002273tcp204nfs_acl1000241tcp47205status
What will be an ideal response?
The Repeat Count and ________ are action arguments that are used when the macro should be run more than one time
A) Echo B) RunMacro C) Repeat Expression D) DisplayHourglassPointer
Access is a ________ product.
A. Microsoft B. Google C. Yahoo D. Corel