b_book1.gif (162 bytes)Data organisation

Data organisation - Questions

True/False

  1. A database is a collection of logically related files and records.
  2. In direct file organisation, the computer starts at the beginning of the file and checks every records key field until it finds the records being sought.
  3. When direct file organisation is used data may be stored on disk or tape.
  4. A database is a collection of logically related files and records.
  5. In sequential file organisation, the computer starts at the beginning of the file and checks every records key field until it finds the records being sought.
  6. When direct file organisation is used data may only be stored on tape.

Multi-choice

1. In which database structure may a node be reached through more than one path?

a)hierarchical
b)indexed-sequential
c)relational
d)network

2. Which of the following is a unique identifier chosen to identify a record

a)index field
b)record name
c)key field
d)disk address

3. Which of the following types of files would be stored on magnetic tape?

a)direct
b)index sequential
c)sequential
d)none of the above

4. All of the following are advantages of databases over files except

a)data redundancy is reduced
b)fewer files are needed
c)data integrity is reduced
d)information is easily shared between departments

5. A row in a relational database is known as a(n)

a)record
b)relation
c)attribute
d)field

6. Which database structure is described as a tree structure, where each item has only one "parent"?

a)hierarchical
b)indexed-sequential
c)relational
d)network

7. Which of the following allows a record to be accessed in an alternative sequence?

a)index field
b)record name
c)key field
d)disk address

8. Which of the following types of files could be stored on magnetic disk?

a)direct
b)index sequential
c)sequential
d)all of the above

9. All of the following are advantages of databases over files except

a)data redundancy is reduced
b)fewer files are needed
c)data integrity is reduced
d)information is easily shared between departments

Short Answers

1. Describe an application where indexed sequential file organisation would be best suited.

2. Describe an application where sequential file organisation would be best suited.

3. What type of file organisation is described here?

Record # : 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ..

Inv. Part:005 | 010 | 220 | 225 | 448 | 690 | 890 | 898 | ..

4. What type of file organisation is described here?

Record # : 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ..

Inv. Part:100 | 010 | | 230 | | 650 | 860 | | ..

4. Define the term Relational Database, give an example, and draw a diagram.

5. Differentiate between File Management Systems and Database Management systems.

6. Describe an application where sequential file organisation would be best suited.

7. Describe an application where relative file organisation would be best suited.

Sample Answers

True/False

  1. T
  2. F
  3. F
  4. T
  5. T
  6. F

Multichoice

  1. d
  2. c
  3. c
  4. b
  5. a
  6. a
  7. a
  8. d
  9. c

Short Answers

3. Sequential
4. Relative/Random

[Rev: 5/6/98] 22/12/97 © 1997-98 V/2-Com (Verhaart), P O Box 8415, Havelock North, New Zealand.