Data Processing Practice Test – File Organisation (Questions with Answers and Explanations)

Which of the following statements best describes sequential file organisation? (WASSCE CS 2020)

A. Records are arranged in no particular order
B. Records are directly addressed to the key value
C. Records are sorted according to a key field
D. Records are used as index to access the database

The following are different ways files can be organised except _____ (NECO CS 2016)

A. finite.
B indexed.
C. random.
D. sequential

Which of the following is the ascending order of data hierarchy? (NECO DP 2016) 

A. Bit → byte →  field → Record → file → database
B. Bit → byte → file → field → record → database
C. Bit → byte → record → field → database → file
D. Bit → file → record → byte → field → database

Which of these is not among the file organization? (NECO CS 2014)

A. lndexed
B. Parallel
C. Random
D. Sequential

Sorting of records is sufficient and a necessary condition for creating _______ (WASSCE CS 2016)

A. random file
B. indirect file
C. sequential file
D. indexed sequential file

Which of the following is a temporary file that can be used only once and then discarded? (WASSCE CS 2016)

A. Refresh file
B. Master file
C. System file
D. Transaction file

Arranging records in a file according to a particular order is referred to as _____ (WASSCE DP 2018)

A. matching.
B. merging.
C. sorting.
D. updating

One advantage of indexed sequential file organization is that _______ (WASSCE DP 2018)

A. index tables are small and can be searched quickly.
B. it is cost effective.
C. it is suitable for dynamically changing files
D. it requires less storage space.

Frequent backup of computer files helps to _______ (WASSCE DP 2022)

A. archive files
B. modify records in file
C. prevent virus attacks
D. protect files

The file organization with the fastest method of accessing stored information is _______ (WASSCE DP 2014)

A. sequential file organisation.
B. index sequential flic organisation
C. direct-access file organization
D. serial file organization

A file organization method that has reference which identifies a record in relation to other records is called _______ (WASSCE DP 2022)

A. indexed file organization
B. random file organization
C. serial file organization
D. sequential file organization

The transaction file can also be described as _______ (WASSCE CS 2014)

A. master file
B. movement file
C. reference file
D. historical file

Which of the following statements is not true about a computer file? (WASSCE CS 2014)

A. It is very fast to access any record within a file
B. It is created electronically
C. Initial setup is inexpensive
D. File creation and access are less laborious

Which of the following is a limitation of computerized files? (NECO CS 2016)

A. Fast to access
B. Irregular power supply
C. More secured
D. Neatly modified

Which of the following computer file can be used for updating the master file? (WASSCE CS 2018)

A. Data file
B. Program file
C. Reference file
D. Transaction file

Opening an already existing sequential file in output(0) mode will lead to _____ (WASSCE CS 2017)

A. buffer overflow
B. deletion of the current content of the file
C. duplication of the current content of the file
D. addition of new data to the content of the file

An advantage of sequential file access over serial access is that ______ (WASSCE CS 2014)

A. sequential file is slow
B. sequential file is detailed
C. sequential file does not use key
D. individual records can be located more quickly

A file kept in ease of an accident or natural disaster is called _____ (WASSCE DP 2015) 

A. master.
B. transition.
C. back-up.
D. reference.

Which of the following options is not a similarity between computer file and manual file? Both can _____ (WASSCE CS 2021)

A. be accessed
B. be retrieved
C. store multimedia
D. contain information

Which of the following options best describes the arrangement of file structure?

I. File     II. Field     III. Character        IV. Record (WASSCE CS 2020)

A. III, II, I and IV
B. II, III, I and IV
C. III, II, IV and I
D. III, IV, II and I

Which of the following is not a method of accessing file? (WASSCE CS 2017)

A. Circular
B. Random
C. Serial
D. Sequential

The file that contains historical record is called a ______ (WASSCE CS 2018)

A. data file
B. master file
C. reference file
D. transaction file

Which of the following file organisation methods can be accessed both randomly and sequentially? (WASSCE CS 2019)

A. Direct files
B. Indexed sequential file
C. Serial files
D. Sequential files

Which of the following operations prevents file loss? (WASSCE DP 2016) 

A. File backup
B. File conversion
C. File maintenance
D. File sorting

Any document saved into a disc is referred to as a/an _____ (NECO CS 2014)

A. field
B. file
C. folder
D. record

Which of the following is not an advantage of file organization? (WASSCE DP 2017)

A. Faster processing of data input
B. Post data retrieval
C. Prevention of data failure and data loss
D. Safety of data and information in a storage medium

Advantages of a computerized files include the following, except ________ (NECO CS 2015)

A. fast to access.
B. laborious.
C. more secured.
D. neatly modified

Which of the following factors limits access to computerized file system? It _____ (WASSCE CS 2017)

A. occupies less space
B. require regular supply of power
C. is highly efficient in processing information
D. provide easy and fast access to information

One of the advantages of an indexed method of file organisation is that ______ (NECO CS 2015) 

A. any records can be accessed in milliseconds.
B. files are easy to arrange.
C. files do not have to be sorted into key field sequence.
D. it is cost effective.

Random file organization is also known as _____ (WASSCE CS 2018)

A. direct file organization
B. indexed file organization
C. serial file organization
D. sequential file organization

Which of the following is not a benefit of file organization? (WASSCE DP 2014)

A. Protection from data failures and loss
B. Efficient use of storage space
C. Fast data retrieval
D. Easy update of information

What file organization would require that all the five (5) records be read before the 6^th record is written? (WASSCE DP 2017)

A. Serial file
B. Index sequential file
C. Random access file
D. Sequential access file

The type of file organisation in a DVD-ROM is _______ (WASSCE DP 2015)

A. Direct access
B. Sequential
C. Serial
D. Hierarchical

Which of the following is not a criterion for classifying files? (WASSCE CS 2020)

A. Nature of content
B. Organisation method
C. Storage medium
D. Type of data

When choosing a file organization method, a system administrator will not consider _____ (WASSCE DP 2022)

A. file access method
B. file activity
C. file medium
D. frequency of update

Effects of file insecurity includes the following EXCEPT______ (WASSCE CS 2019)

A. virus infection
B. file corruption
C. encrypted data
D. data loss

The logical unit of transfer between the backing storage and main memory in file organization is called ______ (NECO CS 2014)

A. block
B. bucket
C. hash
D. hit