LearnIPAReviewHistory
Profile
AboutHow I passedUse with AIFeedback
LearnIPA
Review
History
Profile
LearnIPAReviewHistory
Profile
AboutHow I passedUse with AIFeedback
IP 2018 Autumn

ITPEC IP October 2018 — Question 1 of 100

Question 1

A survey into the amount of pocket money is conducted at three (3) schools. When the consolidated results of the survey are used to calculate the average pocket money per student for all the students of the three (3) schools, which of the following is the expression that is entered into cell C5?

ABC12345Number of studentsAverage of pocket money per studentSchool M1501,250School N250850School P601,530Average of pocket money per student

ITPEC IP October 2018 — Question 2 of 100

Question 2

Which of the following is obtained by multiplying the binary value 10110 by three (3)?

ITPEC IP October 2018 — Question 3 of 100

Question 3

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

ITPEC IP October 2018 — Question 4 of 100

Question 4

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

ITPEC IP October 2018 — Question 5 of 100

Question 5

At a desk that is only large enough to place 4 files at the same time, 6 files, A through F, are used to perform a task. When 4 files are already placed on the desk, the least recently used file must be placed back into the drawer before the fifth file can be placed on the desk. When the files are used in the sequence A, B, C, D, B, A, E, A, B, F, which of the following is the last file placed back into the drawer?

ITPEC IP October 2018 — Question 6 of 100

Question 6

There exist four states numbered 1 through 4. The four states are connected as shown in the figure below, and the state transition occurs in a clockwise or counter-clockwise direction.

1234

If the current state is 1, which of the following is the state that is reached after the procedure below is performed twice?

[Procedure]

The number of the current state is multiplied by 11, and the result is divided by three (3). The process below is performed based on the remainder of the division.

  • •When the remainder is zero (0), a transition to the next state occurs in the clockwise direction.
  • •When the remainder is one (1), a transition to the next state occurs in the counter-clockwise direction.
  • •When the remainder is two (2), a transition to the second state occurs in the clockwise direction.

ITPEC IP October 2018 — Question 7 of 100

Question 7

In a queue, three elements 33, 27, and 12 are stored (or enqueued) in this order. After the element 45 is added to this queue, two elements are retrieved (or dequeued). Which of the following is the second element that has been retrieved?

ITPEC IP October 2018 — Question 8 of 100

Question 8

There is a program that displays text in accordance with the specifications below. When the original text described below is displayed, in what point size does the program display the underlined character string? Here, the first character of the original text is displayed in 10 points.

[Specifications]

The characters between <B> and </B> are displayed one point larger than the preceding character.

The characters between <S> and </S> are displayed one point smaller than the preceding character.

Each of <B> </B> and <S> </S> must be used as a pair, and both of them can be nested with each other.

[Original text]

The system administrator promotes and implements <B>department-level<B> or

<S>group-level</S> computerization</B> from a user’s <S>standpoint</S>.</B>

ITPEC IP October 2018 — Question 9 of 100

Question 9

Which of the following is an appropriate description concerning the Java language?

ITPEC IP October 2018 — Question 10 of 100

Question 10

Which of the following is the correct comparison of the amount of data?

Questions 11–20

ITPEC IP October 2018 — Question 11 of 100

Question 11

Which of the following is designed to virtually reduce the time for the CPU to access the main memory, in order to improve the processing efficiency of a PC?

ITPEC IP October 2018 — Question 12 of 100

Question 12

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

ITPEC IP October 2018 — Question 13 of 100

Question 13

Which of the following is the most appropriate description concerning a multi-core processor?

ITPEC IP October 2018 — Question 14 of 100

Question 14

In reliability engineering, which of the following is the index represented by the y-axis of a bathtub curve?

y-axis0Time

ITPEC IP October 2018 — Question 15 of 100

Question 15

There are three devices, A, B, and C, with availabilities of 0.90, 0.95, and 0.95 respectively. Among the systems combining these devices shown below, which of the following has the highest availability? Here, at least one of the parallel-connected devices must be available, and all of the serially-connected devices must be available.

ITPEC IP October 2018 — Question 16 of 100

Question 16

When the processing speed of the system overall is constrained because of slow processing speed in one of the components, which of the following is a term for the component of a system that is causing the problem?

ITPEC IP October 2018 — Question 17 of 100

Question 17

As shown in the spreadsheet below, three types of examinations were conducted. Each type of examination has a different perfect score. Each resulting score is converted to a value assuming 100 points as the perfect score, and displayed in cells F3 through H10. Which of the following is the expression to be entered in cell F3? Here, the expression in cell F3 is copied to cells F3 through H10.

ABCDEFGH1234510EnglishMathScienceEnglishMathSciencePerfect score250200150John Mayer180180115Brian Jones23515595Tom Scott20685150Susan Miller245105108

ITPEC IP October 2018 — Question 18 of 100

Question 18

An examination is conducted, and the results of the examination are grouped into four grades “Excellent,” “Good,” “Passed,” and “Not passed,” based on the scores by using spreadsheet software. To show the results of grouping in column C, an expression is entered in cell C1 and then copied to cells C2 through C35. Which of the following is the appropriate expression to be entered into cell C1? Here, the procedure for grouping is as shown below.

[Spreadsheet creation procedure](1)Cells A1 through A35 contain scores.(2)Cell A36 contains a function to calculate the average score.(3)Cell B1 contains the expression below, and this expression is copied to cells B2 through B35.   A1 − $A$36(4)Grades are defined as follows: if the score is above the average by 10 points or more, it is marked as “Excellent”; if it is equal to or above the average by less than 10 points, it is marked as “Good”; if it is below the average by 10 points or less, it is marked as “Passed”; all other scores are marked as “Not passed.”

ITPEC IP October 2018 — Question 19 of 100

Question 19

Which of the following is the image data that is pasted onto the documents and web pages created by the word-processing software and presentation software so as to improve the expressive power?

ITPEC IP October 2018 — Question 20 of 100

Question 20

Which of the following is the expression to be entered into cell D4 in order to calculate the after-tax 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.

ABCDE12345Sales tax rate 1Sales tax rate 2Tax rate0.10.2ProductnameBefore-taxpriceAfter-tax price 1After-tax price 2Product A500550600Product B600660720
Questions 21–30

ITPEC IP October 2018 — Question 21 of 100

Question 21

Which of the following is an advantage of using OSS (Open Source Software)?

ITPEC IP October 2018 — Question 22 of 100

Question 22

Multiple files stored on a hard disk are used in work, from Monday to Friday. In order to handle failure of the hard disk, the data is backed up to another hard disk after the end of each day’s work. When the backup has following conditions, what is the total time required (in minutes) to perform backups of data for Monday to Friday?

[Conditions for backups](1)There are 6,000 files used in work, each with a size of 3 Mbytes.(2)In each day’s work, 1,000 files are modified. Modifications do not change the size of the files.(3)Files are copied to the other hard disk at a speed of 10 Mbytes/second. One file at a time is backed up; backup continues without interruption.(4)From Monday to Thursday, only files modified that day are backed up. On Friday, all files are backed up, whether or not they have been modified.

ITPEC IP October 2018 — Question 23 of 100

Question 23

Which of the following is an appropriate explanation of a blade server?

ITPEC IP October 2018 — Question 24 of 100

Question 24

Which of the following is an appropriate concept of universal design?

ITPEC IP October 2018 — Question 25 of 100

Question 25

Which of the following is the most appropriate explanation of virtual reality?

ITPEC IP October 2018 — Question 26 of 100

Question 26

A hard disk failure occurred on a mail server, and e-mails of many users were lost. Recovery of data was attempted, but e-mails sent and received during the two-week period after the last backup could not be restored because backups were only created every two weeks. Taking a lesson from this incident, a measure is to be implemented to allow restoration up to the state of the day before such a failure. Which of the following is an appropriate measure?

ITPEC IP October 2018 — Question 27 of 100

Question 27

The “Sales Details” table and the “Products” table are managed in a relational database. What is the total number of notebooks sold?

Sales Details

VouchernumberProduct_codeNumber_sold
H001S00120
H001S00340
H002S00260
H002S00380

Products

Product_codeProduct_name
S001Pencil
S002Eraser
S003Notebook

ITPEC IP October 2018 — Question 28 of 100

Question 28

Which of the following is an appropriate effect obtained through the normalization of data in a relational database?

ITPEC IP October 2018 — Question 29 of 100

Question 29

Which of the following is an appropriate description concerning foreign keys in a relational database?

ITPEC IP October 2018 — Question 30 of 100

Question 30

Which of the following is used to identify a wireless LAN network?

Questions 31–40

ITPEC IP October 2018 — Question 31 of 100

Question 31

Mr. A specifies the destinations for an e-mail as below and sends it. Mr. Y receives this e-mail, and sends a reply to all the recipients and the sender listed in the e-mail. Among Mr. A, Mr. X, and Mr. Z, which of the following is the list that includes all and only the destinations of the e-mail that Mr. Y sends?

[Destinations specified for Mr. A’s e-mail]

To: X

CC: Y

BCC: Z

ITPEC IP October 2018 — Question 32 of 100

Question 32

Which of the following is an appropriate explanation of the POP communications protocol?

ITPEC IP October 2018 — Question 33 of 100

Question 33

Which of the following is an example of damage incurred by the theft of cookies by a cross site scripting attack or other attack?

ITPEC IP October 2018 — Question 34 of 100

Question 34

Among the examples of conducting communication between a PC, a server, a communication device, a printer, etc., which of the following is the list that contains all and only the examples that require the use of a WAN?

A:In a server room, a PC and a web server are connected to the same network hub, and a company overview web page is uploaded from the PC to the web server.B:A notebook PC is connected to an access point in a LAN within a campus of a university, and lecture materials are downloaded from a web server on the same campus.C:A file server connected to a LAN in the Tokyo headquarters is accessed from a PC in the Osaka branch office, and files are downloaded.

ITPEC IP October 2018 — Question 35 of 100

Question 35

Which of the following is an appropriate disposal method for media that stores confidential information to ensure that information leakage does not occur?

ITPEC IP October 2018 — Question 36 of 100

Question 36

Which of the following sets conditions for character type, length, etc. used for passwords that are set for accounts on a computer, etc.?

ITPEC IP October 2018 — Question 37 of 100

Question 37

Which of the following is a technique for taking advantage of psychological weaknesses or carelessness in order to improperly obtain confidential information?

ITPEC IP October 2018 — Question 38 of 100

Question 38

Which of the following is the threat that can be prevented by encrypting data?

ITPEC IP October 2018 — Question 39 of 100

Question 39

When an abnormality in power supply voltage caused by power failure, lightning strike, etc. has been detected, a company wishes to inform its computers of this event, continue supplying power for a certain period of time, and safely shut down systems. Which of the following is an appropriate device that should be installed between computers and the power supply for this purpose?

ITPEC IP October 2018 — Question 40 of 100

Question 40

Which of the following is an appropriate explanation of a VPN?

Questions 41–50

ITPEC IP October 2018 — Question 41 of 100

Question 41

Among confidentiality, integrity, and availability, which of the following is the list that contains all items that are lost in the incident below, which involves information security?

All of the files on a server in the workplace were encrypted and saved. However, the server was infected by a virus, and a number of the files were deleted. Elimination of the virus and recovery of the files required several hours, during which work could not be performed and users were inconvenienced.

ITPEC IP October 2018 — Question 42 of 100

Question 42

In a file system that uses the access control methods below, which of the following settings for access rights to file A satisfy the conditions for access control?

[Access control method of the file system]•Units for the setting of access rights: Owner; Users in the same group as owner; Other users•Access rights: R (Read), W (Write), X (Execute)•Priority of access rights: From highest priority to lowest, settings are prioritized in the order of “Owner”; “Users in the same group as owner”; “Other users”
[Conditions for access control to file A]•All users are able to execute the file.•Only the owner and users in the same group as the owner are able to read from the file.•Only the owner is able to write to the file.

*: Set  –: Not set

OwnerUsers in the same group as the ownerOther users
OptionRWXRWXRWX

ITPEC IP October 2018 — Question 43 of 100

Question 43

During the use of a PC in workplace, a message was displayed stating that antivirus software had detected a virus. Which of the following is an appropriate action that should be taken immediately on the PC?

ITPEC IP October 2018 — Question 44 of 100

Question 44

Which of the following is an appropriate example of biometric authentication?

ITPEC IP October 2018 — Question 45 of 100

Question 45

Which of the following is an appropriate description concerning the reliability of a system or a device?

ITPEC IP October 2018 — Question 46 of 100

Question 46

In order to check that a system works normally, a user department and the information systems department are to jointly perform operational testing before operation,. Which of the following is an appropriate content of the test performed by the user department?

ITPEC IP October 2018 — Question 47 of 100

Question 47

Which of the following is the test method that verifies a system based solely on the functions as it is seen from the outside and with no consideration of the internal structure, focusing only on inputs and outputs to check that the output expected from the system specifications is obtained for any given input?

ITPEC IP October 2018 — Question 48 of 100

Question 48

Among the descriptions A through D below, which of the following is the list that contains all items that are to be considered in the design of screens for easy-to-use for system users?

A:The time to recover from a failureB:The ease of learning of operationC:The layout of pushbuttonsD:The size and color of text

ITPEC IP October 2018 — Question 49 of 100

Question 49

The processes of system development include system requirements definition, systems architecture design, system integration testing, and software acceptance. Which of the following is an activity that is performed in system requirements definition?

ITPEC IP October 2018 — Question 50 of 100

Question 50

A company purchased the enterprise license of software X that can be used for 100 PCs, and then installed it on those PCs. Which of the following is an action that complies with the license agreement?

Questions 51–60

ITPEC IP October 2018 — Question 51 of 100

Question 51

Which of the following is the first task to be performed when a project is initiated?

ITPEC IP October 2018 — Question 52 of 100

Question 52

In the arrow diagram below, what is the maximum number of days that can be allowed as a delay of the activity “C→F” on condition that the total number of days required for activities from A through G is not affected?

ABCDEFG3374366474
[Legend]Number ofdays required

ITPEC IP October 2018 — Question 53 of 100

Question 53

Which of the following is an item that must be clarified in order to determine the appropriate assignment of the members participating in a project?

ITPEC IP October 2018 — Question 54 of 100

Question 54

In a system development project, as a measure for improving the productivity of program creation, a training to improve skills for using development tools is planned for new members. Which of the following is the most appropriate indicator to evaluate the effect of this measure?

ITPEC IP October 2018 — Question 55 of 100

Question 55

Quality management in system development projects has a quality planning process to define quality requirements and quality standards for deliverables and to specify the methods for achieving them. Which of the following is appropriate to this quality planning process?

ITPEC IP October 2018 — Question 56 of 100

Question 56

Which of the following is an appropriate explanation of component decomposition that is performed to create the WBS of a system development project?

ITPEC IP October 2018 — Question 57 of 100

Question 57

The response measure for risks that may occur in a project can be classified as avoidance, mitigation, acceptance, and transfer. In a system development project, the design and development process is to be subcontracted to Company A. In a previous system development, Company A suffered a delay for delivery, so it is also possible that a delay will occur in this project. Which of the following is a response measure that corresponds to mitigation of the risk of a delay?

ITPEC IP October 2018 — Question 58 of 100

Question 58

Which of the following is an appropriate description concerning reliability?

ITPEC IP October 2018 — Question 59 of 100

Question 59

Which of the following is an appropriate explanation concerning proactive countermeasures against various threats that hinder stable operation of information systems?

ITPEC IP October 2018 — Question 60 of 100

Question 60

Which of the following is the most appropriate explanation of what a service desk implements?

Questions 61–70

ITPEC IP October 2018 — Question 61 of 100

Question 61

An SLA contains a written description of arrangements, such as the content of the service agreed upon between a service provider and a service user. Which of the following is an appropriate merit that is obtained by both the service provider and the service user through concluding an SLA?

ITPEC IP October 2018 — Question 62 of 100

Question 62

Among the management activities for an information system that are performed by IT service management, which of the following is a process that provides a temporary workaround for a system failure and performs a prompt recovery?

ITPEC IP October 2018 — Question 63 of 100

Question 63

A system auditor is required to have an independent and professional standpoint. When a system audit is performed in a company, which of the following is the example that contradicts with the independence of the system auditor?

ITPEC IP October 2018 — Question 64 of 100

Question 64

Which of the following is an appropriate combination of words to be inserted into blanks A and B in the description below concerning the implementation of internal control?

The implementation of internal control requires A, separation of duties, setting of rules and procedures, and B.

OptionAB

ITPEC IP October 2018 — Question 65 of 100

Question 65

Which of the following is an appropriate description concerning evaluations in systems audit?

ITPEC IP October 2018 — Question 66 of 100

Question 66

Which of the following is an explanation of corporate philosophy?

ITPEC IP October 2018 — Question 67 of 100

Question 67

Among the senior management positions, which of the following is the highest-ranking person who exercises control over the information system?

ITPEC IP October 2018 — Question 68 of 100

Question 68

Which of the following is a cost that has a relationship with the calculation of operating profit in an income statement?

ITPEC IP October 2018 — Question 69 of 100

Question 69

Which of the following is a consolidated financial statement by which a parent company indicates the status of revenue and expenses of an accounting period of a corporate group including subsidiaries?

ITPEC IP October 2018 — Question 70 of 100

Question 70

Which of the following is an appropriate diagram or chart that is used for ABC analysis?

Questions 71–80

ITPEC IP October 2018 — Question 71 of 100

Question 71

Which of the following is the scope that the CFO, one of the positions involved in corporate management, bears responsibility for?

ITPEC IP October 2018 — Question 72 of 100

Question 72

Which of the following is the most appropriate term that applies to the example below?

“In order to achieve continuous growth, a company withdraws from business area A with stagnant sales, and puts the management resources into strengthening business area B.”

ITPEC IP October 2018 — Question 73 of 100

Question 73

Among the lists of corporate activities A through D, which of the following is the list that contains all activities concerning the establishment of compliance?

A:Supporting fine art and cultural activitiesB:Training employees in the codes of conductC:Performing activities for prevention of global desertificationD:Creating a mechanism of internal communication

ITPEC IP October 2018 — Question 74 of 100

Question 74

Which of the following is one of the characteristics of QR code?

ITPEC IP October 2018 — Question 75 of 100

Question 75

Which of the following is an explanation of a volume license agreement on software?

ITPEC IP October 2018 — Question 76 of 100

Question 76

In the case of placing an order for a product on an Internet shopping site, at which point is the sales contract concluded?

ITPEC IP October 2018 — Question 77 of 100

Question 77

Which of the following is an international standard for environmental management systems developed by ISO?

ITPEC IP October 2018 — Question 78 of 100

Question 78

Which of the following examples of sending e-mail is inappropriate from the standpoint of the protection of personal information?

ITPEC IP October 2018 — Question 79 of 100

Question 79

Which of the following is an explanation of compliance management?

ITPEC IP October 2018 — Question 80 of 100

Question 80

Company X summarized the results of positioning analysis of its marketing power in relation to competitors into the table as shown below. In the table, “1” is the lowest score, and “5” is the highest score. Where does Company X rank from the top?

 WeightCompany XCompany ACompany BCompany C
Price53432
Product quality33325
Brand name34251
Selling power42445
Questions 81–90

ITPEC IP October 2018 — Question 81 of 100

Question 81

In the planning of the business strategy of a retail business, “retention of loyal customers” is set as the CSF (Critical Success Factor). Which of the following is the most appropriate analysis that is used for evaluating the achievement level of the CSF?

ITPEC IP October 2018 — Question 82 of 100

Question 82

Which of the following is the marketing technique that is composed of four components: product, price, place, and promotion?

ITPEC IP October 2018 — Question 83 of 100

Question 83

Which of the following is an appropriate combination of a management theme and a technique for achieving it?

[Management themes]A:A company wishes to develop efficient business processes that span from procurement of components to sales.B:A company wishes to understand customers’ preferences and other information, and use this information in product planning and sales promotion.C:A company wishes to know the product name, quantity, and other sales-related information at the time of sale in order to restock appropriately and analyze strong-selling products.

[Techniques]

 CRM, POS, SCM

OptionABC

ITPEC IP October 2018 — Question 84 of 100

Question 84

Which of the following is appropriate as the evaluation axes in PPM that are used in optimizing the allocation of management resources across multiple businesses in a company?

ITPEC IP October 2018 — Question 85 of 100

Question 85

In the promotion of technology development, charts such as the one shown in the example are used for the evaluation of progress or for checking consistency with related technologies. What is the name of this sort of chart that records the route toward progress in required functions, underlying technology, etc. through research and development initiatives on the time axis?

Prospects for web page search technology and analytical functions

PresentAfter1 yearAfter2 yearsAfter3 yearsAfter4 yearsAfter5 yearsSearchtechnologyAnalyticalfunctionsAssociated search subjectsUse of semantic searchText-centeredanalysisAnalysis through semanticinformation conferred on characterstrings on web page

ITPEC IP October 2018 — Question 86 of 100

Question 86

Which of the following is supported by a CAD system?

ITPEC IP October 2018 — Question 87 of 100

Question 87

Which of the following is the situation where an improvement can be expected by installing an MRP (Material Requirements Planning) system?

ITPEC IP October 2018 — Question 88 of 100

Question 88

The table below shows the relationship between the standard number of staff and the number of days required to complete preparation activities A through E of an event. The preparation activities started 35 days before the event and have been conducted according to the table; however, only one staff member was assigned during the first 20 days. In order to complete the remaining activities to meet the original deadline, what is the minimum number of staff members that must be reserved per day for the remaining period? Here, the preparation activities can be performed in any sequence, any staff member can achieve the same productivity in each activity, and any number of staff members can be assigned to an activity at one time.

Preparation activityStandard number of staff(persons)Number of days required(days)
A25
B25
C310
D25
E510

ITPEC IP October 2018 — Question 89 of 100

Question 89

A factory is engaged in assembly production of product P that consists of components A and B. The processing of component A requires component C, and the processing period is one week. The delivery lead times of purchased components B and C are two weeks and three weeks, respectively. Product P can be assembled in one week only after components A and B are both delivered. What is the minimum number of weeks required to produce one unit of product P, including the delivery periods of the components? Here, there is no stock of any of the components.

ITPEC IP October 2018 — Question 90 of 100

Question 90

Which of the following is an appropriate explanation of the point card system (or loyalty program) offered by retailers?

Questions 91–100

ITPEC IP October 2018 — Question 91 of 100

Question 91

Which of the following describes EDI?

ITPEC IP October 2018 — Question 92 of 100

Question 92

An ERP package is a suite of fully integrated software applications that are used to perform administrative business processes, such as financial management, procurement, personnel, and payroll administration. Which of the following is the most appropriate description concerning such an ERP package?

ITPEC IP October 2018 — Question 93 of 100

Question 93

When system development is outsourced for the purpose of building a system, which of the following is an appropriate item to be considered?

ITPEC IP October 2018 — Question 94 of 100

Question 94

Which of the following is term for a method that uses data such as accumulated sales data to find regularity such as a correlation between weather and products that sell well?

ITPEC IP October 2018 — Question 95 of 100

Question 95

Which of the following is the most appropriate training content for improving the information literacy of sales employees?

ITPEC IP October 2018 — Question 96 of 100

Question 96

Which of the following is an item that must be considered when information systems strategy is drafted?

ITPEC IP October 2018 — Question 97 of 100

Question 97

Which of the following is an explanation of “acceptance inspection” performed for a vendor?

ITPEC IP October 2018 — Question 98 of 100

Question 98

Which of the following is a process in the software life cycle that includes the creation of a computerization project?

ITPEC IP October 2018 — Question 99 of 100

Question 99

Which of the following is the most appropriate description concerning the creation of documents in the development and maintenance of software?

ITPEC IP October 2018 — Question 100 of 100

Question 100

For the procurement of a system, which of the following is an appropriate combination of the words or terms corresponding to blanks A and B?

In Company A, during the procurement of a new system, an RFI is presented to vendors with the aim of obtaining A. Thereafter, an RFP is presented to the vendors with the aim of obtaining B, and then a contractor is selected.

OptionAB
LearnIPA
Review
History
Profile