Skip to content
Early access — you're among the first to try PYQLabs. Share feedback
Concept drill

comparisons

GATE CSE & IT · Query Processing · 1991-2025

14
PYQs
71%
keyed
0
elite explanations
10
years appeared

Study anchor

Korth — Database System Concepts

Relational model, SQL, normalization, transactions

Practice action

Start latest PYQ

PYQs in this concept

All concepts →
2025 Q20

Consider an unordered list of N distinct integers. What is the minimum number of element comparisons required to find an integer in the list that is NOT the largest in the list?

mediumanswer key
2021 PYQ

Consider the following array. 23 32 45 69 72 73 89 97 Which algorithm out of the following options uses the least number of comparisons (among the array elements) to sort above arr...

easyanswer keybasic explanation
2021 PYQ

Let P be an array containing n integers. Let t be the lowest upper bound on the number of comparisons of the array elements, required to find the minimum and maximum values in an a...

mediumanswer keybasic explanation
2020 PYQ

Consider the array representation of a binary min-heap containing 1023 elements. The minimum number of comparisons required to find the maximum in the heap is _______.

mediumbasic explanation
2015 PYQ

An unordered list contains $$n$$ distinct elements. The number of comparisons to find an element in this list that is neither maximum nor minimum is

easyanswer key
2014 PYQ

The minimum number of comparisons required to find the minimum and the maximum of 100 numbers is ________

easy
2014 PYQ

Suppose P, Q, R, S, T are sorted sequences having lengths 20, 24, 30, 35, 50 respectively. They are to be merged into a single sequence by merging together two sequences at a time....

medium
2014 PYQ

Let P be a QuickSort Program to sort numbers in ascending order using the first element as pivot. Let t 1 and t 2 be the number of comparisons made by P for the inputs {1, 2, 3, 4,...

mediumanswer key
2007 PYQ

An array of n numbers is given, where n is an even number. The maximum as well as the minimum of these n numbers needs to be determined. Which of the following is TRUE about the nu...

mediumanswer key
2006 PYQ

Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are Did and cid respectively and the records are stored in ascendi...

hardanswer key
1996 PYQ

Quicksort is run on two inputs shown below to sort in ascending order taking first element as pivot i) 1, 2, 3,......., n ii) n, n-1, n-2,......, 2, 1 Let C 1 and C 2 be the number...

easyanswer key
1996 PYQ

The average number of key comparisons done on a successful sequential search in list of length n is

easyanswer key
1995 PYQ

For merging two sorted lists of sizes m and n into a sorted list of size m+n, we require comparisons of

easyanswer key
1991 PYQ

Minimum number of comparisons required to sort 5 elements

mediumbasic explanation