April 2012 Flashcards

Question 1

Q

In the worksheet of spreadsheet software shown below, rows 1 through 4 are sorted in
ascending order by using the last (or low order) two digits of each numeric value in
column A. When the numeric values of column B that are calculated from those of
column A are used as sort keys, which of the following is the appropriate calculation
result to be entered into column B?

A | B
1 123411
2 156711
3 119813
4 123815

a) The quotient obtained when the numeric value in column A is divided by 10

b) The remainder obtained when the numeric value in column A is divided by 10

c) The quotient obtained when the numeric value in column A is divided by 100

d) The remainder obtained when the numeric value in column A is divided by 100

Question 2

Q

) When a path goes from node A1 to node C2 in Fig. 1 and the passing nodes are counted
as shown in Fig. 2, it is found that there are three shortest paths with the minimum
number of passing nodes. How many shortest paths are there available to go from
node A1 to node D4 via node C2?

Question 3

Q

Which of the following is an appropriate purpose of appending a check digit to a
customer code?

a) To check the customer code for input errors

b) To arrange customers in order of acquisition when a list of customers is created

c) To enable customers to be inferred easily and quickly

d) To enable the grouping of customers by geographical area or other attributes

Question 4

Q

Which of the following is an appropriate description concerning the characteristics of
EUC (End User Computing)?

a) EUC enables users to directly access, reference, and manipulate data that they need
for business operations.

b) EUC gives priority to system operation and maintenance, so it causes backlogs to
increase in the information systems department.

c) EUC requires more development staff members in the information systems
department, so it often leads to an increase in the operating costs of the department.

d) EUC allows the information systems department to take a leadership role in
application development, so it can reduce the workload of users.

Question 5

Q

The procedure described below is sequentially performed for two variables x and y,
starting with step (1). When the procedure is completed, what is the resulting value of
x?

[Procedure]
(1) Assign 2 to x and 3 to y.
(2) Subtract 1 from the value of y, and assign the resulting value to y.
(3) Add the values of x and y, and assign the resulting value to x.
(4) If the value of y is 1, complete the procedure. Otherwise, return to step (2).

a) 4

b) 5

c) 7

d) 8

Question 6

Q

Which of the following refers to an XML-based document format that is used for
efficient information collection and distribution on Web sites such as a blog, a news site,
or an electronic bulletin board, and is also used for describing metadata such as page
header, abstract, and update time in a structured form?

a) CSS (Cascading Style Sheets)

b) DTD (Document Type Definition)

c) RSS (RDF(Resource Description Framework) Site Summary)

d) XSL (Extensible Stylesheet Language)

Question 7

Q

Which of the following is an appropriate description concerning a CPU?

a) The cache memory that is integrated into a CPU is used to virtually extend the
capacity of the main memory.

b) A CPU is equipped with the arithmetic and logical unit that should serve as part of
control functions.

c) A CPU is categorized as a 16-bit, 32-bit, or 64-bit CPU depending on the data
volume processed at a time, but the width in bits is not related to the performance.

d) For CPUs that have the same architecture, the higher the clock frequency, the faster
the response time.

Question 8

Q

Which of the following is an appropriate description concerning USB?

a) Some peripheral devices with low power consumption can receive power through a
USB cable without any additional power supply.

b) All peripheral devices connected to the USB port of a PC must be turned on before
the PC is powered on.

c) The data is transmitted in parallel over multiple data lines, in order to achieve high
speed data transfer.

d) The USB interface is suitable for a low speed peripheral device, such as a keyboard
or a mouse, rather than a high speed device like a hard disk.

Question 9

Q

Which of the following is used for image sensors in digital cameras?

a) CCD

b) PDP

c) STN

d) TFT

Question 10

Q

10.) Which of the following is the interface that enables a PC and its peripheral devices to
be connected in the configuration shown in the diagram below? Here,
represents a hub.

Question 11

Q

11.) Among the system configurations shown below, which of the following has the lowest
probability of causing the entire system to stop at the occurrence of a failure? Here,
represents an identical device. When the devices are connected in parallel,
only one device must be running, and when the devices are connected in serial, all
devices must be running.

Question 12

Q

) When a computer is installed under the conditions below, which of the following is an
appropriate graph to represent the relationship between the number of years of use
(horizontal axis) and the monthly costs (vertical axis)?
[Conditions]
(1) Computer costs
* For the initial five years, an amount that is calculated from a lease rate based
on the cost of purchasing the computer is paid in fixed monthly installments.
* From the sixth year on, an amount that is calculated from a lease rate based on
one tenth (1/10) of the cost of purchasing the computer is paid in fixed monthly
installments.
(2) Maintenance costs
* From initial installation, the maintenance fee is paid to a maintenance service
provider in fixed monthly installments.

Question 13

Q

The graph below shows the relationship between the failure rate “λ(t)” of the devices
comprising the system and the time “t ” elapsed since the start of use. Which of the
following is a device that is expected to show the greatest increase in the failure rate
during the wear-out failure period?

Question 14

Q

When a PC is powered on, which of the following is first activated to access a hard
disk or other bootable media before the OS is started?

a) BIOS

b) POST

c) MBR

d) Disk driver

Question 15

Q

When print processing is executed using an application program such as word
processing software or spreadsheet software, there is a method that allows data for
printing to be stored temporarily on the hard disk without direct output to the printer,
and allows actual printer output to be performed by a dedicated program. Which of
the following is the advantage of separating actual printer output from application
execution in this way?

a) The time from the start of application execution until the end of printing can be
reduced.

b) The modification of a document that contains a large number of images becomes
possible.

c) The processing volume per unit time increases.

d) The font can be changed easily at the time of printer output.

Question 16

Q

In the description below concerning a file system, which of the following is an
appropriate combination of terms to be inserted into blanks A through C?
When files and directories on a PC are managed hierarchically, the directory at the
highest level is called the A directory, and the directory that a user is now
manipulating is called the B directory. A notation format that uses the
B directory as its starting point and shows the location of a file or a
directory is called a(n) C path.

Question 17

Q

When the log file of a Web server is analyzed as a part of daily system administration,
which of the following can be found?

a) Web pages accessed by Web site visitors

b) The model name of a computer used by each visitor

c) The speed of a Web browser on each visitor’s computer

d) Personal information about individual Web site visitors

Question 18

Q

Which of the following is the expression to be entered into cell D4 in order to calculate
the tax-inclusive prices of the products shown in cells A4 and A5 by using the two
tentative sales tax rates that are set in cells D2 and E2? Here, the expression to be
entered into cell D4 is copied to cells D5, E4, and E5.

Question 19

Q

Which of the following is an appropriate description concerning the symptom and its
measures to be taken at the occurrence of file fragmentation?

a) Since more files are accessed simultaneously and the seek operation of the hard disk
takes more time, the efficiency of file access drops. The measure to be taken is to
store the simultaneously accessed files close together in the hard disk.

b) Since the recycle bin is full and an old file in the recycle bin is removed physically
each time a file is created or deleted, the efficiency of file access drops. The
measure to be taken is to remove the files in the recycle bin all together.

c) Since small separated areas, instead of a single contiguous area, are allocated when a
file is created, the efficiency of file access drops. The measure to be taken is to
reallocate contiguous areas to files and unused space.

d) The data area for files is large enough, but the control area for files is not sufficient
and it takes time to allocate the control area when a file is created. The measure to
be taken is to combine multiple files into one or to expand the control area.

Question 20

Q

20.) Candidates for operating a new business are selected from all of the employees based
on the conditions below. When a decision table is used to represent the selection
process, which of the following is the appropriate “conditions table” to be inserted into
the decision table?
[Conditions for candidates]
(1) The employee has selected “I am interested in IT” in the questionnaire.
(2) The employee has a score of 85 or higher on the IT aptitude test.
(3) An employee with a test score lower than 85 can become a substitute candidate
if the employee has worked for five or more years in the current workplace.

Question 21

Q

21.) In a company which has its offices dispersed in several buildings, it is decided to
construct a relational database to manage the locations where PCs are installed.
“Asset” table, “Room” table, and “Building” table are created, and these tables are
linked. When new data is entered, data in the table to be referenced should exist
beforehand. Which of the following is the appropriate sequence of entering data into
each table? Note that the underlined items in each table indicate the primary keys or
the foreign keys.

Question 22

Q

22.) Which of the following is an appropriate explanation of the table obtained when the
SELECT statement shown below is executed?
SELECT Products.Product_code, SUM(Unit_priceSales_volume)
FROM Products, Sales
WHERE Products.Product_code = Sales.Product_code
GROUP BY Products.Product_code
ORDER BY SUM(Unit_priceSales_volume)

Question 23

Q

When a database is used, the execution of a function that can update information
during search may cause data inconsistencies in the database. Which of the following
is an appropriate function to prevent this situation?

a) Commitment control

b) Deadlock avoidance

c) Exclusive control

d) Shared access

Question 24

Q

Which of the following is an appropriate description of VoIP?

a) It is a method that enables PC users to access data or applications available on the
Internet.

b) It is a technology that converts voice data into packets and transmits them in
real-time over an IP network.

c) It is a technology that ensures the security of communication by using authentication,
encryption, and decryption between network nodes.

d) It is a system that defines and manages a correspondence between a host name and
an IP address for a network-connected computer.

Question 25

Q

Which of the following prevents unauthorized external access by using packet filtering
at the connection point between a company’s internal network and the Internet?

a) DNS

b) NAT

c) Gateway

d) Firewall

Question 26

Q

Which of the following is an appropriate explanation concerning the function of a
router?

a) It optically reads data such as picture and text and then converts it into digital data.

b) It converts analog signals to digital signals and vice versa.

c) It controls the communication path of data and relays data across networks.

d) It archives and provides data of Web pages by using networks.

Question 27

Q

Which of the following is an appropriate description concerning a cookie used in the
Web?

a) It is a standard that can be used for formatting the layout of an HTML document in
detail.

b) It is the HTTP protocol to which an encryption function is added for private
communications over the Internet.

c) It is a mechanism where a Web server interacts with external programs to create Web
pages dynamically.

d) It is a mechanism where information from a Web server is temporarily saved in a
browser that accesses the Web server.

Question 28

Q

Which of the following is a system configuration that introduces Internet technology
into a company’s information and telecommunication system and is used for
information sharing and business support?

a) EDI

b) VAN

c) Intranet

d) Extranet

Question 29

Q

A PC was checked for computer viruses, and a certain number of infected files were
discovered. Which of the following is an appropriate course of action that should be
taken by the person who found the infected files?

a) Contacting the recipients to whom the files infected by an unknown virus were
forwarded, after identifying the virus so that they can take corrective action

b) Forwarding the infected files to the system administrator by e-mail so that the
administrator can promptly take measures

c) Disconnecting the infected PC immediately from the network in order to prevent
other PCs from being infected

d) Enabling the write protection of removable media that were used for a day-old
backup in order to prevent other files from being infected

Question 30

Q

There exists a model of communication from A to B based on public key cryptography
as shown below. Which of the following is an appropriate description concerning this
model?
The message sent by A is used to generate a message authentication code. This
authentication code is encrypted using A’s private key to generate a bit string that is
sent to B by e-mail along with the original message.
B obtains A’s public key from a trusted organization, and in addition to decrypting
the received bit string, B generates the message authentication code from the
received message to verify that both codes are the same before the message is used.

a) A can confirm that the message is delivered to B.

b) A can guarantee to B that the message is not wiretapped.

c) B is guaranteed to receive the message from A.

d) B can confirm that the message is from A and is not falsified.

Question 31

Q

Which of the following is an appropriate description concerning the information
security policy?

a) The security policy of a company is intended to define what should be set for each
security system, so its contents vary depending on the security-related product to be
installed.

b) The security policy of a company provides guidelines on the action and judgment to
be followed and does not cover the stance and direction on security measures.

c) It is desirable for top management of a company to disclose the vulnerability of the
information system that forces the company to create the security policy.

d) It is necessary to clarify the vision about the action and judgment to be followed to
achieve the target security level.

Question 32

Q

Which of the following is the term that refers to the act of setting up a bogus Web page
imitating a bank, a credit card company, or other organization, and tricking a user with
an e-mail disguised as an official message from the financial organization or a public
organization in order to guide a user to the bogus Web page and steal personal
information such as the personal identification number and credit card number?

a) Cracking

b) Buffer overflow

c) Phishing

d) Bot

Question 33

Q

Which of the following is an appropriate description concerning a macro virus?

a) It is a new virus that is created by combing multiple viruses into one.

b) It moves across computers connected via a network while replicating itself.

c) It is an executable file that is sent as an attachment to an e-mail message.

d) It infects data files used by word processing software or spreadsheet software.

Question 34

Q

Which of the following is a method that may cause a mail server to go down by
sending a large number of unsolicited e-mails to a lot of e-mail users in a short period
of time with the aim of advertising or selling goods or services?

a) Spam mail

b) Chain mail

c) E-mail bomb

d) Multi-posting

Question 35

Q

Which of the following is an appropriate description concerning system maintenance?

a) In order to perform system maintenance in contrast to system design and
development, it is important to follow the manual without relying on knowledge of
the system.

b) When system maintenance is performed, it is important to respond appropriately to
improvement requests from users and to system failures, and also important to
record accurate response logs.

c) In order to efficiently perform system maintenance, it is preferable for the system
department to take the central role and execute the plan, and to avoid participation of
the user department as much as possible.

d) In order to handle system improvement requests from the user department efficiently
with the limited staff members of the system department, it is best to deal with
simple and easy-to-implement requests first.

Question 36

Q

36.) In a DFD of sales management, which of the following is the data store that represents
“product inventory”? Here, each process corresponds to one of “inventory
allocation”, “order receipt”, order backlog”, “shipment”, and “order placement”.

Question 37

Q

When system administrators participate in a system test in cooperation with the
information systems department, which of the following is test data that should be
prepared in advance?

a) Data handled as an exception and also used in actual business operations

b) Data to execute all instructions in the program one or more times

c) Data to detect errors related to interfaces between modules

d) Data to detect logical errors in program modules

Question 38

Q

When word processing software, spreadsheet software or other application software is
installed on multiple PCs, which of the following is an appropriate point to be
considered by the system administrator?

a) In consideration of data compatibility and license cost, the standardized software
should be installed.

b) If the software has an online help function, support from the vendor does not need to
be considered.

c) Users have their own preference on which software to use, so they should be
allowed to select the software to be installed.

d) Users should be allowed to install free software at their own discretion if it is
downloadable from the Internet.

Question 39

Q

Before migration, a newly developed online ordering management system is operated
in parallel with the existing system for two months. During that period, data is
entered into both systems, and output is checked. After parallel operation is started,
processing is initially smooth. However, just before migration to the new system, it is
discovered that response time increases if a large amount of data is entered into the
new system at a time. Which of the following is the test that is considered to be
insufficient as a cause of delay in discovering this problem?

a) Function test

b) Fault recovery test

c) Regression test

d) Load test

Question 40

Q

Which of the following is an appropriate description concerning the characteristic of
prototyping that is a software development method?

a) The phases of basic planning, external design, internal design, program design,
programming, and testing are conducted sequentially, so the entire project can be
overviewed and it is easy to make the schedule and allocate resources.

b) A trial model is created at an early stage of system development, so perception gaps
and ambiguities between the user department and the development department can
be eliminated early.

c) Software is divided into two groups with and without the possibility of specification
changes, and then the processes of programming, review, and change are repeated
for the group with the possibility of changes.
.
d) A large-scale application is divided into highly independent parts, and the phases of
design, programming, and testing are repeated part by part while the development
scope is expanded gradually.

Question 41

Q

Which of the following is the most appropriate description concerning the role of the
user department in large-scale system development?

a) Without considering the effect of investment in the installed systems, user
department managers make efforts to have the development department accept
requests for additional features from the user department.

b) The user department is in the position of using systems developed by the
development department, so it is better to leave the development entirely to the
development department than to take part in it.

c) The user department checks the deliverables of system development from the
viewpoint of business operations, but details of program design are entrusted to the
development department.

d) The user department needs to actively participate in system development and to
provide advice, so its staff members who are unfamiliar with business processes but
knowledgeable about computers should participate in it at a higher priority.

Question 42

Q

There exist 50 work items, each having an equivalent workload, and a plan is made to
complete them in 10 days. However, at the end of the 5th day, only 20 items are
completed. If the delay in progress is to be represented as the difference between the
originally planned completion date and actual completion date for the work items that
are currently completed, how many days is the delay?

a) 1

b) 2

c) 3

d) 4

Question 43

Q

43.) Company A in the manufacturing industry uses an NC machine tool to perform four
tasks A through D. The setup time between each task is as shown in the table below.
When the four tasks are performed so that the total setup time can be minimized, how
long is the total setup time in hours? Here, the tasks can be carried out in any order,
and the setup time between FROM and TO can be used for evaluation; for example, the
setup time from task A to task B is 2 hours.

Question 44

Q

Which of the following is an appropriate description concerning the component
breakdown of the WBS (Work Breakdown Structure) in project management?

a) The deepest level of detail of the component breakdown is the level that enables
more accurate project planning and cost estimation.

b) The deepest level of detail of the component breakdown is always the same level
regardless of the project scale.

c) The depth of the component breakdown is always the same depth for all component
deliverables.

d) The deeper the level of the component breakdown is, the higher the level of the
work efficiency becomes.

Question 45

Q

Five staff members with the same productivity are assigned to an activity that takes 20
days. Immediately before the start of the activity, three members have influenza and
are replaced by new members. When the new members’ productivity is 60% of the
original members’, what is the minimum number of new staff members that is needed
to complete the activity in 20 days or less?

a) 4

b) 5

c) 7

d) 9

Question 46

Q

46.) In the arrow diagram shown below, Activity B is completed three days behind schedule.
In order to reduce the end-to-end delay to only one day, which activity should be
reduced by how many days?

Question 47

Q

Which of the following is the most appropriate description concerning the development
budget of a project?

a) A development plan is based on the total development budget, so the plan should not
be made by adding up the estimated costs of individual tasks.

b) The difference between the development budget and the actual cost should be
monitored, and then the plan should be reviewed and changed as necessary.

c) The development budget relates to the procurement of direct materials, so it should
not include the labor cost for the staff members who participate in the project.

d) A detailed estimate should be made using the FP (Function Point) method,
regardless of whether or not there is a similar project.

Question 48

Q

Which of the following is an appropriate description concerning the critical path in a
system development project?

a) When additional staff members are assigned in order to recover from a delay in
development, priority is given to activities on non-critical paths.

b) If an activity on the critical path is completed three days ahead of schedule, the
project is also completed three days earlier than expected.

c) If an activity on the critical path is delayed, completion of the project is also
delayed.

d) There exists only one critical path irrespective of the size, duration, or complexity of
the project.

Question 49

Q

Which of the following is the most appropriate description concerning system
operations?

a) There are many cases where problems and failures relating to system operations
cannot be realized until they actually occur, so it is better to take measures after
occurrence than to take proactive measures.

b) In order to perform system operations smoothly, it is preferable to strengthen the
authority of an operator and entrust the operator with a proper judgment relating to
the handling of a failure.

c) In order to perform system operations efficiently and effectively, it is better to
perform operational tests within the operations department than to request
participation from the development department and the user department.

d) Changes may occur after the system is put into full operation, so it is preferable to
define the standard of change management beforehand in order to ensure that all
changes are made in a controlled manner.

Question 50

Q

Mr. M was asked to prepare a management list of hardware, so he proposed a
management method using the table shown below.

Question 51

Q

Which of the following is an appropriate description concerning a benefit of
introducing and operating a service desk for a company.

a) Reducing the time before the release of a new version of software

b) Eliminating the use of software that is not approved

c) Reducing the out-of-service state caused by the failure of a system change

d) Responding to an inquiry as promptly as possible

Question 52

Q

Which of the following is the appropriate use of a security cable (or security wire)?

a) Preventing critical equipment from being destroyed in a fire

b) Preventing notebook PCs placed in the office from being stolen

c) Preventing the screens of mobile PCs used outside the office from being peeped at

d) Supplying alternative power to the system in the event of a power failure

Question 53

Q

Which of the following is the device that can cope well with a momentary loss of
electric power and can also supply alternative electric power for the period of time
required to shut down the system in the event of a power failure?

a) AVR

b) CVCF

c) UPS

d) Private power generator

Question 54

Q

As a result of the system audit on personal information protection, the sales department
is notified that a list of customers which is generated by an information system is not
handled properly in accordance with company-wide rules. Who is responsible for
making an improvement plan based on this notification?

a) The person in charge of the sales department

b) The person in charge of the audit department

c) The person in charge of the management planning department

d) The person in charge of the information systems department

Question 55

Q

When a function for internal control is established, which of the following means that
the distribution of roles and the authority of management are clarified?

a) Segregation of duties

b) Internal audit

c) Activity-based management

d) Risk control matrix

Question 56

Q

Which of the following is an appropriate description of internal control?

a) A process that is performed by all persons within a company in order to ensure the
effectiveness and efficiency of business operations, reliability of financial reporting,
compliance, and safeguarding of assets

b) A process where a manager who is entrusted with business management raises funds
from a financial institution and buys shares from the shareholders of a parent
company in order to obtain a controlling interest

c) An approach to both work and personal life outside of work where an attempt is
made to sacrifice neither work nor personal life and to keep a good balance between
both of them in a fulfilling way

d) A measure taken by an organization in order to achieve the target of organizational
activities, and a method that aims for the optimization of business activities and
systems

Question 57

Q

Which of the following is the term that refers to the description below?
Establish and take a course of action, investigate the result, and if the expected result
is not obtained, reflect upon the cause and utilize the conclusion in the next task.

a) AIDMA

b) PDCA

c) SWOT

d) Brainstorming

Question 58

Q

58.) Company A, in the manufacturing and sales industry, sells 30 products. Based on an
ABC analysis, products are to be narrowed down and then sales promotion is to be
performed for those products with high total sales. The table below shows total sales
by product. How many products are contained in “A group” that is subject to the
sales promotion? Here, “A group” represents approximately 70% of the company’s
total sales.

Question 59

Q

59.) The graph below shows the total sales transition over the past five years for a product
that was released by Company A five years ago. Which of the following is an
appropriate description concerning the analysis of the total sales?

Question 60

Q

In order to evaluate groupware installed, an information systems department sends a
questionnaire to employees once every six months. The questionnaire has eight
evaluation items including the transmission speed, level of sharing, and recentness of
information. Employees evaluate each item on a scale of one to ten. Which of the
following is an appropriate chart or diagram for representing this evaluation result?

a) Bar chart

b) Scatter diagram

c) Distribution chart

d) Radar chart

Question 61

Q

The table below shows the monthly sales of a particular product at a retailer that sells
approximately 200 types of products. The product is replenished during the
beginning of each month according to the inventory quantity checked at the end of the
previous month. Which of the following is the appropriate order placement method
for this product? Here, the sales ranking is determined as the ranking of the product
when all the products are ranked by the amount of sales.

Question 62

Q

A sales company records customer complaints in a complaint log. Which of the
following is an appropriate analysis material that is first created to reduce the number
of complaints?

a) Complaints are categorized, and the number of complaints is counted for each
category item. A Pareto chart is created using the category items and the number
of complaints as the axes.

b) The number of complaints is counted for each day of the week when a complaint is
received. A scatter diagram is created using the days of the week and the number
of complaints as the axes.

c) Regions of customers are categorized, and the number of complaints is counted for
each region. A histogram is created using the region categories and the number of
complaints as the axes.

d) Complaints that took long to respond are extracted into a list. Complaint items are
entered in the list so that the corresponding pages of the original complaint log can
be identified.

Question 63

Q

In cost accounting, which of the following is handled as a cost element?

a) Donation

b) Material cost

c) Bond interest

d) Extraordinary loss

Question 64

Q

Among actions concerning the creation of a computer program, which of the following
is a copyright violation?

a) Creating another Web page by using the source of HTML that was downloaded from
the Internet

b) Creating a program based on an idea that was discussed on a bulletin board on the
Internet

c) Creating a program to increase a company’s operational efficiency by using a
program that was created during one’s school days

d) Creating a program based on a flowchart that was shown in a purchased book

Brainscape's Knowledge GenomeTM

April 2012 Flashcards

Brainscape's Knowledge Genome^TM