GATE CSE 2024 Set 2 | File Structures and Indexing Question 1 | Database Management System

GATE CSE 2024 Set 2

MCQ (More than One Correct Answer)

-0.33

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

Sorted

Heap

Unclustered tree index

Unclustered hash index

GATE CSE 2024 Set 1

MCQ (Single Correct Answer)

-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?

Only the root node

All leaf nodes

All internal nodes

Only the leftmost leaf node

GATE CSE 2019

MCQ (Single Correct Answer)

-0.33

Which one of the following statements is NOT correct about the B⁺ tree data structure used for creating an index of a relational database table?

B⁺ tree is a height-balanced tree

Non-leaf nodes have pointers to data records

Each leaf node has a pointer to the next leaf node

Key values in each node are kept in sorted order

GATE CSE 2016 Set 2

MCQ (Single Correct Answer)

-0.3

B⁺ Trees are considered BALANCED because

the lengths of the paths from the root to all leaf nodes are all equal.

the lengths of the paths from the root to all leaf nodes differ from each other by at most 1.

the number of children of any two non-leaf sibling nodes differ by at most 1.

the number of records in any two leaf nodes differ by at most 1.

GATE CSE Subjects

Theory of Computation

Undecidability Finite Automata and Regular Language Push Down Automata and Context Free Language Recursively Enumerable Language and Turing Machine

Operating Systems

Process Concepts and Cpu Scheduling Synchronization and Concurrency Deadlocks Memory Management File System IO and Protection

Algorithms

Complexity Analysis and Asymptotic Notations Searching and Sorting Divide and Conquer Method Greedy Method Dynamic Programming P and NP Concepts

Digital Logic

Number Systems Boolean Algebra K Maps Combinational Circuits Sequential Circuits

Database Management System

Er Diagrams Functional Dependencies and Normalization Structured Query Language Relational Algebra Transactions and Concurrency File Structures and Indexing

Data Structures

Arrays Stacks and Queues Linked List Trees Graphs Hashing

Computer Networks

Concepts of Layering Lan Technologies and Wi-Fi Data Link Layer and Switching Network Layer Routing Algorithm TCP UDP Sockets and Congestion Control Application Layer Protocol Network Security

Software Engineering

Compiler Design

Lexical Analysis Parsing Syntax Directed Translation Code Generation and Optimization

Web Technologies

General Aptitude

Numerical Ability Logical Reasoning Verbal Ability

Discrete Mathematics

Graph Theory Set Theory & Algebra Combinatorics Mathematical Logic Probability Linear Algebra Calculus

Programming Languages

Basic of Programming Language Function and Recursion Pointer and Structure in C

Computer Organization

Computer Arithmetic Memory Interfacing Machine Instructions and Addressing Modes IO Interface Pipelining Alu Data Path and Control Unit Secondary Memory