Medium question 2
Read the following account concerning database construction and answer questions Q93 through Q96.
The company that Mr. A has joined operates a sports club with a membership system. Mr. A is in charge of reception procedures, and under the direction of his boss, will examine computerization of the reservation system for the facilities. Issues to be considered are as follows:
[ Reservation system for facilities – Issues to be considered ]( 1) Regarding the reservation method, the reservation is received by telephone or at the reception desk, or is carried out by the user at a dedicated terminal.( 2) The user wears a wristband inside the sports club, and user authentication is carried out at a dedicated terminal via a contactless method using the wristband.( 3) Reorganization processing is implemented at a rate of once a week.( 4) Items recorded in the system are as follows:
Facility code Facility name Member code Member name Start time Finish time
Q93.
Technology
Mr. A decides to give the system concurrency functions because there are a number of methods for making reservations. In this case, which of the following is appropriate as a function that is required to allow the same reservation data to be referenced, but to prevent reservation updates from being duplicated?
a) Setting user authority for system use, and adding security functions so that there is no leaking of reservation data. b) Adding a data recovery function so that, in the case of a failure occurring in the system, the data is returned to the status before the failure occurred. c) Setting an exclusive lock, and adding an exclusive control function to prevent system referencing and updating. d) Setting a shared lock, and adding an exclusive control function to prevent system updating.
Practice exam 2
Q94.
Strategy
Mr. A decides to incorporate a user authentication function into the wristband worn by the user inside the sports club. Which of the following is the appropriate item to incorporate into the wristband?
a) IC tag b) IC card c) Magnetic card d) Plastic card
366