GATE CSE concept:file-organization PYQs & Answers

Home
GATE
Computer Science and Information Technology
Topics
concept:file-organization

Attempt a question, record the concept and assumptions, then check the available answer. Rework mistakes after revising the relevant concepts. Topic tags can overlap; review the question context.

Questions 1–2 of 2. Imported answers require independent review unless marked reviewed.

Topic practice 2 questionsPage 1 of 1

In the context of DBMS, consider the two sets T and S given below.

T | S I: Logical schema | L: Views II: Physical schema | M: File organization and indexes III: External schema | N: Relations

Which one of the following is the correct match from T to S?

Your answerChoose one option.

I – L, II – M, III – N

I – M, II – L, III – N

I – N, II – M, III – L

I – N, II – L, III – M

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

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

Your answerSelect all correct options. You can choose more than one.

Sorted

Heap

Unclustered tree index

Unclustered hash index

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

GATE CSE concept:file-organization PYQs

How to practice concept:file-organization

Question 15

Question 26