Q95.
Technology
Mr. A did not understand the reason why Item (3) of the [Reservation system for facilities Issues to be considered] must be implemented, so he asked his boss. Which of the following is the appropriate reply from his boss?
a) When a system is used for a long time, the amount of free space on the hard disk decreases. Item (3) is carried out in order to secure free space and get rid of unnecessary
records.
)
b When the number of records accessed simultaneously increases, the seek operation of
the magnetic disk takes more time and file access efficiency falls. As a countermeasure, files that are accessed simultaneously are arranged so that they are adjacent to
each other in the magnetic disk.
c) When additions, updates, and deletions to the database are made repeatedly, space
that is not reused occurs, and this leads to an increase in the database’s used space
and a fall in processing speed. Item (3) is carried out in order to avoid deterioration in
performance by organizing discontinuous free space.
)
d When records are deleted, the Recycle Bin in which the targeted files are temporarily
stored becomes full, and access efficiency falls if old files in the Recycle Bin are
physically erased each time new records are created and deleted. As a countermeasure, files in the Recycle Bin are erased collectively.
Q96.
Technology
Mr. A decides to partition the data in Item (4) of the [Reservation system for facilities - Issues for to be considered] in order to avoid duplication of data. There is no cutoff in the period of use of a facility, and any time can be entered as long as it is inside of business
hours. Which of the following is the most appropriate partitioning?
a)
Facility code
Facility name
Member code
Member name
Start time
Finish time
Facility code
Facility name
Start time
Finish time
Member code
Member name
b)
c)
Facility code
Facility name
Member code
Member name
Facility code
Start time
Finish time
d)
367
Facility code
Facility name
Member code
Member name
Facility code
Member code
Start time
Finish time