1. The systems development life cycle (SDLC) is the process of _____.
A. building an information system
B. delivering an information system to a client
C. designing an information system
D. understanding how an information system can support business needs
E. all of the above
2. In which phase of the SDLC is the system proposal developed?
A. analysis
B. design
C. implementation
D. planning
E. system delivery
3. In which phase of the SDLC is the system specification developed?
A. analysis
B. design
C. implementation
D. planning
E. system delivery
4. The primary advantage of the Waterfall Development methodology is that _____.
A. a version of the system is quickly delivered into the users' hands
B. requirements evolve through users' feedback about the system
C. features and functionality of the system are explored through simple models
D. requirements are completely specified and held relatively constant prior to programming
E. there is a long time lapse prior to completion
5. _____ development is a structured design methodology that divides the project into a series of distinct subprojects that can be designed and implemented together.
A. Parallel
B. Phased
C. Prototyping
D. Rapid Application
E. Throwaway Prototyping
6. Which of the following systems development methodologies involves developing the system in a series of sequential versions?
A. Parallel Development
B. Phased Development
C. Prototyping
D. Throw-Away Prototyping
E. Waterfall Development
7. Kim repeatedly performs the analysis, design, and implementation phases concurrently in a cycle until the system is completed. She is following the _____ methodology.
A. parallel
B. phased
C. prototyping
D. rapid application throwaway prototyping
E. waterfall
8. The _____ development methodology is never recommended when system reliability is very critical.
A. parallel
B. phased
C. prototyping
D. throwaway prototyping
E. waterfall
9. The most commonly used information-gathering technique is _____.
A. interviewing
B. joint application design (JAD) sessions
C. document analysis
D. observation
E. questionnaires
10. A systems analyst has prepared an interview agenda that begins with a number of specific, detailed questions, and then asks the interviewee to make general statements about the policies and procedure of the business process. The analyst is following a(n) _____ interview structure.
A. bottom up
B. closed
C. open ended
D. probing
E. top down
11. A JAD facilitator is _____.
A. allowed to participate in the discussion to settle a disagreement
B. enters key information into the computer
C. is also a power user
D. the person who records the discussion
E. the person who sets the meeting agenda
12. The information-gathering strategy most commonly used to gather information OUTSIDE of the organization is _____.
A. document analysis
B. interviewing
C. joint application design (JAD) sessions
D. observation
E. use of questionnaires
13. The examination of existing paperwork in order to better understand the as-is system is an example of what information-gathering strategy?
A. document analysis
B. interviewing
C. joint application design (JAD) sessions
D. observation
E. questionnaires
14. During document analysis Kim has learned that the users in the purchasing department have created their own forms. This is a clear sign that the _____.
A. as-is system is meeting user needs
B. department was overlooked during the interview process
C. process does not need improvements
D. system needs to be changed
E. users in the department are innovative
15. Each use case describes how the system reacts to a(n) _____ that occurs to trigger the system.
A. activity
B. event
C. model
D. session
E. tropical
16. When developing use cases, the project team first identifies the _____.
A. managers that supervise the use case department
B. place where the use case occurs
C. time the use case begins
D. triggering event that causes the use case to occur
E. users who perform the use case
17. A common omission by end users when identifying elements within Use Case steps is _____.
A. analytical analysis of the identity elements
B. JAD session classification
C. requirements definition
D. role play analysis
E. seldom used activities or special cases
18. Validating that the use case is correct and complete is the major activity performed during which step of the Writing Use Case Reports process?
A. identify elements within steps
B. identify the major steps within each use case
C. identify the use cases
D. confirm the use case
E. write the use case report
19. Which of the following is a component of a data flow diagram that represents an activity or a function that is performed for some specific business reason?
A. data flow
B. data store
C. entity
D. external entity
E. process
20. Which of the following is a component of a data flow diagram that represents a person, organization, or system that is outside the system but interacts with it?
A. data flow
B. data store
C. external entity
D. process
E. relationship
21. The DFD that shows the overall business system as just one process and shows the data flows to and from external entities is called a(n) _____.
A. process model
B. context diagram
C. level 0 diagram
D. level 1 diagram
E. level 2 diagram
22. When a process produces two different data flows under different circumstances, this is called a(n) _____.
A. alternative data flow
B. approved data flow
C. join
D. mutual exclusive
E. split
23. Each step of a Use Case usually become a(n) _____ on the Level 1 Data Flow Diagram.
A. data flow
B. data store
C. external entity
D. join
E. process
24. A data model is a formal way of representing _____.
A. a physical process model
B. how a business system processes
C. the current system’s procedures (i.e., the as-is system)
D. the data that are used and created by a business system
E. the new procedures for the to-be system
25. The _____ is the basic building block for a data model.
A. attribute
B. data flow
C. entity
D. process
E. relationship
26. The maximum number of times that an instance of Entity A can be related to an instance or instances of Entity B is its _____.
A. associative relationship
B. balance
C. cardinality
D. dependent relationship
E. modality
27. An entity that is created to store information about the relationship between two other entities is called a(n) _____ entity.
A. dependent
B. incomplete
C. independent
D. intersection
E. non-identifying
28. When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key, which step of normalization is being performed?
A. base normal form
B. first normal form
C. second normal form
D. third normal form
E. cannot tell from the above information
29. The first step in the Design Phase is to _____.
A. convert logical process and data models to physical
B. create the deliverable
C. design the architecture
D. design the inputs and outputs
E. present design alternatives
30. The following are all strengths of a custom development design strategy EXCEPT _____.
A. builds technical skills
B. creates functional knowledge in-house
C. greater creativity
D. greater flexibility
E. lower risk
31. An advantage of purchasing packaged software is that the organization can _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. have developers climb the knowledge ladder
D. make strategic changes during implementation
E. save money on the purchase
32. Manipulating certain parameters to refine the way features work in a software package is called _____.
A. a workaround
B. adjustment
C. customization
D. feature adjustability
E. parameterizing
33. A disadvantage of outsourcing the application development process is that the organization may _____.
A. build technical skills and functional knowledge in-house
B. lose control over confidential information
C. accept functionality that is far from a perfect fit
D. remove all risk from the project
E. make strategic changes during implementation
34. When moving from the logical data flow diagram to the physical, the first step is to _____.
A. add implementation references
B. add system related data store
C. draw human-machine boundaries
D. update the data elements
E. update the metadata
35. The plan for the creation of the hardware and software infrastructure is commonly called _____.
A. architecture design
B. hardware specifications
C. software specifications
D. network model
E. presentation logic
36. Which of the following is NOT one of the four basic functions of a computer application?
A. application logic
B. data access logic
C. data storage
D. networking logic
E. presentation logic
37. The application function that is documented in the data flow diagrams is called _____.
A. application logic
B. data access logic
C. data storage
D. presentation logic
E. network logic
38. A server in the client-based architecture performs which of the following application functions?
A. application logic
B. data access logic and presentation logic
C. data storage
D. data storage and presentation logic
E. presentation logic and application logic
39. Assume that your network has a server and three clients, the network is an example of a(n) _____.
A. n-tiered architecture
B. single-tiered architecture
C. three-tiered architecture
D. tireless architecture
E. two-tiered architecture
40. When all files are regularly tested for worms, bugs, and illicit programs; this is an example of _____ requirements.
A. access control
B. encryption and authentication
C. portability
D. technical environment
E. virus control
41. A(n) _____ file stores past transactions that may no longer be needed, is usually stored off-line, and can be accessed on an as-needed basis.
A. audit
B. history
C. look-up
D. master
E. transaction
42. The most efficient tables in a relational database in terms of storage space have _____.
A. no redundant data and few null values
B. no redundant data and plenty of null values
C. redundant data and few null values
D. redundant data and plenty of null values
E. repeat customer information
43. The process of adding redundancy back into a physical data model is known as _____.
A. balancing
B. clustering
C. denormalization
D. indexing
E. normalization
44. In a structure chart, the element that communicates that a message or a system flag is being passed from one module to another is known as a _____.
A. conditional line
B. connector
C. control couple
D. data couple
E. loop
45. The purpose of a(n) _____ is to communicate that a module is repeated in a structure chart.
A. conditional line
B. control couple
C. iteration
D. loop
E. module
46. _____ is essentially a function or procedure call from one object to another, and is the information sent to objects to trigger methods.
A. encapsulation
B. information hiding
C. inheritance
D. a message
E. polymorphism
47. _____ is the general template used to define and create specific instances or objects.
A. a class
B. inheritance
C. a message
D. polymorphism
E. a method
48. A highly cohesive unit that contains both data and processes is known as a(n) _____.
A. class
B. concrete class
C. entity
D. event
E. object
49. The class diagram in Unified Modelling Language (UML) is similar to what diagram in traditional systems analysis and design?
A. context diagram
B. data model
C. network diagram
D. process model
E. structure diagram
50. The UML diagramming technique that shows the different state that a single class passes through in reponse to events is the _____ diagram.
A. class
B. sequence
C. statechart
D. use case
E. component
[50 marks total for Section A]
SECTION B
1. This question is about Program Design and Structure Charts
a) In what way is a structure chart useful for program design? List the four steps required to produce a structure chart.
b) Construct a structure chart based on the following program scenario, including an explanation of all parts of your diagram:
You are working for a computer video game company, and you are asked to design a new game called Alien Invaders. In each life, the player tries to destroy the enemy before he/she is killed. In this game the player has 3 lives. At the end of each life, the score is calculated and displayed. When all 3 lives have been lost, if the score is greater than the current high score, the player is presented with the message ‘Well Done - you have beaten the High-Score!’. Otherwise, the message ‘You have not beaten the High-Score - Press Fire Button to play again!’ is shown. Then, the High-Score list itself is displayed.
2. This question is about Process Modelling and Data Flow Diagrams (DFDs).
a) Explain the meaning of the following terms as used in process modelling: data store, decomposition, level 0 DFD, and level 1 DFD.
b) Identify the processes, data flows, data stores, and external entities in the following situation. Provide a diagram to illustrate your answer.
For a restaurant business, at the end of a day a management report is produced that extracts the daily items-sold amounts from the items-sold file and the daily inventory depletion amounts from the inventory file. The report is forwarded to the restaurant management. At the end of the week a weekly summary report of items-sold and inventory depletion is created and distributed on-line to the corporate headquarters in Richmond.
3. This question is about Data Modelling and Entity Relationship Diagrams (ERDs)
(adapted from Dennis & Wixom, 2000)
a) Consider the Entity Relationship Diagram (ERD) above. This is part of a diagram showing the data and relationships in an online CD Sales and Marketing System.
Explain the terms cardinality, modality, entity, attribute and identifier, using the above diagram as an example.
b) Redraw the above diagram in your answerbook, modifying it to add customer details, including lastname, firstname, address, city, postcode, and email. Indicate the relationships, modality and cardinality clearly in your diagram.
Friday, February 24, 2012
Systems Analysis and Design Exercise 05
1. In which phase of the systems development life cycle (SDLC) is the system specification
developed?
A. Implementation
B. Analysis
C. Planning
D. Design
2. Which of the following systems development methodologies involves developing the
system in a series of sequential versions?
A. Waterfall Development
B. Parallel Development
C. Phased Development
D. Prototyping
E. Throw-Away Prototyping
3. The primary advantage of the Waterfall Development methodology is:
A. A version of the system is quickly delivered into the users' hands.
B. Requirements evolve through users' feedback about the system.
C. Features and functionality of the system are explored through simple models.
D. Requirements are completely specified and held relatively constant prior to
programming.
E. None of the above.
4. If the system under development will employ technology with which the analysts and
programmers are unfamiliar, the most appropriate methodology to employ is:
A. Waterfall Development
B. Throw-Away Prototyping
C. Parallel Development
D. Phased Development
E. Prototyping
5. During an interview, the following question is asked; "How many times during a typical
week does a customer complain about inadequate service following a sale?" This question
is an example of a(n) _____________
A. probing question.
B. open-ended question.
C. closed-ended question.
D. inappropriate question.
E. opinion question.
6. In a JAD (Joint Application Design) Session, which of the following is not a proper role
for the facilitator?
A. Assist the group in understanding the analysis techniques.
B. Document group output on a public display.
C. Ensure that the JAD session agenda is followed.
D. Cast the deciding vote on controversial issues.
E. All of the above are proper facilitator roles.
7. The information gathering technique that is most effective in combining information from
a variety of perspectives, building consensus, and resolving discrepancies is the ________
A. interview.
B. JAD session.
C. questionnaire.
D. document analysis.
E. observation.
8. Which of the following is a component of a data flow diagram that represents an activity
or a function that is performed for some specific business reason?
A. process
B. external entity
C. data flow
D. data store
E. none of the above
9. The purpose of the context diagram is to _____________
A. define the branching that will occur within the system.
B. define the detailed processing that will be performed by the system users.
C. show the overall system in its environment with key data flows going to and from
the external entities.
D. show the major subsystems in the system and define their interactions with each
other and with the external entities.
E. none of the above
10. The one component of data flow diagrams that is NOT usually depicted on the context
diagram is a(n) _____________
A. process.
B. data flow.
C. external entity.
D. data store.
E. all will be shown on the context diagram.
11. The most preferred method of validating a process model is to _____________
A. have the analysts check each others' work.
B. have the system analysts describe the system to the users.
C. have the users role play the process execution exactly as it is specified in the
DFDs.
D. ensure that terms are used consistently throughout the model.
E. have the CASE tool perform syntax checking.
12. The best definition of a data entity in an Entity Relationship Diagram (ERD) is
A. some type of information that is captured by the system.
B. a person, place, or thing about which data is collected.
C. a unique identifier for objects in the system.
D. an association between system objects.
E. None of the above
13. The best definition of an entity attribute is _____________
A. a characteristic of the entity that can uniquely identify all entity instances.
B. some type of information that is captured about an entity.
C. a person, place, or thing about which data is collected.
D. an association between system objects.
E. None of the above
14. Which of the following is NOT a step in building an ERD?
A. identify entity attributes.
B. define relationships between entities.
C. populate the diagram with sample data.
D. identify entities.
E. All of the above are steps in building an ERD.
15. An intersection (associative) entity _____________
A. is illegal in entity-relationship diagramming.
B. can exist without another related entity.
C. makes an entity-relationship diagram more complex.
D. is created to store information about two entities that share an M:M relationship.
E. None of the above
16. Which of the following development strategies is preferred when the business need is
common and time is a constraining factor?
A. in-house, custom development
B. purchased software
C. end-user development
D. outsourcing
E. None of the above
17. Which of the following statements about physical ERDs is true?
A. Physical ERDs are comprised of components that are different from those in
logical ERDs
B. Physical ERDs have different rules compared to logical ERDs
C. Physical ERDs contain details regarding the system's actual implementation.
D. a. and b. only are true
E. all of the above are true
18. Which of the following is NOT one of the fundamental computing architectures?
A. Client-based computing
B. System-based computing
C. Server-based computing
D. Client-server based computing
19. What is one primary problem with server-based computing architectures?
A. Servers are no longer made by hardware vendors.
B. Client terminals are no longer made by hardware vendors.
C. As users place heavier demands on the server, it is costly to increase server
capacity.
D. It is difficult to maintain security in the server-based environment.
E. None of the above are problems with server-based architectures.
20. What is one primary problem with the client-based computing architecture?
A. Applications are difficult and expensive to develop.
B. Cost of the components (hardware and software) is excessive.
C. Applications are complex to learn and use.
D. Network performance can degrade substantially.
E. None of the above are problems with client-based architectures.
21. The most common threat to a computer system is posed by _____________
A. internal hackers.
B. industrial espionage.
C. device failure.
D. viruses.
E. natural disasters.
22. A file that stores information on who, when, and how data was altered is a(n) ______ file.
A. audit
B. history
C. look-up
D. master
E. transaction
23. The normalization process is performed primarily to increase the database's ___________
A. storage efficiency.
B. indexing scheme.
C. access speed.
D. multiple dimensions.
E. none of the above.
24. When the analyst is evaluating a data model to ensure that all fields in a record depend
fully on the entire primary key, which step of normalization is being performed?
A. Base normal form
B. First normal form
C. Second normal form
D. Third normal form
E. Cannot tell from the above information.
25. In a structure chart, the purpose of a control module is _____________
A. to perform detail decision logic on transactions.
B. to contain the logic needed to direct the execution of other modules.
C. to direct the printing of program output.
D. a. and b.
E. a., b., and c.
26. A major weakness of structure charts is that _____________
A. conditional logic cannot be shown.
B. a sequence of actions that is repeated cannot be shown.
C. the flow of data between modules cannot be shown.
D. the flow of conditional parameters between modules cannot be shown.
E. None of the above is a weakness.
27. The ability of the same message to be interpreted differently by different classes of
objects is referred to as _____________
A. encapsulation.
B. polymorphism.
C. inheritance.
D. association.
E. None of the above.
28. The foundation of the Unified Modelling Language is the _____________
A. use case.
B. object.
C. activity diagram.
D. message.
E. method.
29. The element of a use case diagram that is similar to the external entity of Data Flow
Diagrams (DFDs) is the _____________
A. instance.
B. use case.
C. actor.
D. boundary.
E. None of the above
30. The Unified Modelling Language diagramming technique that illustrates the classes and
messages involved in a use case is the _____________
A. use case diagram.
B. sequence diagram.
C. class diagram.
D. statechart diagram.
E. None of the above
SECTION B
1. This question is about Computing Architectures
a) The terms client and server are frequently used in the field of systems architecture design.
Explain the meaning of these two terms, giving TWO examples of each.
b) What is meant by application logic, presentation logic, data access logic, and data storage?
How are these typically placed in a three-tiered client-server system?
c) Discuss the main advantages and disadvantages such a system has when compared with
purely client-based or server-based architectures.
2. This question is about UML (Unified Modelling Language) and Object-Oriented Systems
Analysis and Design.
a) Explain the meaning of the following terms as used in object-oriented systems analysis and
design: message, object, encapsulation, and polymorphism.
b) In UML, a class diagram can be used to show relationships between classes. Draw a simple
class diagram as used in an object-oriented approach to systems analysis and design, using the
information in the scenario below:
In Northolt Health Centre, a General Practitioner (GP) is a general kind of doctor, who can
treat common ailments. A Specialist is a doctor who specialises in a particular field of
medicine and patient care, and treats patients with only those particular problems. A Nurse
also treats patients with common ailments. The GP, Specialist and Nurse are all employees of
the Health Centre.
c) Using the diagram given as your answer to Question 2(b) above as an example, explain what
is meant by inheritance. Why is this a useful concept in systems analysis and design?
3. This question is about Data Storage
a) Based on the Data Flow Diagram (DFD) below, construct an Entity Relationship Diagram
(ERD) and briefly discuss the three major steps to move from DFD to ERD.
(adapted from Dennis & Wixom, 2000)
b) Using the ERD produced in your answer to Question 3(a) above as an example, explain the
meaning of the following five terms: entity, attribute, identifier, modality, and cardinality.
c) An ERD is often used as the basis for creation of a Relational Database. Starting with your
answers to Question 3(a) and 3(b), explain how an identifier in an ERD is used in such a
database.
developed?
A. Implementation
B. Analysis
C. Planning
D. Design
2. Which of the following systems development methodologies involves developing the
system in a series of sequential versions?
A. Waterfall Development
B. Parallel Development
C. Phased Development
D. Prototyping
E. Throw-Away Prototyping
3. The primary advantage of the Waterfall Development methodology is:
A. A version of the system is quickly delivered into the users' hands.
B. Requirements evolve through users' feedback about the system.
C. Features and functionality of the system are explored through simple models.
D. Requirements are completely specified and held relatively constant prior to
programming.
E. None of the above.
4. If the system under development will employ technology with which the analysts and
programmers are unfamiliar, the most appropriate methodology to employ is:
A. Waterfall Development
B. Throw-Away Prototyping
C. Parallel Development
D. Phased Development
E. Prototyping
5. During an interview, the following question is asked; "How many times during a typical
week does a customer complain about inadequate service following a sale?" This question
is an example of a(n) _____________
A. probing question.
B. open-ended question.
C. closed-ended question.
D. inappropriate question.
E. opinion question.
6. In a JAD (Joint Application Design) Session, which of the following is not a proper role
for the facilitator?
A. Assist the group in understanding the analysis techniques.
B. Document group output on a public display.
C. Ensure that the JAD session agenda is followed.
D. Cast the deciding vote on controversial issues.
E. All of the above are proper facilitator roles.
7. The information gathering technique that is most effective in combining information from
a variety of perspectives, building consensus, and resolving discrepancies is the ________
A. interview.
B. JAD session.
C. questionnaire.
D. document analysis.
E. observation.
8. Which of the following is a component of a data flow diagram that represents an activity
or a function that is performed for some specific business reason?
A. process
B. external entity
C. data flow
D. data store
E. none of the above
9. The purpose of the context diagram is to _____________
A. define the branching that will occur within the system.
B. define the detailed processing that will be performed by the system users.
C. show the overall system in its environment with key data flows going to and from
the external entities.
D. show the major subsystems in the system and define their interactions with each
other and with the external entities.
E. none of the above
10. The one component of data flow diagrams that is NOT usually depicted on the context
diagram is a(n) _____________
A. process.
B. data flow.
C. external entity.
D. data store.
E. all will be shown on the context diagram.
11. The most preferred method of validating a process model is to _____________
A. have the analysts check each others' work.
B. have the system analysts describe the system to the users.
C. have the users role play the process execution exactly as it is specified in the
DFDs.
D. ensure that terms are used consistently throughout the model.
E. have the CASE tool perform syntax checking.
12. The best definition of a data entity in an Entity Relationship Diagram (ERD) is
A. some type of information that is captured by the system.
B. a person, place, or thing about which data is collected.
C. a unique identifier for objects in the system.
D. an association between system objects.
E. None of the above
13. The best definition of an entity attribute is _____________
A. a characteristic of the entity that can uniquely identify all entity instances.
B. some type of information that is captured about an entity.
C. a person, place, or thing about which data is collected.
D. an association between system objects.
E. None of the above
14. Which of the following is NOT a step in building an ERD?
A. identify entity attributes.
B. define relationships between entities.
C. populate the diagram with sample data.
D. identify entities.
E. All of the above are steps in building an ERD.
15. An intersection (associative) entity _____________
A. is illegal in entity-relationship diagramming.
B. can exist without another related entity.
C. makes an entity-relationship diagram more complex.
D. is created to store information about two entities that share an M:M relationship.
E. None of the above
16. Which of the following development strategies is preferred when the business need is
common and time is a constraining factor?
A. in-house, custom development
B. purchased software
C. end-user development
D. outsourcing
E. None of the above
17. Which of the following statements about physical ERDs is true?
A. Physical ERDs are comprised of components that are different from those in
logical ERDs
B. Physical ERDs have different rules compared to logical ERDs
C. Physical ERDs contain details regarding the system's actual implementation.
D. a. and b. only are true
E. all of the above are true
18. Which of the following is NOT one of the fundamental computing architectures?
A. Client-based computing
B. System-based computing
C. Server-based computing
D. Client-server based computing
19. What is one primary problem with server-based computing architectures?
A. Servers are no longer made by hardware vendors.
B. Client terminals are no longer made by hardware vendors.
C. As users place heavier demands on the server, it is costly to increase server
capacity.
D. It is difficult to maintain security in the server-based environment.
E. None of the above are problems with server-based architectures.
20. What is one primary problem with the client-based computing architecture?
A. Applications are difficult and expensive to develop.
B. Cost of the components (hardware and software) is excessive.
C. Applications are complex to learn and use.
D. Network performance can degrade substantially.
E. None of the above are problems with client-based architectures.
21. The most common threat to a computer system is posed by _____________
A. internal hackers.
B. industrial espionage.
C. device failure.
D. viruses.
E. natural disasters.
22. A file that stores information on who, when, and how data was altered is a(n) ______ file.
A. audit
B. history
C. look-up
D. master
E. transaction
23. The normalization process is performed primarily to increase the database's ___________
A. storage efficiency.
B. indexing scheme.
C. access speed.
D. multiple dimensions.
E. none of the above.
24. When the analyst is evaluating a data model to ensure that all fields in a record depend
fully on the entire primary key, which step of normalization is being performed?
A. Base normal form
B. First normal form
C. Second normal form
D. Third normal form
E. Cannot tell from the above information.
25. In a structure chart, the purpose of a control module is _____________
A. to perform detail decision logic on transactions.
B. to contain the logic needed to direct the execution of other modules.
C. to direct the printing of program output.
D. a. and b.
E. a., b., and c.
26. A major weakness of structure charts is that _____________
A. conditional logic cannot be shown.
B. a sequence of actions that is repeated cannot be shown.
C. the flow of data between modules cannot be shown.
D. the flow of conditional parameters between modules cannot be shown.
E. None of the above is a weakness.
27. The ability of the same message to be interpreted differently by different classes of
objects is referred to as _____________
A. encapsulation.
B. polymorphism.
C. inheritance.
D. association.
E. None of the above.
28. The foundation of the Unified Modelling Language is the _____________
A. use case.
B. object.
C. activity diagram.
D. message.
E. method.
29. The element of a use case diagram that is similar to the external entity of Data Flow
Diagrams (DFDs) is the _____________
A. instance.
B. use case.
C. actor.
D. boundary.
E. None of the above
30. The Unified Modelling Language diagramming technique that illustrates the classes and
messages involved in a use case is the _____________
A. use case diagram.
B. sequence diagram.
C. class diagram.
D. statechart diagram.
E. None of the above
SECTION B
1. This question is about Computing Architectures
a) The terms client and server are frequently used in the field of systems architecture design.
Explain the meaning of these two terms, giving TWO examples of each.
b) What is meant by application logic, presentation logic, data access logic, and data storage?
How are these typically placed in a three-tiered client-server system?
c) Discuss the main advantages and disadvantages such a system has when compared with
purely client-based or server-based architectures.
2. This question is about UML (Unified Modelling Language) and Object-Oriented Systems
Analysis and Design.
a) Explain the meaning of the following terms as used in object-oriented systems analysis and
design: message, object, encapsulation, and polymorphism.
b) In UML, a class diagram can be used to show relationships between classes. Draw a simple
class diagram as used in an object-oriented approach to systems analysis and design, using the
information in the scenario below:
In Northolt Health Centre, a General Practitioner (GP) is a general kind of doctor, who can
treat common ailments. A Specialist is a doctor who specialises in a particular field of
medicine and patient care, and treats patients with only those particular problems. A Nurse
also treats patients with common ailments. The GP, Specialist and Nurse are all employees of
the Health Centre.
c) Using the diagram given as your answer to Question 2(b) above as an example, explain what
is meant by inheritance. Why is this a useful concept in systems analysis and design?
3. This question is about Data Storage
a) Based on the Data Flow Diagram (DFD) below, construct an Entity Relationship Diagram
(ERD) and briefly discuss the three major steps to move from DFD to ERD.
(adapted from Dennis & Wixom, 2000)
b) Using the ERD produced in your answer to Question 3(a) above as an example, explain the
meaning of the following five terms: entity, attribute, identifier, modality, and cardinality.
c) An ERD is often used as the basis for creation of a Relational Database. Starting with your
answers to Question 3(a) and 3(b), explain how an identifier in an ERD is used in such a
database.
Systems Analysis and Design Exercise 04
1. The person that identifies opportunities for improvements and designs an information system to implement
them is called a(n) .
A. computer programmer
B. end-user
C. systems analyst
D. systems specialist
E. technical writer
2. The primary goal of the systems analyst is to .
A. acquire a working tool
B. create a wonderful system
C. create value for the organisation
D. establish the three phases of the SDLC
E. purchase a silver bullet
3. The four phases of the Systems Development Life Cycle are .
A. analysis, gathering, modelling, and diagramming
B. construction, installation, testing, and converting
C. designing, charting, formatting, and structuring
D. planning, analysis, design, and implementation
E. system request, feasibility, planning, and staffing
4. Determining who will use the system, what the system will do, and where and when it will be used is
performed during the phase of the SDLC.
A. analysis
B. design
C. implementation
D. modelling
E. planning
5. Deciding how the hardware, software, and network infrastructure will operate occurs during the
phase of the SDLC.
A. analysis
B. design
C. implementation
D. planning
E. strategy
6. A systems development methodology that attempts to balance the focus between process and data by incorporating
both into one model is .
A. bi-methodology
B. data centred
C. multi-focus
D. object oriented
E. process centred
7. The project team must work closely with the , so that the use cases contain the information needed
for the system.
A. document analysts
B. input descriptors
C. managers
D. programmers
E. users
8. Each use case describes how the system reacts to a(n) that occurs to trigger the system.
A. external entity
B. data flow
C. process
D. data store
E. event
9. Outputs from a use case are described on the use case form along with their corresponding .
A. data models
B. destination
C. inputs
D. source
E. viewpoint
10. The steps written in the ‘Major Steps Performed’ section of a use case form are listed in .
A. alphabetical order
B. date stamp order
C. the conditional order
D. the identifying order of the major use case
E. the order in which they are performed
11. All accounts for Self-Storage Lockers are overdue on the last day of the month. When the day field changes
from 30 or 31 to the number 1, a(n) occurs that prints a list of overdue accounts.
A. event driven model
B. external trigger
C. package mailer
D. possible trigger
E. temporal trigger
12. A process model .
A. can only be used to document the current system (i.e., the as-is system)
B. can only be used to document the new system being developed (i.e., the to-be system)
C. cancels out a data model
D. illustrates how data is stored
E. is a formal way of representing how a business system operates
13. The four symbols used when diagramming a DFD are .
A. context, level 0, level 1 and level 2
B. event, trigger, iteration, and join
C. entity, relationship, process, and data flow
D. fragment, diagram, scenario, and visualisation
E. process, data flow, data store, and external entity
14. A(n) is a component of a data flow diagram that represents an activity or a function that is
performed for some specific business reason.
A. action statement
B. data flow
C. data store
D. external entity
E. process
15. A(n) on a data flow diagram represents a person, organisation, or system that is outside the system
but interacts with it.
A. data flow
B. data store
C. external entity
D. process
E. relationship
16. The DFD that shows all of the major high-level processes of the system and how they are related is called a
.
A. process model
B. context diagram
C. level 0 diagram
D. level 1 diagram
E. level 2 diagram
17. An important principle of process modelling is to employ to ensure that all information presented
at one level is accurately represented in the next level.
A. balancing
B. decomposition
C. explosion
D. structuring
E. relationship building
18. A data model illustrates the about which information is captured and how that information is
interrelated.
A. actions, reactions, and relationships
B. analysis process
C. normalisation
D. people, places, and things
E. unified view
19. The best definition of a data entity is .
A. a person, place, or thing about which data is collected.
B. a unique identifier for objects in the system
C. a useful level of detail
D. an association between system objects.
E. some type of information that is captured by the system
20. A(n) is information that is captured about an entity, such as a date of birth or a home address.
A. attribute
B. data flow
C. external
D. process
E. relationship
21. A(n) is an association between entities and is depicted by a line that connects the entities together.
A. attribute
B. data flow
C. external
D. process
E. relationship
22. The cardinality of a relationship communicates .
A. a characteristic that uniquely identifies an entity instance
B. high-level business rules
C. the maximum number of times an entity instance can be passed to a relationship
D. the maximum number of times an entity instance can be related to another entity’s instances
E. the minimum number of time an entity instance can be related to another entity’s instances
23. When the modality of an entity relation is one, the implied business rule is .
A. an instance of one entity is required to have an instance of the related entity
B. the entity relation is valid
C. there are many unique identifiers for an entity
D. there are no unique identifiers for the entity
E. there can be just one entity instance related to another entity instance
24. An intersection (associative) entity .
A. can exist without another related entity
B. is created to store information about two entities that share an M:M relationship
C. is illegal in entity relationship diagramming
D. is represented by a rectangle with rounded corners and a set of parallel lines
E. makes an entity relationship diagram more complex
25. Information in a file’s records that specifies the location of related records is called a .
A. joiner
B. linker
C. marker
D. pointer
E. None of the above
26. A file that stores information on who, when, and how data was altered is a(n) file.
A. audit
B. history
C. look-up
D. master
E. transaction
27. A(n) file stores past transactions that may no longer be needed, is usually stored off-line, and can
be accessed on an as-needed basis.
A. audit
B. history
C. look-up
D. master
E. transaction
28. A(n) database is not machine efficient, but provides an easier development environment than
legacy database systems.
A. hierarchical
B. multidimensional
C. network
D. object
E. relational
29. The process of ensuring that values linking tables together, through the primary and foreign keys, are valid
and correctly synchronised is .
A. hierarchical integrity
B. primary integrity
C. referential integrity
D. referential unity
E. table integrity
30. The most efficient tables in a relational database in terms of storage space have .
A. no redundant data and few null values
B. no redundant data and plenty of null values
C. redundant data and few null values
D. redundant data and plenty of null values
E. repeat customer information
31. A method for improving data access that involves physically arranging the records on the storage medium is
called .
A. clustering
B. denormalisation
C. indexing
D. normalisation
E. volumetrics
32. The helps the analyst design the program for the new system by showing all of the components
of code that must be included in the program at a high level and arranging the code in a hierarchical format.
A. module
B. pseudocode
C. SDLC
D. structure chart
E. structured English
33. In a structure chart, the element that communicates that a message or a system flag is being passed from one
module to another is known as a .
A. conditional line
B. connector
C. control couple
D. data couple
E. loop
34. A module arrangement with high fan-in has .
A. a one-to-one relationship between control modules and subordinate modules
B. a subordinate module that is called by many control modules
C. many subordinate modules associated with a single control module
D. no association between control and subordinate modules
E. compiled a module check list
35. A person, place, event, or thing about which an analyst needs to gather information is called a(n) .
A. object
B. class
C. inheritance
D. message
E. property
36. Similar to a function or a procedure in a traditional programming language, implement(s) the
object’s behaviour.
A. encapsulation
B. polymorphism
C. inheritance
D. messages
E. methods
37. Sunny and Tony are both instances of the student class. Since student class has instances it is considered
a(n) class.
A. abstract
B. concrete
C. doctor
D. encapsulation
E. hierarchy
38. The property by which classes are arranged in a hierarchy and subclasses contain the properties and methods
of their parent superclass is known as .
A. class
B. encapsulation
C. inheritance
D. objects
E. polymorphism
39. The diagram shows the interaction between external users and the system.
A. class
B. collaboration
C. object
D. sequence
E. use case
40. The diagram shows the sequence of states that an object can assume, the events that cause an
object to transition from state to state, and the significant activities and actions that occur as a result.
A. class
B. collaboration
C. object
D. sequence
E. state chart
Section B
1. This question is about entity relationship diagrams.
(a) Describe the THREE elements of an entity relationship diagram. Include in your description the characteristics
of each element and the entity relationship diagram symbol used for each. [4 marks each]
(b) (i) State THREE principles that should be followed to ensure that the entity relationship diagrams
balance with the data flow diagrams. [2 marks each]
(ii) What might be the consequences of failing to balance these models? [3 marks]
(c) Duckworth’s, a department store, has a facility to allow couples to set up a wedding list, detailing the
wedding presents they would like to receive. The system will keep track of the personal details (names,
addresses, wedding date) of couples who have registered a wedding list with Duckworth’s, the products
that the couples have selected to appear on their wedding list, and a complete list of all products that
Duckworth’s sells.
Draw an entity relationship diagram for Duckworth’s, with a brief commentary.
2. This question is about structure charts.
(a) Define the following, and give the structure chart symbol for each:
(i) module;
(ii) library module;
(iii) data couple;
(iv) control couple.
(b) (i) Distinguish between the transaction structure and transform structure arrangements of structure
charts.
(ii) How does each relate to the system’s process model?
(c) The following are all measures of good design. Define each of these measures, and state how the
measure would be used to assess the quality of design:
(i) cohesion;
(ii) coupling;
(iii) appropriate levels of fan-in and fan-out.
(d) Pseudocode and structured English both communicate the logic of programming code. What are their
similarities and what are their differences?
3. This question is about UML.
(a) State THREE benefits of the object approach to systems development.
(b) Identify and define the FOUR core Unified Modelling Language diagramming techniques that now
dominate object-oriented project development. What is the purpose of each technique?
(c) Identify and define THREE elements of a Use Case diagram. Include a picture of the diagramming
symbol.
(d) The sequence diagram is said to be a dynamic model, while the class diagram is said to be a static
model. Explain why the two diagrams are characterised in this way.
them is called a(n) .
A. computer programmer
B. end-user
C. systems analyst
D. systems specialist
E. technical writer
2. The primary goal of the systems analyst is to .
A. acquire a working tool
B. create a wonderful system
C. create value for the organisation
D. establish the three phases of the SDLC
E. purchase a silver bullet
3. The four phases of the Systems Development Life Cycle are .
A. analysis, gathering, modelling, and diagramming
B. construction, installation, testing, and converting
C. designing, charting, formatting, and structuring
D. planning, analysis, design, and implementation
E. system request, feasibility, planning, and staffing
4. Determining who will use the system, what the system will do, and where and when it will be used is
performed during the phase of the SDLC.
A. analysis
B. design
C. implementation
D. modelling
E. planning
5. Deciding how the hardware, software, and network infrastructure will operate occurs during the
phase of the SDLC.
A. analysis
B. design
C. implementation
D. planning
E. strategy
6. A systems development methodology that attempts to balance the focus between process and data by incorporating
both into one model is .
A. bi-methodology
B. data centred
C. multi-focus
D. object oriented
E. process centred
7. The project team must work closely with the , so that the use cases contain the information needed
for the system.
A. document analysts
B. input descriptors
C. managers
D. programmers
E. users
8. Each use case describes how the system reacts to a(n) that occurs to trigger the system.
A. external entity
B. data flow
C. process
D. data store
E. event
9. Outputs from a use case are described on the use case form along with their corresponding .
A. data models
B. destination
C. inputs
D. source
E. viewpoint
10. The steps written in the ‘Major Steps Performed’ section of a use case form are listed in .
A. alphabetical order
B. date stamp order
C. the conditional order
D. the identifying order of the major use case
E. the order in which they are performed
11. All accounts for Self-Storage Lockers are overdue on the last day of the month. When the day field changes
from 30 or 31 to the number 1, a(n) occurs that prints a list of overdue accounts.
A. event driven model
B. external trigger
C. package mailer
D. possible trigger
E. temporal trigger
12. A process model .
A. can only be used to document the current system (i.e., the as-is system)
B. can only be used to document the new system being developed (i.e., the to-be system)
C. cancels out a data model
D. illustrates how data is stored
E. is a formal way of representing how a business system operates
13. The four symbols used when diagramming a DFD are .
A. context, level 0, level 1 and level 2
B. event, trigger, iteration, and join
C. entity, relationship, process, and data flow
D. fragment, diagram, scenario, and visualisation
E. process, data flow, data store, and external entity
14. A(n) is a component of a data flow diagram that represents an activity or a function that is
performed for some specific business reason.
A. action statement
B. data flow
C. data store
D. external entity
E. process
15. A(n) on a data flow diagram represents a person, organisation, or system that is outside the system
but interacts with it.
A. data flow
B. data store
C. external entity
D. process
E. relationship
16. The DFD that shows all of the major high-level processes of the system and how they are related is called a
.
A. process model
B. context diagram
C. level 0 diagram
D. level 1 diagram
E. level 2 diagram
17. An important principle of process modelling is to employ to ensure that all information presented
at one level is accurately represented in the next level.
A. balancing
B. decomposition
C. explosion
D. structuring
E. relationship building
18. A data model illustrates the about which information is captured and how that information is
interrelated.
A. actions, reactions, and relationships
B. analysis process
C. normalisation
D. people, places, and things
E. unified view
19. The best definition of a data entity is .
A. a person, place, or thing about which data is collected.
B. a unique identifier for objects in the system
C. a useful level of detail
D. an association between system objects.
E. some type of information that is captured by the system
20. A(n) is information that is captured about an entity, such as a date of birth or a home address.
A. attribute
B. data flow
C. external
D. process
E. relationship
21. A(n) is an association between entities and is depicted by a line that connects the entities together.
A. attribute
B. data flow
C. external
D. process
E. relationship
22. The cardinality of a relationship communicates .
A. a characteristic that uniquely identifies an entity instance
B. high-level business rules
C. the maximum number of times an entity instance can be passed to a relationship
D. the maximum number of times an entity instance can be related to another entity’s instances
E. the minimum number of time an entity instance can be related to another entity’s instances
23. When the modality of an entity relation is one, the implied business rule is .
A. an instance of one entity is required to have an instance of the related entity
B. the entity relation is valid
C. there are many unique identifiers for an entity
D. there are no unique identifiers for the entity
E. there can be just one entity instance related to another entity instance
24. An intersection (associative) entity .
A. can exist without another related entity
B. is created to store information about two entities that share an M:M relationship
C. is illegal in entity relationship diagramming
D. is represented by a rectangle with rounded corners and a set of parallel lines
E. makes an entity relationship diagram more complex
25. Information in a file’s records that specifies the location of related records is called a .
A. joiner
B. linker
C. marker
D. pointer
E. None of the above
26. A file that stores information on who, when, and how data was altered is a(n) file.
A. audit
B. history
C. look-up
D. master
E. transaction
27. A(n) file stores past transactions that may no longer be needed, is usually stored off-line, and can
be accessed on an as-needed basis.
A. audit
B. history
C. look-up
D. master
E. transaction
28. A(n) database is not machine efficient, but provides an easier development environment than
legacy database systems.
A. hierarchical
B. multidimensional
C. network
D. object
E. relational
29. The process of ensuring that values linking tables together, through the primary and foreign keys, are valid
and correctly synchronised is .
A. hierarchical integrity
B. primary integrity
C. referential integrity
D. referential unity
E. table integrity
30. The most efficient tables in a relational database in terms of storage space have .
A. no redundant data and few null values
B. no redundant data and plenty of null values
C. redundant data and few null values
D. redundant data and plenty of null values
E. repeat customer information
31. A method for improving data access that involves physically arranging the records on the storage medium is
called .
A. clustering
B. denormalisation
C. indexing
D. normalisation
E. volumetrics
32. The helps the analyst design the program for the new system by showing all of the components
of code that must be included in the program at a high level and arranging the code in a hierarchical format.
A. module
B. pseudocode
C. SDLC
D. structure chart
E. structured English
33. In a structure chart, the element that communicates that a message or a system flag is being passed from one
module to another is known as a .
A. conditional line
B. connector
C. control couple
D. data couple
E. loop
34. A module arrangement with high fan-in has .
A. a one-to-one relationship between control modules and subordinate modules
B. a subordinate module that is called by many control modules
C. many subordinate modules associated with a single control module
D. no association between control and subordinate modules
E. compiled a module check list
35. A person, place, event, or thing about which an analyst needs to gather information is called a(n) .
A. object
B. class
C. inheritance
D. message
E. property
36. Similar to a function or a procedure in a traditional programming language, implement(s) the
object’s behaviour.
A. encapsulation
B. polymorphism
C. inheritance
D. messages
E. methods
37. Sunny and Tony are both instances of the student class. Since student class has instances it is considered
a(n) class.
A. abstract
B. concrete
C. doctor
D. encapsulation
E. hierarchy
38. The property by which classes are arranged in a hierarchy and subclasses contain the properties and methods
of their parent superclass is known as .
A. class
B. encapsulation
C. inheritance
D. objects
E. polymorphism
39. The diagram shows the interaction between external users and the system.
A. class
B. collaboration
C. object
D. sequence
E. use case
40. The diagram shows the sequence of states that an object can assume, the events that cause an
object to transition from state to state, and the significant activities and actions that occur as a result.
A. class
B. collaboration
C. object
D. sequence
E. state chart
Section B
1. This question is about entity relationship diagrams.
(a) Describe the THREE elements of an entity relationship diagram. Include in your description the characteristics
of each element and the entity relationship diagram symbol used for each. [4 marks each]
(b) (i) State THREE principles that should be followed to ensure that the entity relationship diagrams
balance with the data flow diagrams. [2 marks each]
(ii) What might be the consequences of failing to balance these models? [3 marks]
(c) Duckworth’s, a department store, has a facility to allow couples to set up a wedding list, detailing the
wedding presents they would like to receive. The system will keep track of the personal details (names,
addresses, wedding date) of couples who have registered a wedding list with Duckworth’s, the products
that the couples have selected to appear on their wedding list, and a complete list of all products that
Duckworth’s sells.
Draw an entity relationship diagram for Duckworth’s, with a brief commentary.
2. This question is about structure charts.
(a) Define the following, and give the structure chart symbol for each:
(i) module;
(ii) library module;
(iii) data couple;
(iv) control couple.
(b) (i) Distinguish between the transaction structure and transform structure arrangements of structure
charts.
(ii) How does each relate to the system’s process model?
(c) The following are all measures of good design. Define each of these measures, and state how the
measure would be used to assess the quality of design:
(i) cohesion;
(ii) coupling;
(iii) appropriate levels of fan-in and fan-out.
(d) Pseudocode and structured English both communicate the logic of programming code. What are their
similarities and what are their differences?
3. This question is about UML.
(a) State THREE benefits of the object approach to systems development.
(b) Identify and define the FOUR core Unified Modelling Language diagramming techniques that now
dominate object-oriented project development. What is the purpose of each technique?
(c) Identify and define THREE elements of a Use Case diagram. Include a picture of the diagramming
symbol.
(d) The sequence diagram is said to be a dynamic model, while the class diagram is said to be a static
model. Explain why the two diagrams are characterised in this way.
Systems Analysis and Design Exercise 03
1. The systems development life cycle (SDLC) is the process of _____.
A. building an information system
B. delivering an information system to a client
C. designing an information system
D. understanding how an information system can support business needs
E. all of the above
2. In which phase of the SDLC is the system proposal developed?
A. analysis
B. design
C. implementation
D. planning
E. system delivery
3. The systems development methodology that emphasizes simple, iterative,
application development that provides rapid feedback to users on an ongoing
basis, with continuous development and testing is ________.
A. modular development
B. rapid application development
C. prototyping
D. agile development
E. throwaway prototyping
4. The primary advantage of the Waterfall Development methodology is that _____.
A. a version of the system is quickly delivered into the users' hands
B. requirements evolve through users' feedback about the system
C. features and functionality of the system are explored through simple models
D. requirements are completely specified and held relatively constant prior to
programming
E. there is a long time lapse prior to completion
5. The principal disadvantage(s) with the waterfall development methodology is
(are) _____.
A. a long time elapses between completion of the system proposal and the
delivery of the system
B. it identifies system requirements long before programming begins
C. it minimizes changes to the requirements as the project proceeds
D. the design must be completely specified on paper before programming begins
E. a long time elapses between completion of the system proposal and the
delivery of the system and the design must be completely specified (usually on
paper) before programming begins
6. The analysis phase of the SDLC answers _____.
A. who will create the system and when will it be used
B. who will the system be for, what the system will do, when will it be used, and
where will it be used
C. why build the system, what the system will be, and how the system will work
D. why build the system, who will the system be for, when will it be used, and
how the system will work
E. why build the system, who will the system be for, when will it be used, and
where will it be used
7. If the system under development will employ technology with which the analysts
and programmers are unfamiliar, the most appropriate methodology to employ is:
A. Waterfall Development
B. Throw-Away Prototyping
C. Parallel Development
D. Phased Development
E. Prototyping
8. The _____ development methodology is never recommended when system
reliability is very critical.
A. parallel
B. phased
C. prototyping
D. throwaway prototyping
E. waterfall
9. Which of the following systems development methodologies involves developing
the system in a series of sequential versions?
A. Parallel Development
B. Phased Development
C. Prototyping
D. Throw-Away Prototyping
E. Waterfall Development
10. _____ development is a structured design methodology that divides the project
into a series of distinct subprojects that can be designed and implemented
together.
A. Parallel
B. Phased
C. Prototyping
D. Rapid Application
E. Throwaway Prototyping
11. The _____ is generated by the department or person that has an idea for a new
information system.
A. feasibility analysis
B. gradual refinement
C. project sponsor
D. system request
E. work plan
12. The information gathering technique that is most effective in combining
information from a variety of perspectives, building consensus, and resolving
discrepancies is ________
A. interviews.
B. JAD (Joint Application Design) sessions.
C. questionnaires.
D. document analysis.
E. observation.
13. In a JAD (Joint Application Design) Session, which of the following is NOT a
proper role for the facilitator?
A. Assist the group in understanding the analysis techniques.
B. Document group output on a public display.
C. Ensure that the JAD session agenda is followed.
D. Cast the deciding vote on controversial issues.
E. Guide the discussion.
14. During document analysis the systems analyst learns that users in the purchasing
department have created their own forms. This is a clear sign that the _____.
A. as-is system is meeting user needs
B. department was overlooked during the interview process
C. process does not need improvements
D. system needs to be changed
E. users in the department are innovative
15. During an interview, the following question is asked; "How many times during a
typical week does a customer complain about inadequate service following a
sale?" This question is an example of a(n) _____________
A. probing question.
B. open-ended question.
C. closed-ended question.
D. inappropriate question.
E. opinion question.
16. A systems analyst has prepared an interview that begins with specific, detailed
questions, and then asks the interviewee to make general statements about policies
and procedure of the business process. This is a(n) _____ interview structure.
A. bottom up
B. closed
C. open ended
D. probing
E. top down
17. The examination of existing paperwork in order to better understand the as-is
system is an example of what information-gathering strategy?
A. document analysis
B. interviewing
C. joint application design (JAD) sessions
D. observation
E. questionnaires
18. The information gathering technique that enables the analyst to collect facts and
opinions from a wide range of geographically dispersed people quickly and with
the least expense is the _____.
A. document analysis
B. interview
C. JAD session
D. observation
E. questionnaire
19. The systems development methodology(methodologies) that is(are) most effective
when the user requirements are particularly unclear is(are) _______.
A. waterfall development
B. parallel development
C. phased development
D. prototyping
E. prototyping and throwaway prototyping
20. Which of the following development strategies is preferred when the business
need is common and time is a limiting factor?
A. in-house, custom development
B. purchased software
C. end-user development
D. outsourcing
E. None of the above
21. The foundation of the Unified Modelling Language is the _____________
A. use case.
B. object.
C. activity diagram.
D. message.
E. method.
22. The Unified Modeling Language diagramming technique that illustrates the
objects and messages involved in a use case is the _____________
A. use case diagram.
B. sequence diagram.
C. class diagram.
D. statechart diagram.
E. None of the above
23. Each use case describes how the system reacts to a(n) _____ that occurs to trigger
the system.
A. activity
B. event
C. model
D. session
E. transition
24. Which of the following is often left out by end users when identifying elements
within Use Case steps?
A. analytical analysis of the identity elements
B. JAD session classification
C. requirements definition
D. role play analysis
E. rarely-used activities or special cases
25. When developing use cases, the project team first identifies the _______.
A. managers that supervise the use case department
B. place where the use case occurs
C. time the use case begins
D. trigger that causes the use case to occur
E. users who perform the use case
26. Validating that the use case is correct and complete is the major activity
performed during which step of the Writing Use Case Reports process?
A. identify elements within steps
B. identify the major steps within each use case
C. identify the use cases
D. confirm the use cases
E. write the use case report
27. Which of the following diagramming symbols represents a generalization
relationship in a use case diagram?
A.
B.
C.
D.
E.
28. Which of the following relationships represent an enhancement of the
functionality of the use case to cover optional behaviour?
A. association relationship
B. extend relationship
C. include relationship
D. generalization relationship
E. optional relationship
29. Buying in packaged software as a design strategy is good if _____.
A. in-house functional and technical experience exists
B. the business need is common
C. there is a desire to build in-house skills
D. the timeframe is flexible
E. the business need is core to the business
30. A custom development design strategy is NOT good for _____.
A. building technical skills
B. creating functional knowledge in-house
C. improving creativity
D. increasing flexibility
E. lowering risk
31. A disadvantage of outsourcing the application development process is that the
organization may ______.
A. build technical skills and functional knowledge in-house
B. lose control over confidential information
C. accept functionality that is far from a perfect fit
D. remove all risk from the project
E. make strategic changes during implementation
32. Manipulating certain parameters to refine the way features work in a software
package is called ______.
A. a workaround
B. adjustment
C. customization
D. feature adjustability
E. parameterizing
33. An advantage of purchasing packaged software is that the organization may
______.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. have developers climb the knowledge ladder
D. make strategic changes during implementation
E. save money on the purchase
34. “A-part-of” or “has-parts” relationship represents a(n) ______ relationship.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
35. “A-kind-of” relationship represents a(n) ______ relationship.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
36. Which of the following would not be an appropriate class name?
A. student
B. patient
C. James
D. customer
E. doctor
37. A(n) _____ describes information about an object.
A. attribute
B. behaviour
C. operation
D. message
E. instance
38. Which of the following is NOT one of the four basic functions of a computer
application?
A. application logic
B. data access logic
C. data storage
D. networking logic
E. presentation logic
39. Assume that your network has a server and three clients, the network is an
example of a(n) _____.
A. 4-tiered architecture
B. single-tiered architecture
C. three-tiered architecture
D. tierless architecture
E. two-tiered architecture
40. A server in a typical client-server based system performs which of the following
application functions?
A. application logic
B. data access logic and presentation logic
C. data storage and data access logic
D. data storage and presentation logic
E. presentation logic and application logic
41. What is one primary problem with server-based computing architectures?
A. Servers are no longer made by hardware vendors.
B. Client terminals are no longer made by hardware vendors.
C. As users place heavier demands on the server, it is costly to increase server
capacity.
D. It is difficult to maintain security in the server-based environment.
E. Servers are difficult to connect to client terminals.
42. Which of the following is NOT one of the fundamental computing architectures?
A. Client-based computing
B. System-based computing
C. Server-based computing
D. Client-server based computing
43. An analyst depicts the static view of an information system with ______.
A. use-case models
B. structural models
C. behavioural models
D. interaction diagrams
E. statechart diagrams
44. On a sequence diagram, an object name of aStudent:List would indicate that
_____.
A. aStudent is an instance of the List class that contains individual student objects
B. List is an instance of the Student class
C. List is a method of the Student class
D. the Student and List objects are combined for that step in the sequence
diagram
E. a message is being passed from the Student class to the List class
45. In a sequence diagram, an analyst draws a lifeline with an X at the end. This
lifeline represents _____.
A. a message that cannot be delivered
B. an object that is destroyed at a point in time
C. a message that is delivered at a point in time
D. an object that is complete at a point in time
E. an object that arrives at its final destination
46. The UML diagramming technique that shows the different state that a single
object passes through in reponse to events is a(n) _____ diagram.
A. class
B. sequence
C. behavioural state machine
D. use case
E. component
47. In a sequence diagram, an analyst draws a long box shape on top of a lifeline. This
box represents _____.
A. the time in which the object is exchanging messages
B. the time in which the object does not exist
C. a transition from one state to another
D. the encapsulation of the object
E. the time in which the object exists
48. The order of messages on a sequence diagram goes from ________ .
A. right to left
B. bottom to top
C. left to right
D. top to bottom
E. left to right, top to bottom
49. The process of building new systems by combining packaged software, existing
legacy systems, and new software written to integrate everything together is called
______.
A. customization
B. formal methodology
C. outsourcing
D. systems integration
E. workaround
50. Which of the following is not a fundamental way to approach the creation of a
new information system?
A. develop a custom application in-house
B. rely on an external vendor to build the system
C. purchase a software package and customize it
D. rely on end-users to develop it themselves
E. all of the above are ways to create new information systems
51. An advantage of custom development is that the organization can _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. install in a short period of time
D. remove all risk from the project
E. save money on the purchase
52. A(n) _____ file stores past transactions that may no longer be needed, is usually
stored off-line, and can be accessed on an as-needed basis.
A. audit
B. history
C. look-up
D. master
E. transaction
53. The process of adding redundancy back into a physical data model is known as
_____.
A. balancing
B. clustering
C. denormalization
D. indexing
E. normalization
54. The most efficient tables in a relational database in terms of storage space have
_____.
A. no redundant data and few null values
B. no redundant data and plenty of null values
C. redundant data and few null values
D. redundant data and plenty of null values
E. repeat customer information
55. ______ is the general template used to define and create specific instances or
objects.
A. a class
B. inheritance
C. a message
D. polymorphism
E. a method
56. ______ is essentially a function or procedure call from one object to another, and
is the information sent to objects to trigger methods.
A. encapsulation
B. information hiding
C. inheritance
D. a message
E. polymorphism
57. The most common threat to a computer system is posed by _________.
A. internal hackers.
B. industrial espionage.
C. device failure.
D. viruses.
E. natural disasters.
58. When all files are regularly tested for worms, bugs, and illicit programs; this is an
example of _____ requirements.
A. access control
B. encryption and authentication
C. portability
D. technical environment
E. virus control
59. A file that stores information on who, when, and how data was altered is a(n)
______ file.
A. audit
B. history
C. look-up
D. master
E. transaction
60. The normalization process is performed primarily to increase the database's
___________
A. storage efficiency.
B. indexing scheme.
C. access speed.
D. multiple dimensions.
E. none of the above.
61. The ability of the same message to be interpreted differently by different classes
of objects is referred to as _____________
A. encapsulation.
B. polymorphism.
C. inheritance.
D. association.
E. None of the above.
62. When the analyst is evaluating a data model to ensure that all fields in a record
depend fully on the entire primary key, which step of normalization is being
performed?
A. Base normal form
B. First normal form
C. Second normal form
D. Third normal form
E. Cannot tell from the above information.
63. If the logical data model contains fields that depend on another non-primary key
field, then it is in violation of the rules of _____.
A. base normal form
B. first normal form
C. non-normal form
D. second normal form
E. third normal form
64. The process of ensuring that values linking tables together through the primary
and foreign keys are valid and correctly synchronized is _____.
A. hierarchical integrity
B. primary integrity
C. table integrity
D. referential unity
E. referential integrity
65. In order to reduce the number of joins that must be performed in a query and to
increase the speed of data access, the data analyst can _____ the physical model.
A. cluster
B. denormalize
C. index
D. normalize
E. optimize
66. The first step in the Design Phase is to _____.
A. convert logical process and data models to physical
B. create the deliverable
C. design the architecture
D. design the inputs and outputs
E. present design alternatives
67. The plan for the creation of the hardware and software infrastructure is commonly
called _____.
A. architecture design
B. hardware specifications
C. software specifications
D. network model
E. presentation logic
68. The number of errors found is likely to be highest in the _____ stage of testing.
A. unit test
B. integration test
C. system test
D. acceptance test (alpha)
E. acceptance test (beta)
69. _____ is the development of all parts of the new system including the software,
documentation, and new operating procedures.
A. Construction
B. Design
C. Documentation
D. Management
E. Testing
70. Training for a business system should focus on _____.
A. all the capabilities of the new system
B. complex computerized modules and code
C. helping the users to accomplish their jobs
D. how to use the system
E. not using the system
SECTION B - Answer ONE question from this section. You should
answer this section in the answerbook provided.
1. This question is about Unified Modeling Language (UML) Functional Models
(a) Consider the scenario below relating to an Appointment System in a Health
Centre.
.
The Figure above is an overview Use Case Diagram relating to the scenario described
above.
i) What is the purpose of such an OVERVIEW Use Case Diagram?
ii) What term is used to refer to the Doctor, Patient and Management in this
kind of diagram? Why is this term particularly appropriate here?
In the health centre, the management need to produce
scheduling information. There are several doctors, and
they store and update their availability for appointments
with patients on the system. When a patient feels unwell,
he/she makes an appointment at the health centre.
Appointment System
Management
Doctor
Patient
Make
appointment
Produce schedule
information
Record
availability
(b) Consider the following scenario:
Using the original diagram and scenario in Q1(a) as a guide, draw a
DETAILED Use Case Diagram for the Appointment System, including all the
new detailed features described in the above scenario. Explain your reasoning
clearly.
(c) Show how you would modify the diagram in your answer to Q1(b) to
incorporate different kinds of doctor, for example, general practitioners and
specialists?
New patients can enroll with the health centre; when they
do, a new patient record is created. Existing patients
sometimes provide updates to their personal information
when they visit the health centre. All kinds of patient
have the option to change the payment method when they make
an appointment. The doctors and the health centre manager
always need to manage schedules in the centre - the
doctors, when they record their availability, and the
manager, when producing schedule information.
2. This question is about Requirements Gathering (Requirements Determination).
(a) A Joint Application Design (JAD) session is one of the five main informationgathering
techniques in the analysis phase of the Systems Development Life Cycle.
Explain the meaning of the following FIVE terms, as used in a JAD session: scribe,
facilitator, agenda merry-go-round, side discussions, violent agreement.
(b) Interviews are also commonly used for system requirements gathering in the analysis
phase. List the FIVE steps involved in the use of interviews, providing a short
explanation of each step.
(c) List the other THREE main information-gathering techniques used in the analysis
phase.
(d) Of all five requirements gathering methods, which TWO provide the greatest amount
of detail (greatest depth)? Explain the reasoning involved in your answer.
(e) In your opinion, which of the five requirements gathering methods is/are the most
costly? Explain your reasoning.
A. building an information system
B. delivering an information system to a client
C. designing an information system
D. understanding how an information system can support business needs
E. all of the above
2. In which phase of the SDLC is the system proposal developed?
A. analysis
B. design
C. implementation
D. planning
E. system delivery
3. The systems development methodology that emphasizes simple, iterative,
application development that provides rapid feedback to users on an ongoing
basis, with continuous development and testing is ________.
A. modular development
B. rapid application development
C. prototyping
D. agile development
E. throwaway prototyping
4. The primary advantage of the Waterfall Development methodology is that _____.
A. a version of the system is quickly delivered into the users' hands
B. requirements evolve through users' feedback about the system
C. features and functionality of the system are explored through simple models
D. requirements are completely specified and held relatively constant prior to
programming
E. there is a long time lapse prior to completion
5. The principal disadvantage(s) with the waterfall development methodology is
(are) _____.
A. a long time elapses between completion of the system proposal and the
delivery of the system
B. it identifies system requirements long before programming begins
C. it minimizes changes to the requirements as the project proceeds
D. the design must be completely specified on paper before programming begins
E. a long time elapses between completion of the system proposal and the
delivery of the system and the design must be completely specified (usually on
paper) before programming begins
6. The analysis phase of the SDLC answers _____.
A. who will create the system and when will it be used
B. who will the system be for, what the system will do, when will it be used, and
where will it be used
C. why build the system, what the system will be, and how the system will work
D. why build the system, who will the system be for, when will it be used, and
how the system will work
E. why build the system, who will the system be for, when will it be used, and
where will it be used
7. If the system under development will employ technology with which the analysts
and programmers are unfamiliar, the most appropriate methodology to employ is:
A. Waterfall Development
B. Throw-Away Prototyping
C. Parallel Development
D. Phased Development
E. Prototyping
8. The _____ development methodology is never recommended when system
reliability is very critical.
A. parallel
B. phased
C. prototyping
D. throwaway prototyping
E. waterfall
9. Which of the following systems development methodologies involves developing
the system in a series of sequential versions?
A. Parallel Development
B. Phased Development
C. Prototyping
D. Throw-Away Prototyping
E. Waterfall Development
10. _____ development is a structured design methodology that divides the project
into a series of distinct subprojects that can be designed and implemented
together.
A. Parallel
B. Phased
C. Prototyping
D. Rapid Application
E. Throwaway Prototyping
11. The _____ is generated by the department or person that has an idea for a new
information system.
A. feasibility analysis
B. gradual refinement
C. project sponsor
D. system request
E. work plan
12. The information gathering technique that is most effective in combining
information from a variety of perspectives, building consensus, and resolving
discrepancies is ________
A. interviews.
B. JAD (Joint Application Design) sessions.
C. questionnaires.
D. document analysis.
E. observation.
13. In a JAD (Joint Application Design) Session, which of the following is NOT a
proper role for the facilitator?
A. Assist the group in understanding the analysis techniques.
B. Document group output on a public display.
C. Ensure that the JAD session agenda is followed.
D. Cast the deciding vote on controversial issues.
E. Guide the discussion.
14. During document analysis the systems analyst learns that users in the purchasing
department have created their own forms. This is a clear sign that the _____.
A. as-is system is meeting user needs
B. department was overlooked during the interview process
C. process does not need improvements
D. system needs to be changed
E. users in the department are innovative
15. During an interview, the following question is asked; "How many times during a
typical week does a customer complain about inadequate service following a
sale?" This question is an example of a(n) _____________
A. probing question.
B. open-ended question.
C. closed-ended question.
D. inappropriate question.
E. opinion question.
16. A systems analyst has prepared an interview that begins with specific, detailed
questions, and then asks the interviewee to make general statements about policies
and procedure of the business process. This is a(n) _____ interview structure.
A. bottom up
B. closed
C. open ended
D. probing
E. top down
17. The examination of existing paperwork in order to better understand the as-is
system is an example of what information-gathering strategy?
A. document analysis
B. interviewing
C. joint application design (JAD) sessions
D. observation
E. questionnaires
18. The information gathering technique that enables the analyst to collect facts and
opinions from a wide range of geographically dispersed people quickly and with
the least expense is the _____.
A. document analysis
B. interview
C. JAD session
D. observation
E. questionnaire
19. The systems development methodology(methodologies) that is(are) most effective
when the user requirements are particularly unclear is(are) _______.
A. waterfall development
B. parallel development
C. phased development
D. prototyping
E. prototyping and throwaway prototyping
20. Which of the following development strategies is preferred when the business
need is common and time is a limiting factor?
A. in-house, custom development
B. purchased software
C. end-user development
D. outsourcing
E. None of the above
21. The foundation of the Unified Modelling Language is the _____________
A. use case.
B. object.
C. activity diagram.
D. message.
E. method.
22. The Unified Modeling Language diagramming technique that illustrates the
objects and messages involved in a use case is the _____________
A. use case diagram.
B. sequence diagram.
C. class diagram.
D. statechart diagram.
E. None of the above
23. Each use case describes how the system reacts to a(n) _____ that occurs to trigger
the system.
A. activity
B. event
C. model
D. session
E. transition
24. Which of the following is often left out by end users when identifying elements
within Use Case steps?
A. analytical analysis of the identity elements
B. JAD session classification
C. requirements definition
D. role play analysis
E. rarely-used activities or special cases
25. When developing use cases, the project team first identifies the _______.
A. managers that supervise the use case department
B. place where the use case occurs
C. time the use case begins
D. trigger that causes the use case to occur
E. users who perform the use case
26. Validating that the use case is correct and complete is the major activity
performed during which step of the Writing Use Case Reports process?
A. identify elements within steps
B. identify the major steps within each use case
C. identify the use cases
D. confirm the use cases
E. write the use case report
27. Which of the following diagramming symbols represents a generalization
relationship in a use case diagram?
A.
B.
C.
D.
E.
28. Which of the following relationships represent an enhancement of the
functionality of the use case to cover optional behaviour?
A. association relationship
B. extend relationship
C. include relationship
D. generalization relationship
E. optional relationship
29. Buying in packaged software as a design strategy is good if _____.
A. in-house functional and technical experience exists
B. the business need is common
C. there is a desire to build in-house skills
D. the timeframe is flexible
E. the business need is core to the business
30. A custom development design strategy is NOT good for _____.
A. building technical skills
B. creating functional knowledge in-house
C. improving creativity
D. increasing flexibility
E. lowering risk
31. A disadvantage of outsourcing the application development process is that the
organization may ______.
A. build technical skills and functional knowledge in-house
B. lose control over confidential information
C. accept functionality that is far from a perfect fit
D. remove all risk from the project
E. make strategic changes during implementation
32. Manipulating certain parameters to refine the way features work in a software
package is called ______.
A. a workaround
B. adjustment
C. customization
D. feature adjustability
E. parameterizing
33. An advantage of purchasing packaged software is that the organization may
______.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. have developers climb the knowledge ladder
D. make strategic changes during implementation
E. save money on the purchase
34. “A-part-of” or “has-parts” relationship represents a(n) ______ relationship.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
35. “A-kind-of” relationship represents a(n) ______ relationship.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
36. Which of the following would not be an appropriate class name?
A. student
B. patient
C. James
D. customer
E. doctor
37. A(n) _____ describes information about an object.
A. attribute
B. behaviour
C. operation
D. message
E. instance
38. Which of the following is NOT one of the four basic functions of a computer
application?
A. application logic
B. data access logic
C. data storage
D. networking logic
E. presentation logic
39. Assume that your network has a server and three clients, the network is an
example of a(n) _____.
A. 4-tiered architecture
B. single-tiered architecture
C. three-tiered architecture
D. tierless architecture
E. two-tiered architecture
40. A server in a typical client-server based system performs which of the following
application functions?
A. application logic
B. data access logic and presentation logic
C. data storage and data access logic
D. data storage and presentation logic
E. presentation logic and application logic
41. What is one primary problem with server-based computing architectures?
A. Servers are no longer made by hardware vendors.
B. Client terminals are no longer made by hardware vendors.
C. As users place heavier demands on the server, it is costly to increase server
capacity.
D. It is difficult to maintain security in the server-based environment.
E. Servers are difficult to connect to client terminals.
42. Which of the following is NOT one of the fundamental computing architectures?
A. Client-based computing
B. System-based computing
C. Server-based computing
D. Client-server based computing
43. An analyst depicts the static view of an information system with ______.
A. use-case models
B. structural models
C. behavioural models
D. interaction diagrams
E. statechart diagrams
44. On a sequence diagram, an object name of aStudent:List would indicate that
_____.
A. aStudent is an instance of the List class that contains individual student objects
B. List is an instance of the Student class
C. List is a method of the Student class
D. the Student and List objects are combined for that step in the sequence
diagram
E. a message is being passed from the Student class to the List class
45. In a sequence diagram, an analyst draws a lifeline with an X at the end. This
lifeline represents _____.
A. a message that cannot be delivered
B. an object that is destroyed at a point in time
C. a message that is delivered at a point in time
D. an object that is complete at a point in time
E. an object that arrives at its final destination
46. The UML diagramming technique that shows the different state that a single
object passes through in reponse to events is a(n) _____ diagram.
A. class
B. sequence
C. behavioural state machine
D. use case
E. component
47. In a sequence diagram, an analyst draws a long box shape on top of a lifeline. This
box represents _____.
A. the time in which the object is exchanging messages
B. the time in which the object does not exist
C. a transition from one state to another
D. the encapsulation of the object
E. the time in which the object exists
48. The order of messages on a sequence diagram goes from ________ .
A. right to left
B. bottom to top
C. left to right
D. top to bottom
E. left to right, top to bottom
49. The process of building new systems by combining packaged software, existing
legacy systems, and new software written to integrate everything together is called
______.
A. customization
B. formal methodology
C. outsourcing
D. systems integration
E. workaround
50. Which of the following is not a fundamental way to approach the creation of a
new information system?
A. develop a custom application in-house
B. rely on an external vendor to build the system
C. purchase a software package and customize it
D. rely on end-users to develop it themselves
E. all of the above are ways to create new information systems
51. An advantage of custom development is that the organization can _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. install in a short period of time
D. remove all risk from the project
E. save money on the purchase
52. A(n) _____ file stores past transactions that may no longer be needed, is usually
stored off-line, and can be accessed on an as-needed basis.
A. audit
B. history
C. look-up
D. master
E. transaction
53. The process of adding redundancy back into a physical data model is known as
_____.
A. balancing
B. clustering
C. denormalization
D. indexing
E. normalization
54. The most efficient tables in a relational database in terms of storage space have
_____.
A. no redundant data and few null values
B. no redundant data and plenty of null values
C. redundant data and few null values
D. redundant data and plenty of null values
E. repeat customer information
55. ______ is the general template used to define and create specific instances or
objects.
A. a class
B. inheritance
C. a message
D. polymorphism
E. a method
56. ______ is essentially a function or procedure call from one object to another, and
is the information sent to objects to trigger methods.
A. encapsulation
B. information hiding
C. inheritance
D. a message
E. polymorphism
57. The most common threat to a computer system is posed by _________.
A. internal hackers.
B. industrial espionage.
C. device failure.
D. viruses.
E. natural disasters.
58. When all files are regularly tested for worms, bugs, and illicit programs; this is an
example of _____ requirements.
A. access control
B. encryption and authentication
C. portability
D. technical environment
E. virus control
59. A file that stores information on who, when, and how data was altered is a(n)
______ file.
A. audit
B. history
C. look-up
D. master
E. transaction
60. The normalization process is performed primarily to increase the database's
___________
A. storage efficiency.
B. indexing scheme.
C. access speed.
D. multiple dimensions.
E. none of the above.
61. The ability of the same message to be interpreted differently by different classes
of objects is referred to as _____________
A. encapsulation.
B. polymorphism.
C. inheritance.
D. association.
E. None of the above.
62. When the analyst is evaluating a data model to ensure that all fields in a record
depend fully on the entire primary key, which step of normalization is being
performed?
A. Base normal form
B. First normal form
C. Second normal form
D. Third normal form
E. Cannot tell from the above information.
63. If the logical data model contains fields that depend on another non-primary key
field, then it is in violation of the rules of _____.
A. base normal form
B. first normal form
C. non-normal form
D. second normal form
E. third normal form
64. The process of ensuring that values linking tables together through the primary
and foreign keys are valid and correctly synchronized is _____.
A. hierarchical integrity
B. primary integrity
C. table integrity
D. referential unity
E. referential integrity
65. In order to reduce the number of joins that must be performed in a query and to
increase the speed of data access, the data analyst can _____ the physical model.
A. cluster
B. denormalize
C. index
D. normalize
E. optimize
66. The first step in the Design Phase is to _____.
A. convert logical process and data models to physical
B. create the deliverable
C. design the architecture
D. design the inputs and outputs
E. present design alternatives
67. The plan for the creation of the hardware and software infrastructure is commonly
called _____.
A. architecture design
B. hardware specifications
C. software specifications
D. network model
E. presentation logic
68. The number of errors found is likely to be highest in the _____ stage of testing.
A. unit test
B. integration test
C. system test
D. acceptance test (alpha)
E. acceptance test (beta)
69. _____ is the development of all parts of the new system including the software,
documentation, and new operating procedures.
A. Construction
B. Design
C. Documentation
D. Management
E. Testing
70. Training for a business system should focus on _____.
A. all the capabilities of the new system
B. complex computerized modules and code
C. helping the users to accomplish their jobs
D. how to use the system
E. not using the system
SECTION B - Answer ONE question from this section. You should
answer this section in the answerbook provided.
1. This question is about Unified Modeling Language (UML) Functional Models
(a) Consider the scenario below relating to an Appointment System in a Health
Centre.
.
The Figure above is an overview Use Case Diagram relating to the scenario described
above.
i) What is the purpose of such an OVERVIEW Use Case Diagram?
ii) What term is used to refer to the Doctor, Patient and Management in this
kind of diagram? Why is this term particularly appropriate here?
In the health centre, the management need to produce
scheduling information. There are several doctors, and
they store and update their availability for appointments
with patients on the system. When a patient feels unwell,
he/she makes an appointment at the health centre.
Appointment System
Management
Doctor
Patient
Make
appointment
Produce schedule
information
Record
availability
(b) Consider the following scenario:
Using the original diagram and scenario in Q1(a) as a guide, draw a
DETAILED Use Case Diagram for the Appointment System, including all the
new detailed features described in the above scenario. Explain your reasoning
clearly.
(c) Show how you would modify the diagram in your answer to Q1(b) to
incorporate different kinds of doctor, for example, general practitioners and
specialists?
New patients can enroll with the health centre; when they
do, a new patient record is created. Existing patients
sometimes provide updates to their personal information
when they visit the health centre. All kinds of patient
have the option to change the payment method when they make
an appointment. The doctors and the health centre manager
always need to manage schedules in the centre - the
doctors, when they record their availability, and the
manager, when producing schedule information.
2. This question is about Requirements Gathering (Requirements Determination).
(a) A Joint Application Design (JAD) session is one of the five main informationgathering
techniques in the analysis phase of the Systems Development Life Cycle.
Explain the meaning of the following FIVE terms, as used in a JAD session: scribe,
facilitator, agenda merry-go-round, side discussions, violent agreement.
(b) Interviews are also commonly used for system requirements gathering in the analysis
phase. List the FIVE steps involved in the use of interviews, providing a short
explanation of each step.
(c) List the other THREE main information-gathering techniques used in the analysis
phase.
(d) Of all five requirements gathering methods, which TWO provide the greatest amount
of detail (greatest depth)? Explain the reasoning involved in your answer.
(e) In your opinion, which of the five requirements gathering methods is/are the most
costly? Explain your reasoning.
Systems Analysis and Design Exercise 02
1. The person that identifies opportunities for improvements and designs an information
system to implement them is called a(n) _____.
A. computer programmer
B. end-user
C. systems analyst
D. systems specialist
E. technical writer
2. The four phases of the Systems Development Life Cycle are _____.
A. analysis, gathering, modeling, and diagramming
B. construction, installation, testing, and converting
C. designing, charting, formatting, and structuring
D. planning, analysis, design, and implementation
E. system request, feasibility, planning, and staffing
3. The project sponsor is the _____.
A. lead systems analyst on the project team
B. person or department that requested the system
C. computer programmer who writes the code for the system
D. project team leader in charge of developing the system
E. any of the above may fill the role of the project sponsor
4. Deciding how the hardware, software, and network infrastructure will operate occurs
during the _____ phase of the SDLC.
A. analysis
B. design
C. implementation
D. planning
E. strategy
5. The phase of the SDLC when the system is actually built or purchased is the _____ phase.
A. analysis
B. construction
C. design
D. implementation
E. planning
6. _____ development is a structured design methodology that proceeds in a sequence from
one phase to the next.
A. Parallel
B. Phased
C. Prototyping
D. Rapid Application
E. Waterfall
7. The idea of placing data and the processes (methods) that operate on the data into the
same object is referred to as __________________.
A. Information Hiding
B. Polymorphism
C. Object Binding
D. Encapsulation
E. Inheritance
8. A(n) ___________ models the interaction of the information system with its end-users
and other external systems.
A. Implementation plan
B. Use case diagram
C. Class diagram
D. Package diagram
E. Database diagram
9. _________ represent the things, concepts or ideas that are contained in an application.
A. Interaction diagrams
B. Deployment diagrams
C. Sequence diagrams
D. Class diagrams
E. Use Case diagrams
10. Understanding the as-is system, identifying improvements, and developing requirements
for the to-be system are the steps of the _____ phase.
A. analysis
B. design
C. implementation
D. planning
E. SDLC
11. Sarah would like to give the interviewee more control over the interview and to gather
rich information. She should ask _____ questions.
A. closed-ended
B. inappropriate
C. open-ended
D. opinion
E. probing
12. A JAD session can _____.
A. allow all the users to be interviewed at once
B. enable feedback after installation of a new system
C. teach the managers to draw the UML diagrams
D. reduce scope creep by 50%
E. allow observation techniques to be employed
13. A JAD facilitator is _____.
A. the person who sets the meeting agenda and guides the discussion
B. the person who records the discussion
C. a person who participates in the discussion
D. a person who is also a power user
E. none of the above
14. What information-gathering strategy enables the analyst to see the reality of the situation
rather than listen to others describe it?
A. document analysis
B. interviewing
C. joint application design (JAD) sessions
D. observation
E. questionnaires
15. Which of the following diagramming symbols represents a subject boundary in a use case
diagram?
A
B
C
D
E
16. A(n) _____ use case is typically created early in the process of understanding the system
requirements as a way of documenting basic information about the use case.
A. overview
B. detail
C. essential
D. real
E. imaginary
17. The correct sequence of the major steps in creating use case diagrams is _____.
A. identify the major use cases, expand the major use cases, confirm the major use cases,
create the use-case diagram
B. identify the major use cases, expand the major use cases, create the use-case diagram,
confirm the major use cases
C. create the use-case diagram, identify the major use cases, expand the major use cases,
confirm the major use cases
D. create the use-case diagram, identify the major use cases, confirm the major use cases,
expand the major use cases
E. identify the major use cases, confirm the major use cases, expand the major use cases,
create the use-case diagram
18. If a student signs up for a course module, which type of relationship would you use to
model the relationship between the student and module?
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
19. A class diagram is a(n) _____ model.
A. static
B. dynamic
C. evolving
D. obsolete
E. none of the above
20. A(n) _____ is an instantiation of a class.
A. attribute
B. behaviour
C. operation
D. message
E. object
21. _____ are information that is sent to objects to tell it to execute one of its behaviours.
A. Attributes
B. Operations
C. Messages
D. Instances
E. Use-cases
22. Which of the following objects would most likely be destroyed at some point in time in a
sequence diagram?
A. customer
B. order
C. order item
D. invoice
E. shopping cart/basket
23. The focus in a sequence diagram is on __________________
A. how actors interact with objects to realize a given use case
B. messages sent by actors to other objects
C. when an object is being created
D. when messages are being destroyed
E. time ordering of messages being passed between objects
24. In a sequence diagram, conditional messages are indicated by placing the condition
between _____ symbols.
A. < >
B. “ “
C. ‘ ‘
D. [ ]
E. / /
25. To avoid the classic design mistake of “silver bullet syndrome,” the analyst should _____.
A. increase the schedule to include learning time
B. move proposed changes into future versions
C. not switch or upgrade development tools unless there is a compelling need
D. not use a design tool that appears too good to be true
E. use rapid application development techniques or timeboxing operation
26. There are three methods to create a new system. They are _____.
A. buy a package, external vendor, external service provider
B. develop custom application in-house, external service provider, and external vendor
C. external service provider, rely on a developer, and external vendor
D. in-house custom application, buy a package, and external vendor
E. in-house custom application, external service provider, and external vendor
27. The following are all strengths of a custom development design strategy EXCEPT _____.
A. building technical skills
B. greater creativity
C. greater flexibility
D. lower risk
E. none of the above
28. An advantage of purchasing packaged software is that the organisation can _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. have developers climb the knowledge ladder
D. make strategic changes during implementation
E. save money on the purchase
29. A disadvantage of purchasing packaged software is that the organization may _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. make strategic changes during implementation
D. remove all risk from the project
E. save money on the purchase
30. Data may be stored in the following formats _____.
A. databases
B. entities
C. entities and files
D. files
E. files and databases
31. A relational database may be optimized for _____.
A. data type and storage efficiency
B. relational type
C. speed of access
D. storage efficiency
E. storage efficiency and speed of access
32. A(n) _____ occurs when data are stored redundantly in a database and only some of the
instances are updated when a change is needed.
A. error
B. update anomaly
C. data integrity concern
D. storage efficiency
E. none of the above
33. If the data model does not have any repeating fields it is in _____.
A. base normal form
B. first normal form
C. non-normal form
D. second normal form
E. third normal form
34. A mini-table that contains values from one or more columns in a table and the location of
the values within the table is called a(n) _____.
A. index
B. interfile cluster
C. intrafile cluster
D. raw data calculation
E. volumetric
35. When information systems projects fail, the primary reason has traditionally been _____
A. improperly trained programmers
B. inadequate planning
C. poor analysis, design, installation, or project management
D. poor programming
E. shortened testing periods
36. A classic mistake made during the implementation phase is to _____.
A. create a risk assessment
B. maintain control over the code
C. plan for the use of state-of-the-art technology
D. spend too much time in testing
E. use low cost personnel
37. _____ allow hiding everything in a system behind a visible interface, making testing
difficult.
A. Encapsulation and information hiding
B. Polymorphism and dynamic binding
C. Inheritance
D. Reuse
E. Object-oriented development processes
38. Post-implementation activities include _____.
A. project assessment
B. system maintenance
C. system support
D. system support and system maintenance
E. system support, system maintenance, and project assessment
39. The conversion style that recommends operating the new system along side the old
system for a trial period is known as _____.
A. direct
B. parallel
C. phased
D. pilot
E. simultaneous
40. The process of refining the system to make sure that it continues to meet business and
organizational needs is called _____.
A. change management
B. project assessment
C. system maintenance
D. system review
E. system support
SECTION B - Answer TWO questions in this section. You should answer this
section in the answerbook provided.
1. This question is about Rapid Application Development (RAD) Methodologies.
(a) What kind of Rapid Application Development (RAD) methodology does the diagram
above show? What advantages does this method have over the Waterfall
Development Methodology?
(b) The two other RAD systems design methodologies involve the creation of a
prototype. Provide a diagram for both of these methodologies showing the
progression of the phases of the Systems Development Life Cycle (SDLC). Of the
two methodologies, which would be the best for development of safety critical
system?
(c) Which of the three RAD methodologies considered in this question would you
consider most suitable to use in an Object Oriented approach to Systems
Development? Give reasons for your answer.
2. This question is about Computing Architectures
(a) Explain the meaning of the terms client and server, as used in the field of systems
architecture design. Provide two examples of each.
(b) What is meant by application logic, presentation logic, data access logic, and data
storage? How are these usually distributed in two-tiered and three-tiered client-server
systems?
(c) What are the main advantages and disadvantages of client-server systems compared
with purely server-based systems architectures.
3. This question is about UML (Unified Modeling Language) Behavioural Models.
Consider the following description of the life cycle of a customer order for PC parts and
accessories from an Internet-based company.
(a) Construct a behavioural state machine (statechart) diagram for the order object
described in the scenario above.
(b)Explain the terms state, transition and event, using your diagram as an example.
(c) What is the most important feature of behavioural models, such as behavioural state
machines and sequence diagrams, that is not a feature of structural models, such as
class diagrams?
system to implement them is called a(n) _____.
A. computer programmer
B. end-user
C. systems analyst
D. systems specialist
E. technical writer
2. The four phases of the Systems Development Life Cycle are _____.
A. analysis, gathering, modeling, and diagramming
B. construction, installation, testing, and converting
C. designing, charting, formatting, and structuring
D. planning, analysis, design, and implementation
E. system request, feasibility, planning, and staffing
3. The project sponsor is the _____.
A. lead systems analyst on the project team
B. person or department that requested the system
C. computer programmer who writes the code for the system
D. project team leader in charge of developing the system
E. any of the above may fill the role of the project sponsor
4. Deciding how the hardware, software, and network infrastructure will operate occurs
during the _____ phase of the SDLC.
A. analysis
B. design
C. implementation
D. planning
E. strategy
5. The phase of the SDLC when the system is actually built or purchased is the _____ phase.
A. analysis
B. construction
C. design
D. implementation
E. planning
6. _____ development is a structured design methodology that proceeds in a sequence from
one phase to the next.
A. Parallel
B. Phased
C. Prototyping
D. Rapid Application
E. Waterfall
7. The idea of placing data and the processes (methods) that operate on the data into the
same object is referred to as __________________.
A. Information Hiding
B. Polymorphism
C. Object Binding
D. Encapsulation
E. Inheritance
8. A(n) ___________ models the interaction of the information system with its end-users
and other external systems.
A. Implementation plan
B. Use case diagram
C. Class diagram
D. Package diagram
E. Database diagram
9. _________ represent the things, concepts or ideas that are contained in an application.
A. Interaction diagrams
B. Deployment diagrams
C. Sequence diagrams
D. Class diagrams
E. Use Case diagrams
10. Understanding the as-is system, identifying improvements, and developing requirements
for the to-be system are the steps of the _____ phase.
A. analysis
B. design
C. implementation
D. planning
E. SDLC
11. Sarah would like to give the interviewee more control over the interview and to gather
rich information. She should ask _____ questions.
A. closed-ended
B. inappropriate
C. open-ended
D. opinion
E. probing
12. A JAD session can _____.
A. allow all the users to be interviewed at once
B. enable feedback after installation of a new system
C. teach the managers to draw the UML diagrams
D. reduce scope creep by 50%
E. allow observation techniques to be employed
13. A JAD facilitator is _____.
A. the person who sets the meeting agenda and guides the discussion
B. the person who records the discussion
C. a person who participates in the discussion
D. a person who is also a power user
E. none of the above
14. What information-gathering strategy enables the analyst to see the reality of the situation
rather than listen to others describe it?
A. document analysis
B. interviewing
C. joint application design (JAD) sessions
D. observation
E. questionnaires
15. Which of the following diagramming symbols represents a subject boundary in a use case
diagram?
A
B
C
D
E
16. A(n) _____ use case is typically created early in the process of understanding the system
requirements as a way of documenting basic information about the use case.
A. overview
B. detail
C. essential
D. real
E. imaginary
17. The correct sequence of the major steps in creating use case diagrams is _____.
A. identify the major use cases, expand the major use cases, confirm the major use cases,
create the use-case diagram
B. identify the major use cases, expand the major use cases, create the use-case diagram,
confirm the major use cases
C. create the use-case diagram, identify the major use cases, expand the major use cases,
confirm the major use cases
D. create the use-case diagram, identify the major use cases, confirm the major use cases,
expand the major use cases
E. identify the major use cases, confirm the major use cases, expand the major use cases,
create the use-case diagram
18. If a student signs up for a course module, which type of relationship would you use to
model the relationship between the student and module?
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
19. A class diagram is a(n) _____ model.
A. static
B. dynamic
C. evolving
D. obsolete
E. none of the above
20. A(n) _____ is an instantiation of a class.
A. attribute
B. behaviour
C. operation
D. message
E. object
21. _____ are information that is sent to objects to tell it to execute one of its behaviours.
A. Attributes
B. Operations
C. Messages
D. Instances
E. Use-cases
22. Which of the following objects would most likely be destroyed at some point in time in a
sequence diagram?
A. customer
B. order
C. order item
D. invoice
E. shopping cart/basket
23. The focus in a sequence diagram is on __________________
A. how actors interact with objects to realize a given use case
B. messages sent by actors to other objects
C. when an object is being created
D. when messages are being destroyed
E. time ordering of messages being passed between objects
24. In a sequence diagram, conditional messages are indicated by placing the condition
between _____ symbols.
A. < >
B. “ “
C. ‘ ‘
D. [ ]
E. / /
25. To avoid the classic design mistake of “silver bullet syndrome,” the analyst should _____.
A. increase the schedule to include learning time
B. move proposed changes into future versions
C. not switch or upgrade development tools unless there is a compelling need
D. not use a design tool that appears too good to be true
E. use rapid application development techniques or timeboxing operation
26. There are three methods to create a new system. They are _____.
A. buy a package, external vendor, external service provider
B. develop custom application in-house, external service provider, and external vendor
C. external service provider, rely on a developer, and external vendor
D. in-house custom application, buy a package, and external vendor
E. in-house custom application, external service provider, and external vendor
27. The following are all strengths of a custom development design strategy EXCEPT _____.
A. building technical skills
B. greater creativity
C. greater flexibility
D. lower risk
E. none of the above
28. An advantage of purchasing packaged software is that the organisation can _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. have developers climb the knowledge ladder
D. make strategic changes during implementation
E. save money on the purchase
29. A disadvantage of purchasing packaged software is that the organization may _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. make strategic changes during implementation
D. remove all risk from the project
E. save money on the purchase
30. Data may be stored in the following formats _____.
A. databases
B. entities
C. entities and files
D. files
E. files and databases
31. A relational database may be optimized for _____.
A. data type and storage efficiency
B. relational type
C. speed of access
D. storage efficiency
E. storage efficiency and speed of access
32. A(n) _____ occurs when data are stored redundantly in a database and only some of the
instances are updated when a change is needed.
A. error
B. update anomaly
C. data integrity concern
D. storage efficiency
E. none of the above
33. If the data model does not have any repeating fields it is in _____.
A. base normal form
B. first normal form
C. non-normal form
D. second normal form
E. third normal form
34. A mini-table that contains values from one or more columns in a table and the location of
the values within the table is called a(n) _____.
A. index
B. interfile cluster
C. intrafile cluster
D. raw data calculation
E. volumetric
35. When information systems projects fail, the primary reason has traditionally been _____
A. improperly trained programmers
B. inadequate planning
C. poor analysis, design, installation, or project management
D. poor programming
E. shortened testing periods
36. A classic mistake made during the implementation phase is to _____.
A. create a risk assessment
B. maintain control over the code
C. plan for the use of state-of-the-art technology
D. spend too much time in testing
E. use low cost personnel
37. _____ allow hiding everything in a system behind a visible interface, making testing
difficult.
A. Encapsulation and information hiding
B. Polymorphism and dynamic binding
C. Inheritance
D. Reuse
E. Object-oriented development processes
38. Post-implementation activities include _____.
A. project assessment
B. system maintenance
C. system support
D. system support and system maintenance
E. system support, system maintenance, and project assessment
39. The conversion style that recommends operating the new system along side the old
system for a trial period is known as _____.
A. direct
B. parallel
C. phased
D. pilot
E. simultaneous
40. The process of refining the system to make sure that it continues to meet business and
organizational needs is called _____.
A. change management
B. project assessment
C. system maintenance
D. system review
E. system support
SECTION B - Answer TWO questions in this section. You should answer this
section in the answerbook provided.
1. This question is about Rapid Application Development (RAD) Methodologies.
(a) What kind of Rapid Application Development (RAD) methodology does the diagram
above show? What advantages does this method have over the Waterfall
Development Methodology?
(b) The two other RAD systems design methodologies involve the creation of a
prototype. Provide a diagram for both of these methodologies showing the
progression of the phases of the Systems Development Life Cycle (SDLC). Of the
two methodologies, which would be the best for development of safety critical
system?
(c) Which of the three RAD methodologies considered in this question would you
consider most suitable to use in an Object Oriented approach to Systems
Development? Give reasons for your answer.
2. This question is about Computing Architectures
(a) Explain the meaning of the terms client and server, as used in the field of systems
architecture design. Provide two examples of each.
(b) What is meant by application logic, presentation logic, data access logic, and data
storage? How are these usually distributed in two-tiered and three-tiered client-server
systems?
(c) What are the main advantages and disadvantages of client-server systems compared
with purely server-based systems architectures.
3. This question is about UML (Unified Modeling Language) Behavioural Models.
Consider the following description of the life cycle of a customer order for PC parts and
accessories from an Internet-based company.
(a) Construct a behavioural state machine (statechart) diagram for the order object
described in the scenario above.
(b)Explain the terms state, transition and event, using your diagram as an example.
(c) What is the most important feature of behavioural models, such as behavioural state
machines and sequence diagrams, that is not a feature of structural models, such as
class diagrams?
Thursday, February 23, 2012
Systems Analysis and Design Exercise 01
1. The process of understanding how an information system can support business needs, design the system, build it, and deliver it to users is the _____.
A. analysis phase of the SDLC
B. object oriented approach
C. rule for creating a CASE tool
D. systems development life cycle
E. waterfall development methodology
2. The primary goal of the systems analyst is to _____.
A. acquire a working tool
B. create a wonderful system
C. make a significant business impact
D. establish the three phases of the SDLC
E. purchase a silver bullet
3. The _____ is generated by the department or person that has an idea for a new information system.
A. feasibility analysis
B. gradual refinement
C. project sponsor
D. system request
E. work plan
4. In which phase of the SDLC is the system proposal developed?
A. analysis
B. design
C. implementation
D. planning
E. system delivery
5. The analysis phase of the SDLC answers which questions _____.
A. who will create the system and when will it be used
B. who will the system be for, what the system will do, when will it be used, and where will it be used
C. why build the system, what the system will be, and how the system will work
D. why build the system, who will the system be for, when will it be used, and how the system will work
E. why build the system, who will the system be for, when will it be used, and where will it be used
6. The principal disadvantages(s) with the waterfall development methodology is (are) _____.
A. a long time elapses between completion of the system proposal and the delivery of the system
B. it identifies system requirements long before programming begins
C. it minimizes changes to the requirements as the project proceeds
D. the design must be completely specified on paper before programming begins
E. a long time elapses between completion of the system proposal and the delivery of the system and the design must be completely specified on paper before programming begins
7. Objects can be thought of as little modules that encapsulate _____.
A. Techniques for system development
B. Data and processes
C. Other objects
D. System specifications
E. Business operations
8. The distinction between a class and an object is _____________________.
A. A class is a template for creating objects, while an object is an instance of a class
B. An object is a template for creating objects, while a class is an instance of an object
C. Classes can be instantiated from objects, while the opposite is not true
D. Classes and objects both are templates only, but classes provide a more complete template
E. Neither a class nor an object is a template, but objects are better suited for system development
9. Each object has _______ that specify information about the object.
A. Methods
B. Messages
C. Procedures
D. Other objects
E. Attributes
10. ________ implement an object’s behaviour.
A. Methods
B. Messages
C. Procedures
D. Other objects
E. Attributes
11. _________ are instructions sent to an object that in turn trigger methods.
A. Data
B. Messages
C. Procedures
D. Other objects
E. Attributes
12. According to the principle of inheritance, ________________________
A. A superclass inherits methods and attributes from its subclass
B. A subclass inherits messages and data from its superclass
C. A superclass inherits messages and data from its subclass
D. A class can inherit methods and attributes from every other class
E. A subclass inherits methods and attributes from its superclass
13. _____ means that the same message can be interpreted differently by different classes of objects.
A. Inheritance
B. Encapsulation
C. Polymorphism
D. Information Hiding
E. Dynamic Binding
14. _______ is an example of functional requirements.
A. The system should work with any web browser
B. The system should load any web page within 3 seconds
C. Customers should be able to see their orders after authentication
D. The system should comply with the company’s policy of buying all PCs and servers from Dell
E. The system should be able to search all available inventory in order to determine whether a product can be made by a given date
15. The most commonly used information-gathering technique is _____.
A. interviewing
B. joint application design (JAD) sessions
C. document analysis
D. observation
E. questionnaires
16. During an interview, the following question is asked; “How many times during a typical week does a customer complain about inadequate service following a sale?” This question is an example of a (n) _____ question.
A. Opinion-generating
B. Eye-opening
C. open-ended
D. closed-ended
E. probing
17. The information gathering technique that is most effective in combining information from a variety of perspectives, building consensus, and resolving discrepancies is a(n) _____.
A. document analysis
B. interview
C. joint application development
D. observation
E. questionnaire
18. The information gathering technique that enables the analyst to collect facts and opinions from a wide range of geographically dispersed people quickly and with the least expense is the _____.
A. document analysis
B. interview
C. JAD session
D. observation
E. questionnaire
19. Which of the following diagramming symbols represents a use case in a use case diagram?
A.
B.
C.
D.
E.
20. Which of the following diagramming symbols represents a generalization relationship in a use case diagram?
A.
B.
C.
D.
E.
21. The event that causes a use case to begin is called a(n) _____.
A. action
B. trigger
C. hammer
D. anvil
E. stakeholder
22. Which of the following relationships represent the extension of the functionality of the use case to cover optional behaviour?
A. association relationship
B. extend relationship
C. include relationship
D. generalization relationship
E. optional relationship
23. Which of the following are used to create objects?
A. concrete objects
B. abstract objects
C. concrete classes
D. abstract classes
E. concrete instances
24. Which of the following would most likely not be an example of an attribute?
A. employee name
B. customer address
C. stock number
D. ISBN number
E. cancel appointment
25. A(n) _____ of an analysis class is where the behaviour of the class is defined.
A. operation
B. attribute
C. class
D. object
E. abstract class
26. “A-kind-of” relationships represent _____ relationships.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
27. “A-part-of” or “has-parts” relationships represent _____ relationships.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
28. Which of the following would not be an appropriate class name?
A. student
B. patient
C. John
D. customer
E. doctor
29. An analyst depicts the static view of an information system with _____.
A. use-case models
B. structural models
C. behavioural models
D. interaction diagrams
E. statechart diagrams
30. A(n) _____ describes information about an object.
A. attribute
B. behaviour
C. operation
D. message
E. instance
31. A systems analyst draws a lifeline with an X at the end. This lifeline represents _____.
A. a message that cannot be delivered
B. an object that is destroyed at a point in time
C. a message that is delivered at that point in time
D. an object that is complete at that point in time
E. an object that arrives at its final destination
32. On a sequence diagram, an object name of Students:List would indicate that _____.
A. Students is an instance of the List class that contains individual student objects
B. List is an instance of the Students class
C. List is a method of the Students class
D. the Students and Lists objects are combined for that step in the sequence diagram
E. a message is being passed from the Students class to the List class
33. The order of messages on a sequence diagram goes from ____ to _____.
A. right to left
B. bottom to top
C. left to right
D. top to bottom
E. left to right, top to bottom
34. Which of the following is not a fundamental way to approach the creation of a new information system?
A. develop a custom application in-house
B. rely on an external vendor to build the system
C. purchase a software package and customize it
D. rely on end-users to develop it themselves
E. all of the above are ways to create new information systems
35. An advantage of custom development is that the organization can _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. install in a short period of time
D. remove all risk from the project
E. save money on the purchase
36. The process of building new systems by combining packaged software, existing legacy systems, and new software written to integrate everything together is called _____.
A. customization
B. formal methodology
C. outsourcing
D. systems integration
E. workaround
37. Manipulating certain parameters to refine the way features work in a software package is called _____.
A. a workaround
B. adjustment
C. customization
D. feature adjustability
E. parameterizing
38. What is one primary problem with server-based computing architectures?
A. As more users place heavier demands on the server, it is expensive to increase server capacity.
B. Client terminals are no longer made by hardware vendors.
C. It is difficult to maintain security in the server-based environment.
D. Servers are no longer made by hardware vendors.
E. Servers cannot be manufactured quickly by vendors.
39. In an n-tiered architecture, the _____ is (are) spread across two or more different sets of servers.
A. presentation logic
B. application logic
C. data access logic
D. data storage
E. presentation logic, application logic, data access logic or data storage
40. A(n) _____ is basically an electronic list of information that is stored on a disk.
A. sequential access file
B. unordered sequential access file
C. ordered sequential access file
D. random access file
E. transaction file
41. The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.
A. hierarchical integrity
B. primary integrity
C. table integrity
D. referential unity
E. referential integrity
42. A data model that does not contain repeating fields and leads to tables containing fields that are dependent on a whole primary key is in _____ normal form.
A. balanced
B. first
C. primary
D. second
E. third
43. If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.
A. base normal form
B. first normal form
C. non-normal form
D. second normal form
E. third normal form
44. In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model.
A. cluster
B. denormalize
C. index
D. normalize
E. optimize
45. _____ is the development of all parts of the new system including the software, documentation, and new operating procedures.
A. Construction
B. Design
C. Documentation
D. Management
E. Testing
46. The cost of fixing one major bug after the system is installed can easily exceed the _____.
A. annual salary of a programmer
B. cost of one week’s work as a programmer
C. cost of two weeks’ work as a programmer
D. entire cost of the programming project
E. value of the entire systems team
47. The number of errors found will be highest in the _____ stage of testing.
A. unit test
B. integration test
C. system test
D. acceptance test (alpha)
E. acceptance test (beta)
48. _____ documentation is designed to help programmers and systems analysts understand the application software and maintain it after the system is installed.
A. Acceptance
B. Integration
C. Navigation
D. System
E. User
49. Which of the following is the most costly aspect of the installation process?
A. change management
B. conversion
C. maintenance
D. training
E. analysis
50. Training for a business system should focus on _____.
A. all the capabilities of the new system
B. complex computerized modules and code
C. helping the users to accomplish their jobs
D. how to use the system
E. not using the system
SECTION B
1. Consider the following Use Case Description. This relates to the scenario of a customer placing an order with an online CD marketing company.
Use Case Name: Place Order ID: 3 Importance Level: High
Primary Actor: Customer Use Case Type: Detail, Essential
Stakeholders and Interests: Customer - wants to search website to purchase CD.
Marketing Manager - wants to maximise customer satisfaction.
Brief Description: This use case describes how customers can search the website and place orders.
Trigger: Customer visits website and places order
Type: External
Relationships:
Association: Customer
Include: Checkout, Maintain Order
Extend:
Generalization:
Normal Flow of Events:
1. The Customer submits a search request to the system.
2. The system provides the customer with a list of recommended CDs.
3. The Customer chooses one of the CDs to find out additional information..
4. The System provided the Customer with basic information and reviews on the CD.
5. The Customer calls the Maintain Order use case.
6. The Customer iterates over steps 3 through 5 until finished shopping.
7. The Customer executes the checkout use case.
8. The Customer leaves the website.
Subflows:
Alternate/exceptional flows:
3a-1. The Customer submits a new search request to the system.
3a-2. The Customer iterates over steps 2 through 3 until satisfied with search results or gives up.
7a. The Customer aborts the order.
(a) From the above use case description, draw a Unified Modeling Language (UML) Sequence Diagram, showing the normal flow of events only.
Hint: The objects needed to describe this scenario are instances of the Search Request, CD List, CD, Marketing Information, Customer, Review, Artist Information, Sample Clip, Shopping Cart/Basket and Order classes.
(b) Without drawing any further diagrams, describe the two main differences between sequence diagrams and class diagrams.
2. This question is about Requirements Gathering (Requirements Determination).
(a) Joint Application Design (JAD) Sessions are often used to gather information during the analysis phase of a project. List the five steps involved in the use of JAD Sessions for requirements gathering.
(b)
i) What are the three key functions of the facilitator during a JAD session?
ii) What does a facilitator specifically not do during a JAD session?
iii) What is the function of a scribe during a JAD session?
(c) Interviews are another method commonly used for system requirements gathering. List the five steps involved in the use of interviews, giving a short explanation of each step.
3. This question is about Class Diagrams. Consider the following scenario.
In Hogwits University Health Centre, the Health Team is made up of three doctors and one or more secretaries. At busy times, one or more nurses join the team. All these persons are a kind of employee at the health centre. Persons who visit the health centre with at least one symptom are called patients. Each symptom may, or may not, be caused by an illness.
(a) Construct a UML (Unified Modelling Language) Class Diagram using the information provided in the above scenario. You should show aggregation, generalisation, and other associations, together with multiplicity, where appropriate.
(b) A treatment can be used to cure an illness, or relieve symptoms of that illness. Where would you place a 'treatment' class on the diagram that you constructed in 3. (a) above? You should add the 'treatment' class appropriately to your diagram, and provide a clear explanation of your reasoning.
A. analysis phase of the SDLC
B. object oriented approach
C. rule for creating a CASE tool
D. systems development life cycle
E. waterfall development methodology
2. The primary goal of the systems analyst is to _____.
A. acquire a working tool
B. create a wonderful system
C. make a significant business impact
D. establish the three phases of the SDLC
E. purchase a silver bullet
3. The _____ is generated by the department or person that has an idea for a new information system.
A. feasibility analysis
B. gradual refinement
C. project sponsor
D. system request
E. work plan
4. In which phase of the SDLC is the system proposal developed?
A. analysis
B. design
C. implementation
D. planning
E. system delivery
5. The analysis phase of the SDLC answers which questions _____.
A. who will create the system and when will it be used
B. who will the system be for, what the system will do, when will it be used, and where will it be used
C. why build the system, what the system will be, and how the system will work
D. why build the system, who will the system be for, when will it be used, and how the system will work
E. why build the system, who will the system be for, when will it be used, and where will it be used
6. The principal disadvantages(s) with the waterfall development methodology is (are) _____.
A. a long time elapses between completion of the system proposal and the delivery of the system
B. it identifies system requirements long before programming begins
C. it minimizes changes to the requirements as the project proceeds
D. the design must be completely specified on paper before programming begins
E. a long time elapses between completion of the system proposal and the delivery of the system and the design must be completely specified on paper before programming begins
7. Objects can be thought of as little modules that encapsulate _____.
A. Techniques for system development
B. Data and processes
C. Other objects
D. System specifications
E. Business operations
8. The distinction between a class and an object is _____________________.
A. A class is a template for creating objects, while an object is an instance of a class
B. An object is a template for creating objects, while a class is an instance of an object
C. Classes can be instantiated from objects, while the opposite is not true
D. Classes and objects both are templates only, but classes provide a more complete template
E. Neither a class nor an object is a template, but objects are better suited for system development
9. Each object has _______ that specify information about the object.
A. Methods
B. Messages
C. Procedures
D. Other objects
E. Attributes
10. ________ implement an object’s behaviour.
A. Methods
B. Messages
C. Procedures
D. Other objects
E. Attributes
11. _________ are instructions sent to an object that in turn trigger methods.
A. Data
B. Messages
C. Procedures
D. Other objects
E. Attributes
12. According to the principle of inheritance, ________________________
A. A superclass inherits methods and attributes from its subclass
B. A subclass inherits messages and data from its superclass
C. A superclass inherits messages and data from its subclass
D. A class can inherit methods and attributes from every other class
E. A subclass inherits methods and attributes from its superclass
13. _____ means that the same message can be interpreted differently by different classes of objects.
A. Inheritance
B. Encapsulation
C. Polymorphism
D. Information Hiding
E. Dynamic Binding
14. _______ is an example of functional requirements.
A. The system should work with any web browser
B. The system should load any web page within 3 seconds
C. Customers should be able to see their orders after authentication
D. The system should comply with the company’s policy of buying all PCs and servers from Dell
E. The system should be able to search all available inventory in order to determine whether a product can be made by a given date
15. The most commonly used information-gathering technique is _____.
A. interviewing
B. joint application design (JAD) sessions
C. document analysis
D. observation
E. questionnaires
16. During an interview, the following question is asked; “How many times during a typical week does a customer complain about inadequate service following a sale?” This question is an example of a (n) _____ question.
A. Opinion-generating
B. Eye-opening
C. open-ended
D. closed-ended
E. probing
17. The information gathering technique that is most effective in combining information from a variety of perspectives, building consensus, and resolving discrepancies is a(n) _____.
A. document analysis
B. interview
C. joint application development
D. observation
E. questionnaire
18. The information gathering technique that enables the analyst to collect facts and opinions from a wide range of geographically dispersed people quickly and with the least expense is the _____.
A. document analysis
B. interview
C. JAD session
D. observation
E. questionnaire
19. Which of the following diagramming symbols represents a use case in a use case diagram?
A.
B.
C.
D.
E.
20. Which of the following diagramming symbols represents a generalization relationship in a use case diagram?
A.
B.
C.
D.
E.
21. The event that causes a use case to begin is called a(n) _____.
A. action
B. trigger
C. hammer
D. anvil
E. stakeholder
22. Which of the following relationships represent the extension of the functionality of the use case to cover optional behaviour?
A. association relationship
B. extend relationship
C. include relationship
D. generalization relationship
E. optional relationship
23. Which of the following are used to create objects?
A. concrete objects
B. abstract objects
C. concrete classes
D. abstract classes
E. concrete instances
24. Which of the following would most likely not be an example of an attribute?
A. employee name
B. customer address
C. stock number
D. ISBN number
E. cancel appointment
25. A(n) _____ of an analysis class is where the behaviour of the class is defined.
A. operation
B. attribute
C. class
D. object
E. abstract class
26. “A-kind-of” relationships represent _____ relationships.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
27. “A-part-of” or “has-parts” relationships represent _____ relationships.
A. generalization
B. association
C. aggregation
D. subsetting
E. vague
28. Which of the following would not be an appropriate class name?
A. student
B. patient
C. John
D. customer
E. doctor
29. An analyst depicts the static view of an information system with _____.
A. use-case models
B. structural models
C. behavioural models
D. interaction diagrams
E. statechart diagrams
30. A(n) _____ describes information about an object.
A. attribute
B. behaviour
C. operation
D. message
E. instance
31. A systems analyst draws a lifeline with an X at the end. This lifeline represents _____.
A. a message that cannot be delivered
B. an object that is destroyed at a point in time
C. a message that is delivered at that point in time
D. an object that is complete at that point in time
E. an object that arrives at its final destination
32. On a sequence diagram, an object name of Students:List would indicate that _____.
A. Students is an instance of the List class that contains individual student objects
B. List is an instance of the Students class
C. List is a method of the Students class
D. the Students and Lists objects are combined for that step in the sequence diagram
E. a message is being passed from the Students class to the List class
33. The order of messages on a sequence diagram goes from ____ to _____.
A. right to left
B. bottom to top
C. left to right
D. top to bottom
E. left to right, top to bottom
34. Which of the following is not a fundamental way to approach the creation of a new information system?
A. develop a custom application in-house
B. rely on an external vendor to build the system
C. purchase a software package and customize it
D. rely on end-users to develop it themselves
E. all of the above are ways to create new information systems
35. An advantage of custom development is that the organization can _____.
A. accept functionality that is not a perfect fit
B. build technical skills and functional knowledge
C. install in a short period of time
D. remove all risk from the project
E. save money on the purchase
36. The process of building new systems by combining packaged software, existing legacy systems, and new software written to integrate everything together is called _____.
A. customization
B. formal methodology
C. outsourcing
D. systems integration
E. workaround
37. Manipulating certain parameters to refine the way features work in a software package is called _____.
A. a workaround
B. adjustment
C. customization
D. feature adjustability
E. parameterizing
38. What is one primary problem with server-based computing architectures?
A. As more users place heavier demands on the server, it is expensive to increase server capacity.
B. Client terminals are no longer made by hardware vendors.
C. It is difficult to maintain security in the server-based environment.
D. Servers are no longer made by hardware vendors.
E. Servers cannot be manufactured quickly by vendors.
39. In an n-tiered architecture, the _____ is (are) spread across two or more different sets of servers.
A. presentation logic
B. application logic
C. data access logic
D. data storage
E. presentation logic, application logic, data access logic or data storage
40. A(n) _____ is basically an electronic list of information that is stored on a disk.
A. sequential access file
B. unordered sequential access file
C. ordered sequential access file
D. random access file
E. transaction file
41. The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.
A. hierarchical integrity
B. primary integrity
C. table integrity
D. referential unity
E. referential integrity
42. A data model that does not contain repeating fields and leads to tables containing fields that are dependent on a whole primary key is in _____ normal form.
A. balanced
B. first
C. primary
D. second
E. third
43. If the logical data model contains fields that depend on another non-primary key field, then it is in violation of the rules of _____.
A. base normal form
B. first normal form
C. non-normal form
D. second normal form
E. third normal form
44. In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model.
A. cluster
B. denormalize
C. index
D. normalize
E. optimize
45. _____ is the development of all parts of the new system including the software, documentation, and new operating procedures.
A. Construction
B. Design
C. Documentation
D. Management
E. Testing
46. The cost of fixing one major bug after the system is installed can easily exceed the _____.
A. annual salary of a programmer
B. cost of one week’s work as a programmer
C. cost of two weeks’ work as a programmer
D. entire cost of the programming project
E. value of the entire systems team
47. The number of errors found will be highest in the _____ stage of testing.
A. unit test
B. integration test
C. system test
D. acceptance test (alpha)
E. acceptance test (beta)
48. _____ documentation is designed to help programmers and systems analysts understand the application software and maintain it after the system is installed.
A. Acceptance
B. Integration
C. Navigation
D. System
E. User
49. Which of the following is the most costly aspect of the installation process?
A. change management
B. conversion
C. maintenance
D. training
E. analysis
50. Training for a business system should focus on _____.
A. all the capabilities of the new system
B. complex computerized modules and code
C. helping the users to accomplish their jobs
D. how to use the system
E. not using the system
SECTION B
1. Consider the following Use Case Description. This relates to the scenario of a customer placing an order with an online CD marketing company.
Use Case Name: Place Order ID: 3 Importance Level: High
Primary Actor: Customer Use Case Type: Detail, Essential
Stakeholders and Interests: Customer - wants to search website to purchase CD.
Marketing Manager - wants to maximise customer satisfaction.
Brief Description: This use case describes how customers can search the website and place orders.
Trigger: Customer visits website and places order
Type: External
Relationships:
Association: Customer
Include: Checkout, Maintain Order
Extend:
Generalization:
Normal Flow of Events:
1. The Customer submits a search request to the system.
2. The system provides the customer with a list of recommended CDs.
3. The Customer chooses one of the CDs to find out additional information..
4. The System provided the Customer with basic information and reviews on the CD.
5. The Customer calls the Maintain Order use case.
6. The Customer iterates over steps 3 through 5 until finished shopping.
7. The Customer executes the checkout use case.
8. The Customer leaves the website.
Subflows:
Alternate/exceptional flows:
3a-1. The Customer submits a new search request to the system.
3a-2. The Customer iterates over steps 2 through 3 until satisfied with search results or gives up.
7a. The Customer aborts the order.
(a) From the above use case description, draw a Unified Modeling Language (UML) Sequence Diagram, showing the normal flow of events only.
Hint: The objects needed to describe this scenario are instances of the Search Request, CD List, CD, Marketing Information, Customer, Review, Artist Information, Sample Clip, Shopping Cart/Basket and Order classes.
(b) Without drawing any further diagrams, describe the two main differences between sequence diagrams and class diagrams.
2. This question is about Requirements Gathering (Requirements Determination).
(a) Joint Application Design (JAD) Sessions are often used to gather information during the analysis phase of a project. List the five steps involved in the use of JAD Sessions for requirements gathering.
(b)
i) What are the three key functions of the facilitator during a JAD session?
ii) What does a facilitator specifically not do during a JAD session?
iii) What is the function of a scribe during a JAD session?
(c) Interviews are another method commonly used for system requirements gathering. List the five steps involved in the use of interviews, giving a short explanation of each step.
3. This question is about Class Diagrams. Consider the following scenario.
In Hogwits University Health Centre, the Health Team is made up of three doctors and one or more secretaries. At busy times, one or more nurses join the team. All these persons are a kind of employee at the health centre. Persons who visit the health centre with at least one symptom are called patients. Each symptom may, or may not, be caused by an illness.
(a) Construct a UML (Unified Modelling Language) Class Diagram using the information provided in the above scenario. You should show aggregation, generalisation, and other associations, together with multiplicity, where appropriate.
(b) A treatment can be used to cure an illness, or relieve symptoms of that illness. Where would you place a 'treatment' class on the diagram that you constructed in 3. (a) above? You should add the 'treatment' class appropriately to your diagram, and provide a clear explanation of your reasoning.
Script to list database Vault Realms, Command Rules And Rule Sets
1) Listing the Database Vault realms:
set lines 500 pages 500
column realm_name format a40
column col1 format a30
column col2 format a30 Heading "Owner / Grantee "
column col3 format a30 Heading "Object Type/Rule Set Name"
column col4 format a30 Heading "Object Name/Auth Options"
break on realm_name skip 3
select * from (
SELECT realm_Name , 'protected objects' col5, owner col2 , object_type col3 ,object_name col4
FROM dvsys.dba_dv_realm_object
union
select REALM_NAME ,'authorizations' col5, GRANTEE col2 ,AUTH_RULE_SET_NAME col3 , AUTH_OPTIONS col4
from dvsys.dba_dv_realm_auth )
order by realm_name asc ,col5 desc
/
2) Listing the Database Vault command rules:
set lines 1000 pages 499
column COMMAND format a30
column RULE_SET_NAME format a30
column OBJECT_OWNER format a30
column OBJECT_NAME format a30
column ENABLED format a30
column PRIVILEGE_SCOPE format a30
select * from dvsys.DBA_DV_COMMAND_RULE;
3) Listing the Database Vault rules and rule sets:
column RULE_SET_NAME format a30
column RULE_NAME format a50
column RULE_EXPR format a60
column ENABLED format a8
column RULE_ORDER format 9999
break on RULE_SET_NAME skip 3
select * from dvsys.DBA_DV_RULE_SET_RULE;
Following is the sample output of above three scripts.
set lines 500 pages 500
column realm_name format a40
column col1 format a30
column col2 format a30 Heading "Owner / Grantee "
column col3 format a30 Heading "Object Type/Rule Set Name"
column col4 format a30 Heading "Object Name/Auth Options"
break on realm_name skip 3
select * from (
SELECT realm_Name , 'protected objects' col5, owner col2 , object_type col3 ,object_name col4
FROM dvsys.dba_dv_realm_object
union
select REALM_NAME ,'authorizations' col5, GRANTEE col2 ,AUTH_RULE_SET_NAME col3 , AUTH_OPTIONS col4
from dvsys.dba_dv_realm_auth )
order by realm_name asc ,col5 desc
/
2) Listing the Database Vault command rules:
set lines 1000 pages 499
column COMMAND format a30
column RULE_SET_NAME format a30
column OBJECT_OWNER format a30
column OBJECT_NAME format a30
column ENABLED format a30
column PRIVILEGE_SCOPE format a30
select * from dvsys.DBA_DV_COMMAND_RULE;
3) Listing the Database Vault rules and rule sets:
column RULE_SET_NAME format a30
column RULE_NAME format a50
column RULE_EXPR format a60
column ENABLED format a8
column RULE_ORDER format 9999
break on RULE_SET_NAME skip 3
select * from dvsys.DBA_DV_RULE_SET_RULE;
Following is the sample output of above three scripts.
SQL> conn dv
Enter password:
Connected.
SQL> set lines 500 pages 500
SQL> column realm_name format a40
SQL> column col1 format a30
SQL> column col2 format a30 Heading "Owner / Grantee "
SQL> column col3 format a30 Heading "Object Type/Rule Set Name"
SQL> column col4 format a30 Heading "Object Name/Auth Options"
SQL> break on realm_name skip 3
SQL>
SQL>
SQL> select * from (
2 SELECT realm_Name , 'protected objects' col5, owner col2 , object_type col3 ,object_name col4
3 FROM dvsys.dba_dv_realm_object
4 union
5 select REALM_NAME ,'authorizations' col5, GRANTEE col2 ,AUTH_RULE_SET_NAME col3 , AUTH_OPTIONS col4
6 from dvsys.dba_dv_realm_auth )
7 order by realm_name asc ,col5 desc
8 /
REALM_NAME COL5 Owner / Grantee Object Type/Rule Set Name Object Name/Auth Options
---------------------------------------- ----------------- ------------------------------ ------------------------------ ------------------------------
Database Vault Account Management protected objects % ROLE CONNECT
protected objects % ROLE DV_ACCTMGR
authorizations DV_ACCTMGR Owner
Oracle Data Dictionary protected objects % ROLE AQ_ADMINISTRATOR_ROLE
protected objects % ROLE AQ_USER_ROLE
protected objects % ROLE CTXAPP
protected objects % ROLE DBA
protected objects % ROLE DELETE_CATALOG_ROLE
protected objects % ROLE DV_REALM_OWNER
protected objects % ROLE DV_REALM_RESOURCE
protected objects % ROLE EJBCLIENT
protected objects % ROLE EXECUTE_CATALOG_ROLE
protected objects % ROLE EXP_FULL_DATABASE
protected objects % ROLE GATHER_SYSTEM_STATISTICS
protected objects % ROLE GLOBAL_AQ_USER_ROLE
protected objects % ROLE HS_ADMIN_ROLE
protected objects % ROLE IMP_FULL_DATABASE
protected objects % ROLE JAVADEBUGPRIV
protected objects % ROLE JAVAIDPRIV
protected objects % ROLE JAVASYSPRIV
protected objects % ROLE JAVAUSERPRIV
protected objects % ROLE JAVA_ADMIN
protected objects % ROLE JAVA_DEPLOY
protected objects % ROLE LOGSTDBY_ADMINISTRATOR
protected objects % ROLE MGMT_USER
protected objects % ROLE OEM_MONITOR
protected objects % ROLE OLAP_DBA
protected objects % ROLE OLAP_USER
protected objects % ROLE RECOVERY_CATALOG_OWNER
protected objects % ROLE RESOURCE
protected objects % ROLE SCHEDULER_ADMIN
protected objects % ROLE SELECT_CATALOG_ROLE
protected objects ANONYMOUS % %
protected objects BI % %
protected objects CTXSYS % %
protected objects DBSNMP % %
protected objects EXFSYS % %
protected objects MDDATA % %
protected objects MDSYS % %
protected objects MGMT_VIEW % %
protected objects OLAPSYS % %
protected objects OUTLN % %
protected objects SYS % %
protected objects SYSMAN % %
protected objects SYSTEM % %
authorizations SYS Owner
authorizations SYSTEM Participant
authorizations WKSYS Owner
authorizations WKUSER Owner
Oracle Database Vault protected objects DVF % %
protected objects SYSTEM TABLE AUD$
protected objects SYS VIEW AQ%DATAPUMP%
protected objects SYS TABLE SYSNT%
protected objects SYS TABLE AQ%DATAPUMP%
protected objects SYS INDEX SYS%
protected objects SYS % DBMS_RLS
protected objects LBACSYS % %
protected objects DVSYS % %
protected objects % ROLE LBAC_DBA
protected objects % ROLE DV_STREAMS_ADMIN
protected objects % ROLE DV_SECANALYST
protected objects % ROLE DV_ADMIN
protected objects % ROLE DV_MONITOR
protected objects % ROLE DV_OWNER
protected objects % ROLE DV_PATCH_ADMIN
protected objects % ROLE DV_PUBLIC
authorizations DV_OWNER Owner
authorizations DV_ADMIN Participant
authorizations DVSYS Owner
authorizations LBACSYS Owner
Oracle Enterprise Manager protected objects SYSMAN % %
protected objects DBSNMP % %
protected objects % ROLE OEM_MONITOR
protected objects % ROLE MGMT_USER
protected objects % ROLE MGMT_VIEW
authorizations SYSMAN Owner
authorizations SYSTEM Owner
authorizations DBSNMP Owner
78 rows selected.
SQL> set lines 1000 pages 499
column COMMAND format a30
column RULE_SET_NAME format a30
column OBJECT_OWNER format a30
column OBJECT_NAME format a30
column ENABLED format a30
column PRIVILEGE_SCOPE format a30
select * from dvsys.DBA_DV_COMMAND_RULE; SQL> SQL> SQL> SQL> SQL> SQL> SQL>
COMMAND RULE_SET_NAME OBJECT_OWNER OBJECT_NAME ENABLED PRIVILEGE_SCOPE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------
CREATE USER Can Maintain Accounts/Profiles % % Y
DROP USER Can Maintain Accounts/Profiles % % Y
CREATE PROFILE Can Maintain Accounts/Profiles % % Y
ALTER PROFILE Can Maintain Accounts/Profiles % % Y
DROP PROFILE Can Maintain Accounts/Profiles % % Y
ALTER USER Can Maintain Own Account % % Y
ALTER SYSTEM Allow Fine Grained Control of % % Y
System Parameters
7 rows selected.
SQL> column RULE_SET_NAME format a30
column RULE_NAME format a50
column RULE_EXPR format a60
column ENABLED format a8
column RULE_ORDER format 9999
break on RULE_SET_NAME skip 3
select * from dvsys.DBA_DV_RULE_SET_RULE;
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
RULE_SET_NAME RULE_NAME RULE_EXPR ENABLED RULE_ORDER
------------------------------ -------------------------------------------------- ------------------------------------------------------------ -------- ----------
Enabled True 1=1 Y 1
Disabled False 1=0 Y 1
Can Maintain Accounts/Profiles Is User Manager DVSYS.DBMS_MACUTL.USER_HAS_ROLE_VARCHAR('DV_ACCTMGR',dvsys.d Y 1
v_login_user) = 'Y'
Can Maintain Own Account Is Alter DVSYS Allowed DVSYS.DBMS_MACADM.IS_ALTER_USER_ALLOW_VARCHAR(dvsys.dv_login Y 1
_user) = 'Y'
Login User Is Object User UPPER(dvsys.dv_login_user) = UPPER(dvsys.dv_dict_obj_name) Y 1
Can Grant VPD Administration Is Security Owner DVSYS.DBMS_MACUTL.USER_HAS_ROLE_VARCHAR('DV_OWNER',dvsys.dv_ Y 1
login_user) = 'Y'
Allow System Parameters Is _system_trig_enabled Parameters Allowed DVSYS.DBMS_MACADM.check_trig_parm_varchar = 'Y' Y 1
Is o7_dictionary_accessibility Parameters Allowed DVSYS.DBMS_MACADM.check_o7_parm_varchar = 'Y' Y 1
Is _dynamic_rls_init Parameters Allowed DVSYS.DBMS_MACADM.check_dynrls_parm_varchar = 'Y' Y 1
Allow Oracle Data Pump Operati DVDP$5002 dvsys.dv_login_user = 'SYSTEM' Y 1
on
DVDP$5008 dvsys.dv_login_user = 'SYSTEM' Y 1
DVDP$5010 dvsys.dv_login_user = 'TEST3' Y 1
DVDP$5004 dvsys.dv_login_user = 'SYSTEM' Y 1
False 1=0 Y 1
Allow Fine Grained Control of Are System Security Parameters Allowed DVSYS.DBMS_MACADM.check_sys_sec_parm_varchar = 'Y' Y 1
System Parameters
Are Dump or Dest Parameters Allowed DVSYS.DBMS_MACADM.check_dump_dest_parm_varchar = 'Y' Y 1
Are Backup Restore Parameters Allowed DVSYS.DBMS_MACADM.check_backup_parm_varchar = 'Y' Y 1
Are Database File Parameters Allowed DVSYS.DBMS_MACADM.check_db_file_parm_varchar = 'Y' Y 1
Are Optimizer Parameters Allowed DVSYS.DBMS_MACADM.check_optimizer_parm_varchar = 'Y' Y 1
Are PL-SQL Parameters Allowed DVSYS.DBMS_MACADM.check_plsql_parm_varchar = 'Y' Y 1
Are Security Parameters Allowed DVSYS.DBMS_MACADM.check_security_parm_varchar = 'Y' Y 1
Allow Scheduler Job False 1=0 Y 1
DV$5000 (dvsys.dv_job_invoker = 'SYS') AND (dvsys.dv_job_owner = 'EX Y 1
FSYS')
23 rows selected.
Subscribe to:
Posts (Atom)
Tag Cloud
10.2g
10g
11g
11gR2
Abasa
About Oracle
Administration
Adsense
Alerts
Archival
ASM
ASP.Net
Audit
Audit Vault
Backup
Bangladesh
Block Corruption
Blogger
Browser
Bug
Business
Clone
Clusterware
Comments
Concepts
Connection
Controlfiles
Crime
CSS
Data Block
Data Dictionary
Data Guard
Data Mining
Data Pump
Data Type
Database Administration
Database Vault
DBConsole
Developer
Economics
EM
Excel
Exercise
Explain plan
Export
External Table
Facebook
Firefox
Firmware
Flashback
Forum
Functions
Games
Globalization Support
Grid Control
Hardware
History
HTML
IE
Import
Indexes
initializaion parameter
initialization parameter
Installation
Internals
Internet
Interview
isql*plus
Java
JavaScript
Job
Joins
Joke
Limitation
Linux
Listener
Logminer
Magento
Mail
Materialized View
Medical
Memory
Mobile
Money
Multimedia
MySQL
Net Services
Network
OCP
Operators
Oracle
Oracle Concepts
Oracle Recovery
OS
Others
OUI
Package
Packages
Parameters
Partitioning
Patchset
Performance
Perl
Pfile
Photos
PHP
PL/SQL
Profile
Pseudocolumns
Puzzle
Quiz
Quota
RAC
RAC Installation
Recovery
Recovery Problems
Redo Log
Reports
RMAN
Scripts
Security
SEO
Server Administration
SGA
Shell Script
Smarty
Social Marketing
Solaris
Spfile
SQL
SQL Tuning
SQL*Loader
Sql*Plus
Startup Problem
Streams
SwingBench
System Analysis
Tablespaces
Technology
Temp
TNS Error
Tools
Troubleshooting
Tuning
Undo
UNIX
Upgradation
Utilities
Version
Views
Vmware
Windows
Wordpress
XML