@

Dark Mode

Profile
Edit my Profile
Messages
My favorites

Register

Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams

Dark Mode

GATE CSE 2024 | Set 2 | Question: 16

Arjun asked in Databases Feb 16 edited Feb 21 by makhdoom ghaya

2,156 views

2 votes

2 votes

Which of the following file organizations is/are $\text{I/O}$ efficient for the scan operation in $\text{DBMS}$?

Sorted
Heap
Unclustered tree index
Unclustered hash index

gatecse2024-set2
databases
multiple-selects

Arjun asked in Databases Feb 16 edited Feb 21 by makhdoom ghaya

by Arjun

2.2k views

1 comment

by Deepak Poonia

commented Feb 16

IITG Slides: Cost of various operation of DBMS on different types of files

0

0

Please log in or register to add a comment.

Please log in or register to answer this question.

2 Answers

0 votes

0 votes

The answer is A and B

sanjeet24 answered Mar 5

0 Comments

Please log in or register to add a comment.

Answer:

← Previous Next →

← Previous in category Next in category →

Related questions

1 vote

1 vote

1 answer

1

Arjun asked in Databases Feb 16

1,750 views

GATE CSE 2024 | Set 2 | Question: 17
Which of the following statements about the Two Phase Locking ($2 \mathrm{PL}$) protocol is/are TRUE? $2 \mathrm{PL}$ permits only serializable schedules With $2 \mathrm{PL}$, a transaction always locks the data item being read or ... , no more locks on any data item can be obtained inside that transaction A deadlock is possible with $2 \mathrm{PL}$

Arjun asked in Databases Feb 16

by Arjun

1.8k views

gatecse2024-set2
databases
two-phase-locking-protocol
multiple-selects

2 votes

2 votes

1 answer

2

Arjun asked in Computer Networks Feb 16

3,008 views

GATE CSE 2024 | Set 2 | Question: 13
Node $\text{X}$ has a $\text{TCP}$ connection open to node $\text{Y}$. The packets from $\text{X}$ to $\text{Y}$ go through an intermediate $\text{IP}$ router $\mathrm{R}$. Ethernet switch $\mathrm{S}$ is the first switch on the network ... the $\text{MAC}$ address of $\mathrm{S}$ The destination $\text{MAC}$ address is the $\text{MAC}$ address of $\mathrm{Y}$

Arjun asked in Computer Networks Feb 16

by Arjun

3.0k views

gatecse2024-set2
computer-networks
multiple-selects

0 votes

0 votes

1 answer

3

Arjun asked in Operating System Feb 16

2,378 views

GATE CSE 2024 | Set 2 | Question: 14
Which of the following tasks is/are the responsibility/responsibilities of the memory management unit $\text{(MMU)}$ in a system with paging-based memory management? Allocate a new page table for a newly created process Translate a virtual address ... table Raise a trap when a process tries to write to a page marked with read-only permission in the page table

Arjun asked in Operating System Feb 16

by Arjun

2.4k views

gatecse2024-set2
operating-system
multiple-selects

1 vote

1 vote

1 answer

4

Arjun asked in Operating System Feb 16

2,610 views

GATE CSE 2024 | Set 2 | Question: 15
Consider a process $\text{P}$ running on a $\text{CPU}$. Which one or more of the following events will always trigger a context switch by the $\text{OS}$ that results in process $\mathrm{P}$ moving to a non-running ... page fault An interrupt is raised by the disk to deliver data requested by some other process A timer interrupt is raised by the hardware

Arjun asked in Operating System Feb 16

by Arjun

2.6k views

gatecse2024-set2
operating-system
multiple-selects

Subscribe to GATE CSE 2024 Test Series

Subscribe to GO Classes for GATE CSE 2024

Quick search syntax

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

Recent Posts

Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes

Subjects

All categories
General Aptitude (3.5k)
Engineering Mathematics (10.4k)
Digital Logic (3.6k)
Programming and DS (6.2k)
Algorithms (4.8k)
Theory of Computation (6.9k)
Compiler Design (2.5k)
Operating System (5.2k)
Databases (4.8k)
CO and Architecture (4.0k)
Computer Networks (4.9k)
Artificial Intelligence (79)
Machine Learning (48)
Data Mining and Warehousing (25)
Non GATE (1.4k)
Others (2.7k)
Admissions (684)
Exam Queries (1.6k)
Tier 1 Placement Questions (17)
Job Queries (80)
Projects (11)
Unknown Category (870)

64.3k questions

77.9k answers

244k comments

80.0k users

Recent Blog Comments

category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...

Send feedback
Rank Predictor
College Prediction
Useful Links
FAQ
Corrections
Discuss
Copyright
Request
Testimonials
Chat Logs
Chat
Badges
Search tips
Exam Category
Blog Category
Blog Tags
Privacy
Test Series
GATER
Refund Policy
Terms and Conditions
Contact Us

Developed by Chun

Twitter WhatsApp Facebook Reddit LinkedIn Email

Link Copied!