Indexing and Hashing Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Indexing and Hashing “. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on Indexing and Hashing comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Indexing and Hashing Mcqs

Computer MCQS

Sciences MCQS

2.
Index which has an entry for some of key value is classified as

Linear index

Dense index

Non dense index

Cluster index

Answer Discus (0)

3.
Primary indexes, secondary indexes and cluster indexes are all types of

Ordered indexes

Unordered indexes

Linear indexes

Relative search indexes

Answer Discus (0)

4.
In multilevel indexes, primary index created for its first level is classified as

Zero level of multilevel index

Third level of multilevel index

Second level of multilevel index

First level of multilevel index

Answer Discus (0)

5.
Indexes which specifies address of records on disk with a physical pointer are classified as

Structural index

Hashing index

Physical index

Logical index

Answer Discus (0)

7.
In data file, first record of any of block is called

Anchor record

Dense record

Non dense record

None of above

Answer Discus (0)

8.
File which has secondary index for its every field is classified as

Fully inverted file

Fully indexed file

Secondary indexed file

Primary indexed file

Answer Discus (0)

9.
First field in primary index having same data type as in ordering field is considered as

Indexed key

Ternary key

Secondary key

Primary key

Answer Discus (0)

10.
In multilevel indexes, primary index created for its second level is classified as

Second level of multilevel index

First level of multilevel index

Zero level of multilevel index

Third level of multilevel index

Answer Discus (0)

12.
The physical location of a record is determined by a mathematical formula that transformsa file key into a record location is :

B-Tree File

Hashed File

Indexed File

Sequential file

Answer Discus (0)

13.
An indexing operation

Sorts a file using a single key

Sorts file using two keys

Establishes an index for a file

Both (b) and (c)

Answer Discus (0)

14.
The index consists of

A list of keys

Pointers to the master list

Both (a) and (b)

All of the above

Answer Discus (0)

15.
If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.

Delete

Update

Sort Key

Index

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

0Shares
0
Scroll to Top