GATE CSE 2024 Session 2 Q26: File organizations efficient for a full scan

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

Try it: multiple select: one or more correct options

Select all correct options. No negative marking, no partial marks.

Show answer and explanation

Answer: A, B (official GATE 2024 final answer key)

Concept used: A scan reads every record; it is cheap when records are packed in pages read sequentially.

First step: Through an unclustered index, each record may need its own page fetch, unlike reading the file's pages directly.

Full step-by-step solution

Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.

Share this question

Source: official GATE 2024 Session 2 CS question paper and final answer key, organised by IISc Bangalore. Question paper · Answer key