Dark Mode

Recent questions tagged file-organization

0 votes

0 answers

1

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 can ... 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

49 views

0 votes

1 answer

2

#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

119 views

1 vote

1 answer

3

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

Lakshman Patel RJIT asked in Operating System Mar 31, 2020

by Lakshman Patel RJIT

520 views

1 vote

3 answers

4

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.

Lakshman Patel RJIT asked in Operating System Mar 31, 2020

by Lakshman Patel RJIT

470 views

0 votes

0 answers

5

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).

Lakshman Patel RJIT asked in Operating System Oct 26, 2019

by Lakshman Patel RJIT

124 views

0 votes

0 answers

6

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

128 views

0 votes

0 answers

7

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

162 views

0 votes

0 answers

8

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

115 views

0 votes

0 answers

9

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

115 views

0 votes

0 answers

10

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

139 views

0 votes

0 answers

11

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

75 views

0 votes

0 answers

12

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

184 views

0 votes

0 answers

13

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

209 views

1 vote

1 answer

14

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

490 views

0 votes

0 answers

15

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

Lakshman Patel RJIT asked in Operating System Jan 5, 2019

by Lakshman Patel RJIT

88 views

0 votes

1 answer

16

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

125 views

8 votes

3 answers

17

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

470 views

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

Recent questions tagged file-organization