1
GATE CSE 2000
MCQ (Single Correct Answer)
+1
-0.3
B+-trees are preferred to binary trees in databases because
A
Disk capacities are greater than memory capacities
B
Disk access is much slower than memory access
C
Disk data transfer rates are much less than memory data transfer rates
D
Disks are more reliable than memory
2
GATE CSE 1999
MCQ (Single Correct Answer)
+1
-0.3
Which of the following is correct?
A
B-trees are for storing data on disk and B+ trees are for main memory.
B
Range queries are faster on B+ trees.
C
B-trees are for primary indexes and B+ trees are for secondary indexes.
D
The height of a B+ tree is independent of the number of records.
3
GATE CSE 1998
MCQ (Single Correct Answer)
+1
-0.3

There are five records in a database.

Name Age Occupation Category
Rama 27 CON A
Abdul 22 ENG A
Jennifer
28 DOC B
Maya 32 SER D
Dev 24 MUS C

There is an index file associated with this and it contains the values 1, 3, 2, 5 and 4. Which one of the fields is the index built from?

A
Age
B
Name
C
Occupation
D
Category
GATE CSE Subjects
Software Engineering
Web Technologies
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12