Time Left - 15:00 mins
Indexing Formula I Starter Quiz-1
Attempt now to get your rank among 40 students!
Question 1
Suppose that we have an ordered file with one million records, stored on a disk. The block size is 2048B, Records are of fixed size and are unspanned. Record length is 256B.,then what is the number of blocks required for data file?
Question 2
The concept of clustering index is based on which of the following:
Question 3
Consider the following statements:
Statement 1: It is possible to generate both clustered as well as primary index for a given file at a same time.
Statement 2: When Sorting of file is done it is possible to sort it on the basis of single key only.
Which of the following is true?
Statement 1: It is possible to generate both clustered as well as primary index for a given file at a same time.
Statement 2: When Sorting of file is done it is possible to sort it on the basis of single key only.
Which of the following is true?
Question 4
Select the reason for that why we have to create a primary index on every primary key?
Question 5
Which of the following is dense index?
Question 6
A block can hold either 6 records or 12 index records. A database contains 48 records, then number of blocks required in the dense index is ______.
Question 7Multiple Correct Options
Which of the following is true regarding unspanned organization ?
- 40 attempts
- 0 upvotes
- 0 comments
Tags :
GATE & PSU CSGeneralJun 22GATE & PSU CS
