Q91.
a
Section
9-5 Security
Answer
Explanation
Packet filtering is a function that checks the IP address or TCP port number/UDP port number
of a packet, and only allows it to pass if the IP address or TCP port number/UDP port number
has been registered and approved beforehand. This makes it possible to prevent entry of packets that have not been approved from the Internet.
Q92.
b
Section
9-5 Security
Answer
Explanation
A “physical measure” refers to managing people, equipment, buildings, rooms, and other
things that physically exist. It oversees who and when someone has entered or left a building
or room containing equipment that records personal information, whether the room with the
equipment is locked, and whether the equipment is fastened in place by chains or other means
to prevent it from being moved outside.
Q93.
a
Section
9-3 Database
Answer
Explanation
From conditions (2) and (3), it is evident that the products and raw materials are each used
multiple times, so the relationship is many-to-many and both product ID and ingredient ID
are necessary as primary keys.
Q94.
d
Section
9-3 Database
Answer
Explanation
In order to restrict access, it is necessary to lock the database. In the case of shared locks, data
cannot be updated but it can be referenced. An exclusive lock is applied in order to restrict
both updating and referencing of data.
Q95.
b
Section
9-3 Database
Answer
Explanation
The amount of raw materials used per product can be calculated by grouping the raw materials by product ID, and adding the amounts of raw materials used.
Q96.
a
Section
1-1 Corporate activities
Answer
Explanation
A bar graph is the most suitable method for comparing amounts.
b): A pie chart is suitable when representing percentages of data.
c): A radar chart is suitable when comparing the characteristics of a number of elements.
d): A line graph is suitable when representing transitions in data.
74