EXAMSHARE

Western Delta University, Oghara Delta State

department of computer science
college of computing
western delta university

second semester examination 2022/2023 session

CSC204 - file processing time: 2hrs

attempt question ONE (compulsory) and any other TWO questions

  1. Question 1 (Compulsory)

    1. What is file organization? (2 marks)
    2. List threee (3) objectives of file organization (3 marks)
    3. Write explanatory notes on the following file system operations:
      1. Retrieve_all
      2. Retrieve_one
      3. Retrieve_next
      4. Retrieve_previous
      5. Insert_one
      6. Delete_one
      (12 marks)
    4. Consider the organized file presented here under and use it to answer the questions that follow.
      S/NNAMESEXBLOCKROOM NUMBER
      1AISOSA EdebiriMaleA3
      2BOTU MichaelMaleB1
      3KAYODE WilliamsMaleC2
      4OBI ChideraFemaleD5
      5OTOIDE EvelynFemaleE1
      6TEMINE RolandMaleB4
      7UROKO PhoebeFemaleD3
      1. How many records are in the file (1 mark)
      2. Retrieve_one (Record 4) (2 marks)
      3. Retrieve_next (2 marks)
      4. Retrieve_all (3 marks)
      5. Insert_one using the criteria below:
        S/N = 8, NAME = ZAKPOLOR Divine, SEX = Male, BLOCK = C, ROOM NUMBER = 2 (3 marks)
      6. Delete_one (Record 1) (2 marks)

  2. Question 2

    1. Explain the following file and data management terms:
      1. fields
      2. records
      3. file
      (6 marks)
    2. Copy and complete the table below
      S/NFile TypeContent
      1.html
      2.pdf
      3.txt
      4.gif
      5.jpg
      6.mp3
      (6 marks)
    3. Discuss the following file attributes
      1. file type
      2. location
      3. size
      4. protection
      (8 marks)

  3. Question 3

    1. What is Data Processing? State its importance (3 marks)
    2. Using a diagram, show the data processing life cycle (3 marks)
    3. Discuss in detail the life cycle shown above. (6 marks)
    4. Describe the following types of data processing:
      1. Batch processing
      2. Real Time processing
      3. Online processing
      4. Multiprocessing
      (8 marks)

  4. Question 4

    1. Why are files organized? (2 marks)
    2. List four (4) criteria that should be considered when organizing files (2 marks)
    3. Give a detailed discussion of the following file organization methods:
      1. Pile/Serial file
      2. Sequential file
      3. Indexed Sequential file
      4. Direct or hashed file
      (8 marks)
    4. With the aid of a diagram only, show the steps that job processing goes through. (4 marks)
    5. Write short notes on the following:
      1. job
      2. job execution
      (4 marks)

  5. Question 5

    1. Write explanatory notes on the following:
      1. Data Backup
      2. Restore
      (4 marks)
    2. List and explain two (2) types of data backup (4 marks)
    3. Describe the following file deletion terminologies:
      1. Computer formatting
      2. Risky operations
      3. Accidental deletion
      4. Disk partitioning
      (8 marks)
    4. List the steps involved in recovering delete files from a folder using file history (4 marks)