1
GATE CSE 2024 Set 2
MCQ (More than One Correct Answer)
+1
-0

Which of the following file organizations is/are I/O efficient for the scan operation in DBMS?

A

Sorted

B

Heap

C

Unclustered tree index

D

Unclustered hash index

2
GATE CSE 2024 Set 1
MCQ (Single Correct Answer)
+1
-0.33

In a B+ tree, the requirement of at least half-full (50%) node occupancy is relaxed for which one of the following cases?

A

Only the root node

B

All leaf nodes

C

All internal nodes

D

Only the leftmost leaf node

3
GATE CSE 2021 Set 2
Numerical
+1
-0
A data file consisting of 1,50,000 student-records is stored on a hard disk with block size of 4096 bytes. The data file is sorted on the primary key RollNo. The size of a record pointer for this disk is 7 bytes. Each student-record has a candidate key attribute called ANum of size 12 bytes. Suppose an index file with records consisting of two fields, ANum value and the record pointer to the corresponding student record, is built and stored on the same disk. Assume that the records of data file and index file are not split across disk blocks. The number of blocks in the index file is _______
Your input ____
4
GATE CSE 2021 Set 1
MCQ (More than One Correct Answer)
+1
-0

Consider a linear list based implementation in a file system. Each directory is a list of nodes, where each node contains the file name along with the file metadata, such as the list of pointers to the data blocks. Consider a given directory foo.

Which of the following operations will necessarily require a full scan of foo for successful completion?

A
Renaming of an existing file in foo
B
Opening of an existing file in foo
C
Deletion of an existing file from foo
D
Creation of a new file in foo
GATE CSE Subjects
Software Engineering
Web Technologies
EXAM MAP
Medical
NEETAIIMS
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
Civil Services
UPSC Civil Service
Defence
NDA
Staff Selection Commission
SSC CGL Tier I
CBSE
Class 12