Development and Applications

2

Systems Analysis and Design

3

Multiple Choice

1. Which of the following are advantages of the Traditional Systems Development Lifecycle (SDLC)?

i) Formal review at the end of each phase allows maximum management control

ii) This approach creates considerable system documentation

iii) Formal documentation ensures that system requirements can be traced back to stated business needs

iv) An operational prototype can be produced in weeks

v) This approach enables early detection of errors and omissions

1

[A] i), ii) and iii)

2

[B] i), iii) and v)

3

[C] ii), iii) and iv)

4

[D] ii), iii) and v)

5

[E] iii), iv) and v)

4

Multiple Choice

2. Under which of the following circumstances is outsourcing the systems development activities a good solution?

1

[A] When a firm is downsizing

2

[B] When a company believes it can cut costs

3

[C] When uninterrupted IS service is not crucial

4

[D] When the firm’s existing IS capabilities are limited, ineffective or technically inferior

5

[E] All of the above

5

Multiple Choice

3. The ability to manage change is critical to the success of systems development. Which of the following are considered most common problems that companies face?

1

[A] Reluctance to work with higher management

2

[B] The belief that the proposed system will create more work than it eliminates

3

[C] Fear that the employee will lose his or her job, power or influence within the organization

4

[D] [B] and [C]

5

[E] All of the above

6

Multiple Choice

4. The team at Cindy’s car hire want to develop a new car hire booking system. They are not sure whether this new system will fit in with the existing processes and procedures, so they realise that they need to determine its ________ feasibility.

1

[A] technical

2

[B] operational

3

[C] legal

4

[D] economic

5

[E] schedule

7

Multiple Choice

5. You have been approached to implement the disaster recovery plan in system security. Which of the following is NOT among the approaches you would use for disaster recovery?

1

[A] Hot Site

2

[B] Cold Site

3

[C] Warm Site

4

[D] Incremental backup

5

[E] [B] and [D]

8

Multiple Choice

6. A company is developing a robot prototype. The manager gave the instruction to test the prototype even before it is complete. What is the appropriate name for this type of system testing?

1

[A] Beta testing

2

[B] Alpha testing

3

[C] Acceptance testing

4

[D] Volume testing

5

[E] Integration testing

9

Multiple Choice

7. After testing the system, the process of making the final system fully operational starts. Which of the following is NOT among the approaches that the system developer would use to implement the new system in the organization?

1

[A] Direct conversion

2

[B] Hot start-up

3

[C] Pilot start-up

4

[D] Parallel start-up

5

[E] Phase-in

10

Multiple Choice

8. Prior to the rollout of the newly developed system, the user acceptance testing is conducted and validated by signing the user acceptance document. What is the benefit of signing such a document?

1

[A] The user is no longer bound to the system’s copyright

2

[B] The system’s maintenance becomes the user’s responsibility

3

[C] It increases the information system vendor’s liability

4

[D] It removes or reduces the information system vendor’s liability

5

[E] [A] and [B]

11

Multiple Choice

Questions 9 to 12 relate to the following diagram and narrative:

In your neighborhood, a resident must own at least one home. However, some residents own a few homes, which they rent out. Each home must be owned by only one owner.

9. The most appropriate symbol to replace circle 1 is ________.

1

[A]

2

[B]

3

[C]

4

[D]

5

[E]

12

Multiple Choice

Questions 9 to 12 relate to the following diagram and narrative:

In your neighborhood, a resident must own at least one home. However, some residents own a few homes, which they rent out. Each home must be owned by only one owner.

10. The most appropriate symbol to replace circle 2 is ________.

1

[A]

2

[B]

3

[C]

4

[D]

5

[E]

13

Multiple Choice

Questions 9 to 12 relate to the following diagram and narrative:

In your neighborhood, a resident must own at least one home. However, some residents own a few homes, which they rent out. Each home must be owned by only one owner.

11. Due to an economic crisis, some residents have sold their homes since they can no longer afford to pay the mortgage. They have decided to rent in the same house they once owned, since the rent is more affordable. The most appropriate symbol to replace circle 1 now is ________.

1

[A]

2

[B]

3

[C]

4

[D]

5

[E]

14

Multiple Choice

Questions 9 to 12 relate to the following diagram and narrative:

In your neighborhood, a resident must own at least one home. However, some residents own a few homes, which they rent out. Each home must be owned by only one owner.

12. The items below is/are an example(s) of ________.

HomeID, Street, City, Province, No_of_rooms

1

[A] entities

2

[B] attributes

3

[C] a primary keys

4

[D] an instance of an entity

5

[E] an instance of an attribute

15

Multiple Choice

Questions 13 to 15 refer to the diagram below that is based on a hospital scenario:

13. According to this diagram, it is optional for ________.

i) a doctor to treat a patient

ii) a patient to be prescribed a medicine

iii) a ward to be assigned to a patient

iv) a patient to be assigned a ward

v) a patient to be treated by a doctor

1

[A] i) and iii)

2

[B] i) and iv)

3

[C] ii) and iii)

4

[D] ii) and v)

5

[E] iv) and v)

16

Multiple Choice

Questions 13 to 15 refer to the diagram below that is based on a hospital scenario:

14. According to this diagram, ________.

i) a doctor must treat at least one patient

ii) a ward does not need to be assigned to a patient

iii) a patient must be treated by only one doctor

iv) a medicine can be prescribed to more than one patient

v) a patient does not need to be prescribed any medication

1

[A] i) and iii)

2

[B] i) and iv)

3

[C] ii) and iii)

4

[D] ii) and v)

5

[E] iv) and v)

17

Multiple Choice

Questions 13 to 15 refer to the diagram below that is based on a hospital scenario:

15. Based on the diagram, labels 1 and 2 refer to ________ and ________, respectively.

1

[A]

1 Attribute

2 Instance

2

[B]

1 Entity

2 Instance

3

[C]

1 Cardinality

2 Relationship

4

[D]

1 Relationship

2 Entity

5

[E]

1 Relationship

2 Cardinality

18

Multiple Choice

Questions 16 to 21 are based on the scenario and DFD below:

Customers wishing to put their property on the market visit the real estate agent who will take details of their house, duplex or flat and enter them on the system according to the suburb, price range and type of property. They can also call or provide their information via the website. Potential buyers also provide their information via the website. The real estate agent then matches the potential buyer requirements with the available properties and sends buyers the details of selected properties. If the buyer decides to buy a property, the buyer informs the real estate agent who then retrieves information about the selected property, completes a contract and sends one copy to the buyer and one to the seller for signing. The account clerk looks up information in the contract and sends an invoice to the buyer. Once payment is made, a receipt and stamped invoice copy are given to the buyer. The proposed DFD is as follows.

16. The label that should replace circle X is________.

1

[A] Give details

2

[B] Log onto the system

3

[C] Details

4

[D] Visit

5

[E] Call

19

Multiple Choice

Questions 16 to 21 are based on the scenario and DFD below:

Customers wishing to put their property on the market visit the real estate agent who will take details of their house, duplex or flat and enter them on the system according to the suburb, price range and type of property. They can also call or provide their information via the website. Potential buyers also provide their information via the website. The real estate agent then matches the potential buyer requirements with the available properties and sends buyers the details of selected properties. If the buyer decides to buy a property, the buyer informs the real estate agent who then retrieves information about the selected property, completes a contract and sends one copy to the buyer and one to the seller for signing. The account clerk looks up information in the contract and sends an invoice to the buyer. Once payment is made, a receipt and stamped invoice copy are given to the buyer. The proposed DFD is as follows.

17. What error(s) do you observe in the DFD?

1

[A] The account clerk is not an external entity and should be part of the system

2

[B] Customer should be written as Customers

3

[C] An estate agent entity is missing

4

[D] A call data flow label is missing

5

[E] A visit data flow label should be included

20

Multiple Choice

Questions 16 to 21 are based on the scenario and DFD below:

Customers wishing to put their property on the market visit the real estate agent who will take details of their house, duplex or flat and enter them on the system according to the suburb, price range and type of property. They can also call or provide their information via the website. Potential buyers also provide their information via the website. The real estate agent then matches the potential buyer requirements with the available properties and sends buyers the details of selected properties. If the buyer decides to buy a property, the buyer informs the real estate agent who then retrieves information about the selected property, completes a contract and sends one copy to the buyer and one to the seller for signing. The account clerk looks up information in the contract and sends an invoice to the buyer. Once payment is made, a receipt and stamped invoice copy are given to the buyer. The proposed DFD is as follows.

18. The label that should replace circle Y is ________.

1

[A] 1.Real Estate & Property Management System

2

[B] Real Estate Holdings system

3

[C] 0.1Real Estate Information System

4

[D] 0.Real Estate & Property Management System

5

[E] 1.Real Estate Information System

21

Multiple Choice

Questions 16 to 21 are based on the scenario and DFD below:

Customers wishing to put their property on the market visit the real estate agent who will take details of their house, duplex or flat and enter them on the system according to the suburb, price range and type of property. They can also call or provide their information via the website. Potential buyers also provide their information via the website. The real estate agent then matches the potential buyer requirements with the available properties and sends buyers the details of selected properties. If the buyer decides to buy a property, the buyer informs the real estate agent who then retrieves information about the selected property, completes a contract and sends one copy to the buyer and one to the seller for signing. The account clerk looks up information in the contract and sends an invoice to the buyer. Once payment is made, a receipt and stamped invoice copy are given to the buyer. The proposed DFD is as follows.

19. Which of the following is NOT the correct combination for system input and output as per the above scenario?

Inputs Outputs

1

[A] House Price

2

[B] Duplex/flat Price

3

[C] Buyer name Invoice

4

[D] Seller name Property

5

[E] Contract Payment

22

Multiple Choice

Questions 16 to 21 are based on the scenario and DFD below:

Customers wishing to put their property on the market visit the real estate agent who will take details of their house, duplex or flat and enter them on the system according to the suburb, price range and type of property. They can also call or provide their information via the website. Potential buyers also provide their information via the website. The real estate agent then matches the potential buyer requirements with the available properties and sends buyers the details of selected properties. If the buyer decides to buy a property, the buyer informs the real estate agent who then retrieves information about the selected property, completes a contract and sends one copy to the buyer and one to the seller for signing. The account clerk looks up information in the contract and sends an invoice to the buyer. Once payment is made, a receipt and stamped invoice copy are given to the buyer. The proposed DFD is as follows.

20. According to the scenario, how many external entities should be in the DFD?

1

[A] 1

2

[B] 2

3

[C] 3

4

[D] 4

5

[E] 5

23

Multiple Choice

Questions 16 to 21 are based on the scenario and DFD below:

Customers wishing to put their property on the market visit the real estate agent who will take details of their house, duplex or flat and enter them on the system according to the suburb, price range and type of property. They can also call or provide their information via the website. Potential buyers also provide their information via the website. The real estate agent then matches the potential buyer requirements with the available properties and sends buyers the details of selected properties. If the buyer decides to buy a property, the buyer informs the real estate agent who then retrieves information about the selected property, completes a contract and sends one copy to the buyer and one to the seller for signing. The account clerk looks up information in the contract and sends an invoice to the buyer. Once payment is made, a receipt and stamped invoice copy are given to the buyer. The proposed DFD is as follows.

21. Which of the following about data flow arrows is/are true?

1

[A] The order of arrows matters

2

[B] The direction of the arrow does not matter

3

[C] Arrows should be labeled with verbs

4

[D] The direction of arrows matter

5

[E] [A] and [D]

24

Multiple Choice

22. What does it mean when the system is referred to as a “black box” in DFDs?

1

[A] The system has a security vulnerability

2

[B] The inputs, outputs and general functions of the system are known, but the underlying details of the system are hidden.

3

[C] The system is designed like a box

4

[D] The internal operations of the system are revealed

5

[E] [C] and [D]

25

HTML (Hyper-text Markup Language)

26

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

23. The missing code labelled [1] is ________

1

[A] <! html DOCTYPE>

2

[B] <!DOCTYPE>

3

[C] <html DOCTYPE>

4

[D] <!DOCTYPE html>

5

[E] <DOCTYPE html>

27

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

24. The missing code labelled [2] is ________

1

[A] iLearn.com

2

[B] <title>iLearn.com</title>

3

[C] <title>iLearn.com<title>

4

[D] <div>iLearn.com</div>

5

[E] <tab>iLearn.com</tab>

28

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

25. The missing code labelled [3] is ________

1

[A] <a "https://www.iLearn.com/">

2

[B] <"https://www.iLearn.com/">

3

[C] <href="https://www.iLearn.com/">

4

[D] <a href="https://www.iLearn.com/"></a>

5

[E] <a href="https://www.iLearn.com/">

29

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

26. The missing attribute labelled [4] which displays a suitable message when an image does not load is ________.

1

[A] Message

2

[B] Alt

3

[C] Blank

4

[D] Target

5

[E] Default

30

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

27. The missing code labelled [5] is ________.

1

[A] link="top"

2

[B] top

3

[C] id="top"

4

[D] #="top"

5

[E] div="top"

31

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

28. The missing code labelled [6] is ________.

1

[A] <Webform></Webform>

2

[B] <tr></tr>

3

[C] <td></td>

4

[D] <form></form>

5

[E] <table></table>

32

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

29. The missing code labelled [7] is ________.

1

[A] input type="text"

2

[B] input type="textbox"

3

[C] input type="textarea"

4

[D] input type="areafortext"

5

[E] input type="fortext"

33

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

30. The missing code labelled [8] is ________

1

[A] input type="encrypt"

2

[B] input type="key"

3

[C] input type="password"

4

[D] input type="pass"

5

[E] input type="pwd"

34

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

31. The missing code labelled [9] is ________.

1

[A] checked

2

[B] mark

3

[C] tick

4

[D] ticked

5

[E] check

35

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

32. The missing code labelled [10.1 and 10.2] is ________.

1

[A] Send, Reset

2

[B] Clear, Reset

3

[C] Reset, Clear

4

[D] Reset, submit

5

[E] Submit, reset

36

Multiple Choice

Questions 23 to 33 are based on the image and HTML5 source code below:

33. The missing code labelled [11] is ________

1

[A] < href="#top">

2

[B] <a "#top">

3

[C] <a href="#top">

4

[D] <a href="top">

5

[E] <a href="divtop">

37

Multiple Choice

Questions 34 to 37 are based on the code below:

<style>

h1, h2, h3{

color: blue;

font-family: courier;

}

footer{

color:red;

}

</style>

34. The CSS code above is an example of an ________ stylesheet.

1

[A] embedded

2

[B] internal

3

[C] inner

4

[D] inline

5

[E] external

38

Multiple Choice

Questions 34 to 37 are based on the code below:

<style>

h1, h2, h3{

color: blue;

font-family: courier;

}

footer{

color:red;

}

</style>

35. The keyword “color” is an example of a(n) ________.

1

[A] attribute

2

[B] class

3

[C] id

4

[D] element

5

[E] property

39

Multiple Choice

Questions 34 to 37 are based on the code below:

<style>

h1, h2, h3{

color: blue;

font-family: courier;

}

footer{

color:red;

}

</style>

36. The term “h1” is an example of a(n) ________.

1

[A] selector

2

[B] class

3

[C] state

4

[D] id

5

[E] None of the above

40

Multiple Choice

Questions 34 to 37 are based on the code below:

<style>

h1, h2, h3{

color: blue;

font-family: courier;

}

footer{

color:red;

}

</style>

37. The keyword “footer” ________.

1

[A] defines a specific area

2

[B] displays text only at the bottom

3

[C] displays very small text

4

[D] [A] and [B]

5

[E] [B] and [C]

41

Multiple Choice

Questions 38 to 42 are based on the code below:

<[1] width="320" height="240" [2]>

<[3] [4]="movie.mp4" type="[5]">

</[1]>

38. The missing keyword labelled [1] is ________.

1

[A] audio

2

[B] form

3

[C] sound

4

[D] video

5

[E] plugin

42

Multiple Choice

Questions 38 to 42 are based on the code below:

<[1] width="320" height="240" [2]>

<[3] [4]="movie.mp4" type="[5]">

</[1]>

39. The missing keyword labelled [2] which displays, amongst others play, pause etc. is ________.

1

[A] controlpanel

2

[B] control

3

[C] controller

4

[D] cpanel

5

[E] controls

43

Multiple Choice

Questions 38 to 42 are based on the code below:

<[1] width="320" height="240" [2]>

<[3] [4]="movie.mp4" type="[5]">

</[1]>

40. The missing keyword labelled [3] is ________.

1

[A] id

2

[B] span

3

[C] div

4

[D] source

5

[E] class

44

Multiple Choice

Questions 38 to 42 are based on the code below:

<[1] width="320" height="240" [2]>

<[3] [4]="movie.mp4" type="[5]">

</[1]>

41. The missing keyword labelled [4] is ________.

1

[A] href

2

[B] link

3

[C] ref

4

[D] file

5

[E] src

45

Multiple Choice

Questions 38 to 42 are based on the code below:

<[1] width="320" height="240" [2]>

<[3] [4]="movie.mp4" type="[5]">

</[1]>

42. The missing code labelled [5] is ________.

1

[A] audio/movie.mp3

2

[B] movie.mp4

3

[C] audio/mp3

4

[D] video/mp4

5

[E] video/movie.mp4

46

Logical Problem Solving

47

Multiple Choice

43. In the flowchart below, to display the required output, the missing element Y should be replaced with ________.

1

[A] NUM < 999

2

[B] NUM > 99

3

[C] NUM > 100

4

[D] NUM < 100

5

[E] NUM < 0

48

Multiple Choice

Questions 44 and 45 are based on the following flowchart:

44. How many times will the user have to input a value for Mark?

1

[A] 1

2

[B] 2

3

[C] 3

4

[D] 4

5

[E] 5

49

Multiple Choice

Questions 44 and 45 are based on the following flowchart:

45. If you replace N=3? with N=1? and the user inputs a value of 2 for Mark, what will be the output of the flowchart?

1

[A] 1

2

[B] 2

3

[C] 3

4

[D] 4

5

[E] 0

50

Multiple Choice

Questions 46 to 49 are based on the narrative and flowchart below:

A process to add five (5) numbers is represented by the flowchart below. Two variables “Count” and “Sum” are set to count the numbers entered and calculate the total of the numbers, respectively.

46. What is the most appropriate text for the item labelled X?

1

[A] Count = Count + N

Sum = Sum + 1

2

[B] Count = Count + 1

Sum = Sum + N

3

[C] Sum = Sum + Count

4

[D] Count = Count + Sum

5

[E] Count = Count + N

Sum = Sum + N

51

Multiple Choice

Questions 46 to 49 are based on the narrative and flowchart below:

A process to add five (5) numbers is represented by the flowchart below. Two variables “Count” and “Sum” are set to count the numbers entered and calculate the total of the numbers, respectively.

47. What is the most appropriate text for the item labelled Y?

1

[A] Count + 1 > 5?

2

[B] Sum + N > 5?

3

[C] Count = 5?

4

[D] Sum > 5?

5

[E] Sum + Count > 5?

52

Multiple Choice

Questions 46 to 49 are based on the narrative and flowchart below:

A process to add five (5) numbers is represented by the flowchart below. Two variables “Count” and “Sum” are set to count the numbers entered and calculate the total of the numbers, respectively.

48. What is the most appropriate text for the item labelled Z?

1

[A] Yes

2

[B] No

3

[C] > 5

4

[D] = 5

5

[E] < 5

53

Multiple Choice

Questions 46 to 49 are based on the narrative and flowchart below:

A process to add five (5) numbers is represented by the flowchart below. Two variables “Count” and “Sum” are set to count the numbers entered and calculate the total of the numbers, respectively.

49. Given the following numbers; 23, 15, 10, 35, 50; what would the value of Sum be when Count = 3?

1

[A] 133

2

[B] 83

3

[C] 73

4

[D] 48

5

[E] 38

54

Multiple Choice

50. Which of the following is NOT one of the phases of the Programming Process?

1

[A] Apply a compiler to translate and execute the code

2

[B] Code the algorithm / flowchart

3

[C] Document and maintain the program

4

[D] Define the problem

5

[E] Outline the solution

55

Multiple Choice

51. During which phase of the Programming Process are the subtasks and user interface determined?

1

[A] Solution Outline Phase

2

[B] Problem Definition Phase

3

[C] Coding Phase

4

[D] Flowchart Phase

5

[E] Algorithm Phase

56

Business Applications - Microsoft Excel 2016

57

Multiple Choice

52. Which Lookup function should be used to find the Atomic Mass of Boron?

1

[A] =VLOOKUP(F1;B1:H4;3;FALSE)

2

[B] =HLOOKUP(F1;3;B1:H4;TRUE)

3

[C] =HLOOKUP(F1;B1:H4;3;FALSE)

4

[D] =HLOOKUP(F1;A1:H4;3;TRUE)

5

[E] =VLOOKUP(“Boron”;B1:H4;3,FALSE)

58

Multiple Choice

53. Which Lookup function should be used to calculate the Tax Rate in cell B3, if the Income is 21,500?

1

[A] =HLOOKUP(B2;C2:E6;3;TRUE)

2

[B] =VLOOKUP(B2;C2:E6;3;TRUE)

3

[C] =VLOOKUP(B2;C2:E6;3;FALSE)

4

[D] =VLOOKUP(B2;3;C2:E6;TRUE)

5

[E] =HLOOKUP(B2;C2:E6;3;FALSE)

59

Multiple Choice

54. Which of the following with regard to Lookup functions are FALSE?

i) A value of TRUE for the range-lookup is the default value

ii) The VLOOKUP function finds the greatest value that does not exceed the lookup_value

iii) When the lookup type is FALSE, the values in the first column of the lookup table must be sorted in ascending sort order

iv) If Excel does not find an exact match, the text #N/A is displayed in the cell

v) If index_number is less than one, the VLOOKUP function will return #REF!

1

[A] i) and ii)

2

[B] ii) and iii)

3

[C] iii) and iv)

4

[D] iii) and v)

5

[E] iv) and v)

60

Multiple Choice

55. Which of the following Field Lists was used to create the Pivot Table below?

Filters Columns Rows Values

1

[A] Subject Student Month Sum of Score

2

[B] Student Subject Month Count of Score

3

[C] Month Subject Student Sum of Score

4

[D] Score Month Subject Sum of Student

5

[E] Student Subject Month Sum of Score

61

Multiple Choice

56. Which of the following regarding Pivot Tables and Pivot Charts are true?

i) A PivotChart and its associated PivotTable must always be in the same workbook

ii) If you insert a standard chart for the PivotTable data, the chart will be a PivotChart that is associated with the PivotTable

iii) Deleting the Pivot Chart does not automatically delete the associated Pivot Table

iv) Deleting the Pivot Table automatically deletes the associated Pivot Table Chart

v) A Pivot Chart becomes static once its associated Pivot Table is deleted

1

[A] i), ii) and iii)

2

[B] ii), iii) and iv)

3

[C] i), ii), iii) and v)

4

[D] ii), iii), iv) and v)

5

[E] All of the above

62

Multiple Choice

57. Cell B6 was selected and then the ________ feature was used to display the arrow from cell B2 to B6.

1

[A] Data Validation

2

[B] Trace Dependents

3

[C] Trace Precedents

4

[D] Evaluate Formula

5

[E] Error Checking

63

Multiple Choice

58. Which of the following are guidelines on creating Excel templates?

i) Use lists and outlining

ii) Turn on worksheet gridlines

iii) Add the finishing touches

iv) Keep unused worksheets

v) Assume formulas will remain the same

1

[A] i), ii) and iii)

2

[B] i), iii) and v)

3

[C] ii), iii) and iv)

4

[D] ii), iv) and v)

5

[E] iii), iv) and v)

64

Multiple Choice

59. How many steps are there when importing data into Excel using the text import wizard?

1

[A] 1

2

[B] 2

3

[C] 3

4

[D] 4

5

[E] There is no such feature as the text import wizard

65

Microsoft PowerPoint 2016

66

Multiple Choice

Questions 60 and 61 are based on the screenshot below:

60. The diagram shows a ________ slide layout.

1

[A] Picture with Caption

2

[B] Title and Content

3

[C] Section Header

4

[D] Two Content

5

[E] Comparison

67

Multiple Choice

Questions 60 and 61 are based on the screenshot below:

61. The layout shown above is ________.

1

[A] used to show text in addition to a graphic

2

[B] used to separate different sections of the same presentation

3

[C] the default slide layout and the most commonly used slide layout

4

[D] used to compare two types of the same content type

5

[E] used to place content on the right side of the slide and a title and text on the right side

68

Multiple Choice

62. A Slide Master contains a(n)________ placeholder.

1

[A] title

2

[B] object

3

[C] master

4

[D] All of the above

5

[E] [A] and [B]

69

Multiple Choice

63. Sipho has created a new presentation and is currently adding some text to his slides. Which view is he using to accomplish this?

1

[A] Normal

2

[B] Outline View

3

[C] Slide Sorter

4

[D] Notes Page

5

[E] Reading View

70

Multiple Choice

64. Sophie has two pictures located in an external source. She wants to insert the two pictures into her presentation at the same time. Sophie has already clicked the Pictures icon in the Images group on the insert tab, and has browsed to the desired folder. She should then ________.

1

[A] hold the CTRL key while she selects the two pictures before clicking Insert button

2

[B] double-click the two pictures at the same time

3

[C] right-click the two pictures at the same time

4

[D] hold the ALT key while she selects the two and drag them into her presentation

5

[E] [A] and [B]

71

Multiple Choice

65. If the slideshow behaves according to what is displayed in the screenshot below, each slide of the presentation will advance ________.

1

[A] automatically after every after every 3 second

2

[B] automatically after every after every 3 minutes

3

[C] only when the presenter presses an arrow key

4

[D] only when the presenter presses the Esc key

5

[E] automatically after every after every 3 second with manual override

72

Multiple Choice

66. The best type of Chart that can be used to the number of orders received by each order method (fax, phone, email) over the last month is a(n) ________.

1

[A] Pie Chart

2

[B] Bar Chart

3

[C] Column Chart

4

[D] Area Chart

5

[E] [A] and [B]

73

ISA (Information Systems Auditing)

74

Multiple Choice

67. To accomplish the objective of audit planning, it is important to start by obtaining a(n) ________.

1

[A] proprietary charter

2

[B] financial record

3

[C] database record

4

[D] audit charter

5

[E] representation agreement

75

Multiple Choice

68. Risk assessment is useful in making decisions such as the ________.

1

[A] nature of audit procedures

2

[B] business function to be audited

3

[C] extent and timing of audit procedures

4

[D] amount of resources to be allocated to an audit

5

[E] All of the above

76

Multiple Choice

69. The risks that Amarok Plc may be exposed to, has been identified and assessed by an auditor. After the assessment, the management of Amarok decided to insure the organization, to protect against the identified risks. The risk management technique adopted by Amarok to manage the identified risks falls under ________.

1

[A] Retention

2

[B] Avoidance

3

[C] Transfer

4

[D] Acceptance

5

[E] Mitigation

77

Multiple Choice

70. Jonathan wants to perform a business process analysis. In doing so, he should ________.

1

[A] identify areas of control weaknesses

2

[B] firstly develop an internal control environment

3

[C] develop a conceptual framework for his investigation

4

[D] [B] and [C]

5

[E] All of the above

78

Multiple Choice

71. Standing in a queue, an individual steals money from the person in front of him. On realising that the CCTV camera was facing him directly, he decides to return the stolen money because he knows the footage from the camera can be used as a form of ________ evidence against him.

1

[A] diagnostic

2

[B] testimonial

3

[C] analytical

4

[D] documentary

5

[E] physical

79

Multiple Choice

72. Which of the following is true about COBIT?

1

[A] It is an IT governance framework

2

[B] It is based on a set of best practices for information management

3

[C] It was created by the ISACA IT Governance Institute

4

[D] It is a supporting toolset that allows managers to bridge the gaps among control requirements

5

[E] All of the above

80

Multiple Choice

73. Upon the performance of the audit test, the Information Systems Auditor is required to produce a(n)________.

1

[A] report

2

[B] memo

3

[C] verdict

4

[D] judgement

5

[E] policy

81

Multiple Choice

74. The IS audit aims to evaluate which of the following?

1

[A] Confidentiality

2

[B] Integrity

3

[C] Availability

4

[D] [A] and [B]

5

[E] All of the above

82

Multiple Choice

75. The auditors who investigate and gather evidence where there has been alleged financial mismanagement are ________ auditors.

1

[A] criminal

2

[B] government

3

[C] forensic

4

[D] pathological

5

[E] internal

83

Multiple Choice

76. Weaknesses that can be exploited by threats to cause damage are referred to as ________.

1

[A] liability

2

[B] vulnerabilities

3

[C] voracious

4

[D] susceptibility

5

[E] destructive

84

Multiple Choice

77. CAATs may be used in performing all of the following audit procedures, except ________.

1

[A] restructuring the organisational network

2

[B] compliance tests of IS general controls

3

[C] compliance tests of IS application controls

4

[D] testing details of transactions and balances (Substantive Tests)

5

[E] analytical review procedures

85

Multiple Choice

78. There are a number of control measures that can be taken with a view to assist in preventing or alleviating disaster. Which of the following is an example of such control measures?

1

[A] Regular maintenance and servicing of equipment to prevent failure

2

[B] Adequate insurance cover to provide funds to replace equipment

3

[C] Arrangements for support to be provided by suppliers of equipment and software

4

[D] Avoidance of undue reliance on key personnel by maintaining complete and appropriate documentation

5

[E] All of the above

86

Multiple Choice

79. A disaster recovery plan ________.

1

[A] states an audits limitations

2

[B] is a written document that lists the procedures which should be carried out by each employee in the event of a disaster

3

[C] provides audit evidence

4

[D] states the period of coverage, nature, timing and the extent of the audit work

5

[E] is a detailed transaction file made available before the onset of the audit

87

Multiple Choice

80. Audit evidence may be classified as ________.

1

[A] sufficient

2

[B] useful

3

[C] relevant

4

[D] competent

5

[E] All of the above

88

Multiple Choice

81. The risks that exist within the processes of an organisation and that are entirely in the hands of the organisation to mitigate are called ________ risks.

1

[A] limited

2

[B] effective

3

[C] dominant

4

[D] controllable

5

[E] determinable

89

ISM (Information Systems Management)

90

Multiple Choice

82. What mechanisms are built into systems to ensure that performance of systems is measured/maintained and corrected?

1

[A] Memory

2

[B] Processors

3

[C] Controls

4

[D] Bus

5

[E] Capacitors

91

Multiple Choice

83. The government has deployed an information system to register people for voting next year and to print their records. The system was expected to print 10000 records per day, but printed 9800 records. If you compare the expectation and actual performance, you would say the system is ________.

1

[A] efficient

2

[B] objective

3

[C] inefficient

4

[D] undesirable

5

[E] effective

92

Multiple Choice

84. Which of the following is NOT a component of an information system?

1

[A] Hardware

2

[B] People

3

[C] Software

4

[D] Communication networks

5

[E] Data resources

93

Multiple Choice

85. Which system component is supposed to replace X?

1

[A] Control

2

[B] System

3

[C] Memory

4

[D] Feedback

5

[E] Information system

94

Multiple Choice

86. A company has decided to outsource its research function, specifically on intellectual property for its patent applications. What is the appropriate term for this kind of outsourcing?

1

[A] Business process outsourcing

2

[B] Patent process outsourcing

3

[C] System outsourcing

4

[D] Knowledge process outsourcing

5

[E] Technical outsourcing

95

Multiple Choice

87. Which of the following does not guide the management of information systems on a continual basis?

1

[A] Policies

2

[B] Procedures

3

[C] Technology

4

[D] Standards

5

[E] Best practices

96

Multiple Choice

88. Which of the following is the main aim of having a security policy?

1

[A] To secure the main assets of an information system

2

[B] For research purposes

3

[C] To ensure proper data is collected

4

[D] To ensure auditing and compliance

5

[E] To give credibility to an information system

97

Multiple Choice

89. Which of the following is NOT among the Porter’s 5 Forces model?

1

[A] Technology

2

[B] Barriers to entry

3

[C] Suppliers

4

[D] Competitors

5

[E] Substitute products

98

Multiple Choice

90. Which of the following is/are NOT a benefit of outsourcing information systems?

1

[A] Low virus attacks

2

[B] Improved service quality

3

[C] Faster delivery speed

4

[D] Reduce overall cost of setting up and maintaining an IS

5

[E] [C] and [D]

99

Multiple Choice

91. What structure(s) must an organization put in place to ensure that the right IS decisions are made and the right people are accountable for such decisions?

1

[A] Hire skilled IS personnel

2

[B] Have an IS Governance committee

3

[C] Ensure an effective management authority

4

[D] The right Human Resources structure

5

[E] Implement Access controls

100

Multiple Choice

92. The IT manager of a company received reports that the IS operations of the company are not being carried out efficiently and effectively. What would be the first thing you would advise him to do?

1

[A] Employ new IT specialist

2

[B] Train the employees

3

[C] Review and update current IS policies

4

[D] Define new procedures to replace current procedures

5

[E] Review the current IS systems

101

Multiple Choice

93. During this semester, both the student helpdesk and the university IT support center have received numerous complains about poor IS services which include the email system not being available, the website going down, moodle being offline, etc.

Which of the following areas of IS management require critical review, assessment and improvement?

1

[A] IS Policies & Standards

2

[B] ITIL V3 implementation

3

[C] Cobit 4.1 implementation

4

[D] Students Access Controls

5

[E] Management Skills

102

Multiple Choice

94. The university has planned to have all the five campuses share the same IT infrastructure and applications from a single campus by 2020. Which of the following statements would be a poor reason for this plan?

1

[A] Ensure better management control of IS within the university

2

[B] To reduce the cost of overall IS management

3

[C] Improve standardization of IT systems

4

[D] Achieve timely response to IS issues within the university

5

[E] Easier training for all IS personnel

103

Multiple Choice

95. Due to poor IT services delivery at its PMB branch, Pick-n-Pay Supermarket management appointed Mr. Naidoo as the new IT manager at the PMB branch to immediately improve IT services delivery at the branch. Which of the following must be his first source of guidelines to achieve this?

1

[A] Review the IS Management structure

2

[B] Change current IS Policies and Procedures

3

[C] Review best practices implementation within the company

4

[D] Implement COBIT 4.1

5

[E] Implement IS Governance

104

Multiple Choice

96. Sbu went to the student helpdesk office to obtain a user login name to access the LAN. He was requested by student helpdesk assistant to produce his student card to verify that he is a student before he would be assisted. Which of the following is an accurate control being implemented by the assistant?

1

[A] Information Systems Control

2

[B] Procedural Control

3

[C] Student Access Control

4

[D] Physical Access Control

5

[E] LAN Access Control

105

Multiple Choice

97. Which of the following IS would you recommend to a director of a company to enable him/her to make efficient decisions?

1

[A] Decision Support Systems

2

[B] Executive Support Systems

3

[C] Transactional Processing Systems

4

[D] Inventory Management System

5

[E] Enterprise Management System

106

Multiple Choice

98. The end-user of an Information System refers ________.

1

[A] the system programmer

2

[B] the last person to use the system

3

[C] the hardware and software implementer

4

[D] the person with low level of IS expertise

5

[E] the person who installed the system

107

Multiple Choice

99. Why is it important for the management structure for information systems management within an organization to be aligned to the various functions within the organization?

1

[A] To create independency between management and information systems

2

[B] To achieve autonomy in decision making

3

[C] To conform to the organization’s management structure

4

[D] To achieve responsibility and accountability

5

[E] To develop IS Specialist

108

Multiple Choice

100. The emergence of the high speed networks, high capacity and resilient hardware and distributed architecture support systems have made which of the following information system management structure possible?

1

[A] Centralised

2

[B] Decentralised

3

[C] Hybrid

4

[D] Traditional

5

[E] Matrix

Development and Applications

Development and Applications

Systems Analysis and Design

HTML (Hyper-text Markup Language)

Logical Problem Solving

Business Applications - Microsoft Excel 2016

Microsoft PowerPoint 2016

ISA (Information Systems Auditing)

ISM (Information Systems Management)

Development and Applications

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Instructional Technology