File Organisation And Indexing Flashcards

1
Q

What is Primary File Organisation?

A

Defines the methods of storing and organising files on a storage device (like hard drive)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Types of Primary File Organisation.

A
  1. Sequential File Organisation
  2. Heap File Org
  3. Index File Org
  4. Linked File Org
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is Sequential File Organisation?

A

A method of storing files in continuous or sequential data blocks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Heap File Org?

A

Files aren’t stored in a specific order; when a data block is full and another file needs to be stored, it is stored in any free data block – it doesn’t have to be close.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is Index File Organisation?

A

Uses catalogue of file names and their locations to keep track of the files.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is Linked File Organisation?

A

Files stored in this manner are divided into fixed-length blocks which contain pointers to the location of the next related file.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is 4GL?

A

Fourth Generation Environment is an environment (set) of high-level programming languages which provides a non-procedural interface for developing database applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are non-procedural languages?

A

Programming languages that allow users specific what they want done without having to state how it should be done.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly