Dark Mode

Recent questions tagged file-organization

0 votes

1 answer

1

Ace Test Series
Consider six files: F1, F2, F3, F4, F5, F6 with corresponding sizes 100, 200, 70, 40, 250 and 50 respectively. the files are to be stored on a sequential device in such a way that as to optimize access time. In what order should the files be stored ?? A) ... approximate average access time of a record from one of the six files on the sequential device?? A) 131 B) 198 C) 286 D) 433

none30 asked in Operating System Apr 12, 2023

by none30

356 views

0 votes

0 answers

2

Best Open Video Playlist for File Organization Topic | Databases
Please list out the best free available video playlist for File Organization from Databases as an answer here (only one playlist per answer). We'll then select the best playlist and add to GO classroom video lists. You ... standard ones are more likely to be selected as best. For the full list of selected videos please see here

makhdoom ghaya asked in Study Resources Aug 20, 2022

by makhdoom ghaya

142 views

0 votes

1 answer

3

#self doubt
Hash indexing and Hash file organization are there in gate syllabus??? I also wanted to know what are the topics are there in file organization and indexes….as I don’t find much question from file organization in gate questions...then please provide the video link???

samarpita asked in Databases Nov 14, 2021

264 views

1 vote

1 answer

4

NIELIT 2017 DEC Scientific Assistant A - Section B: 47
The open file table has a/an __________ associated with each file. file content file permission open count close count

admin asked in Operating System Mar 31, 2020

by admin

973 views

1 vote

3 answers

5

NIELIT 2016 MAR Scientist B - Section C: 35
The file structure that redefines its first record at a base of zero uses the term relative organization. key fielding. dynamic reallocation. all of these.

admin asked in Operating System Mar 31, 2020

by admin

925 views

0 votes

0 answers

6

Andrew S. Tanenbaum (OS) Edition 4 Exercise 4 Question 12 (Page No. 333)
Describe the effects of a corrupted data block for a given file for: contiguous, linked, and indexed (or table based).

admin asked in Operating System Oct 26, 2019

by admin

192 views

0 votes

0 answers

7

DBMS Korth Edition 4 Exercise 11 Question 18 (Page No. 442)
Consider a relational database with two relations: $course (course-name, room, instructor)$ $enrollment (course-name, student-name, grade)$ Define instances of these relations for three courses, each of which enrolls five students. Give a file structure of these relations that uses clustering.

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

307 views

0 votes

0 answers

8

DBMS Korth Edition 4 Exercise 11 Question 17 (Page No. 442)
List two advantages and two disadvantages of each of the following strategies for storing a relational database: $a$. Store each relation in one file. $b$. Store multiple relations (perhaps even the entire database) in one file.

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

274 views

0 votes

0 answers

9

DBMS Korth Edition 4 Exercise 11 Question 16 (Page No. 442)
In the sequential file organization, why is an overflow block used even if there is, at the moment, only one overflow record ?

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

174 views

0 votes

0 answers

10

DBMS Korth Edition 4 Exercise 11 Question 14 (Page No. 442)
Explain why the allocation of records to blocks affects database-system performance significantly.

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

179 views

0 votes

0 answers

11

DBMS Korth Edition 4 Exercise 11 Question 10 (Page No. 441)
Give an example of a database application in which the pointer method of representing variable-length records is preferable to the reserved-space method.Explain your answer.

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

194 views

0 votes

0 answers

12

DBMS Korth Edition 4 Exercise 11 Question 9 (Page No. 441)
Give an example of a database application in which the reserved-space method of representing variable-length records is preferable to the pointer method. Explain your answer.

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

128 views

0 votes

0 answers

13

DBMS Korth Edition 4 Exercise 11 Question 2 (Page No. 440)
How does the remapping of bad sectors by disk controllers affect data-retrieval rates ?

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

257 views

0 votes

0 answers

14

DBMS Korth Edition 4 Exercise 11 Question 1 (Page No. 440)
List the physical storage media available on the computers you use routinely.Give the speed with which data can be accessed on each medium.

akash.dinkar12 asked in Databases Apr 1, 2019

by akash.dinkar12

266 views

1 vote

1 answer

15

Applied Course | Mock GATE | Test 1 | Question: 51
Which of the following statements is/are True? File allocation Table (FAT) suffers from external fragmentation. An inode structure can contain pointers to directory data. Only I Only II Both I and II Neither I nor II

Applied Course asked in Operating System Jan 16, 2019

by Applied Course

780 views

0 votes

0 answers

16

UPPCL AE 2018:37
A file is organized so that the ordering of data records is the same as, or close to the ordering of data entries in some index. Such an index is commonly known as: Dense None of the above Clustered Sparse

admin asked in Operating System Jan 5, 2019

by admin

171 views

0 votes

1 answer

17

Uttrakhand Asst. Professor Exam-50
In a sequential file records are maintained in the logical sequence of their primary key value storage location primary and secondary key value None of the above

gatecse asked in Unknown Category Mar 2, 2018

177 views

8 votes

3 answers

18

Test by Bikram | Databases | Test 2 | Question: 26
Assume that a data file contains $2000$ records that are ordered by a key attribute $K$ , and a primary index on attribute $K$ is built. The size of key is $5B$ and block pointer is $5B$. Each block of the system is of ... storing meta data). The total number of disk accesses required to fetch the record using the index (in average case) is _____.

Bikram asked in Databases Aug 26, 2017

by Bikram

953 views

To see more, click for the full list of questions or popular tags.

Recent questions tagged file-organization