CISP457 Practice Final

Prof. Tak Auyeung

Instructions: You may bring any material that is handwritten or printed prior to the examination to help you. You can also bring a calculator if you think it may help you. However, you can only use the calculator for numerical computations only.

You, as an individual, are expected to do your own work. This means you cannot seek, receive or otherwise acquire any assistance except clarifications from the professor during an examination. Any communication involving the contents of the subject matter or the examination is considered cheating. Do not initiate or accept such communication, or the result of your examination is automatically voided.

Each correct answer is worth one point, each wrong answer is worth -0.25 point, and each unanswered question is worth zero point.

Make sure you write down you name on the upper right corner first, otherwise I cannot give points to anonymous students!

1. Who is responsible to maintain the daily operation of a computer information system?
   1. a systems analyst
   2. a systems administrator
   3. a programmer
   4. a technical writer
   5. a test engineer
2. What does the client know?
   1. domain specific knowledge
   2. how to write systems specification documents
   3. how to write test plans
   4. how to write programs
   5. how to write end-user documents
3. Which of the following is a financial requirement?
   1. the system has the capacity for 40% growth
   2. the system be safe from viruses and worms
   3. the total development cost be no more than $1,200,000
   4. the final stage be delivered no later than July 23, 2006
   5. the daily downtime be no more than 10 minutes
4. 

   In this use case diagram, which of the following statement is true?

   1. Customer generalizes Premium Customer
   2. Req Live Support specializes Req Email Support
   3. Req Live Support generalizes Req Email Support
   4. Premium Customer generalizes Customer
   5. Both 4a and 4c
5. What is the purpose of a use case diagram?
   1. to document the logic of system behavior
   2. to document how classes relate
   3. to document external agents and how they see the system
   4. to document non-functional requirements
   5. to document an example system interaction sequence
6. Explain why ``request spell check'' is not a use case in a system designed for web logging (blogging).
   1. it is not complete (an article must have been written first)
   2. it does not serve any value
   3. it does not involve an actor
   4. it is not complete and it does not serve any value
   5. it is not complete, does not serve any value, and does not involve an actor
7. Which of the following cannot an element in a sequence diagram?
   1. an object
   2. a call message/stimulus
   3. a reply message/stimulus
   4. a dispatch action
   5. all of the above are (possible) elements in a sequence diagram
8. Which of the following can be an actor in a use case diagram?
   1. Brad Pitt
   2. producer
   3. movie
   4. rate movie
   5. none of the above is suitable as an actor in a use case diagram
9. Which of the following can be a use case in a use case diagram?
   1. Brad Pitt
   2. producer
   3. movie
   4. rate movie
   5. none of the above is suitable as an actor in a use case diagram
10. The client says ``an expert user is a user, except that an expert user can ... in addition to what a user can do.''

    What is the relationship between the actor ``user'' and the actor ``expert user''? (Hint: think of what relationships are allowed between actors.)

    1. ``user'' generalizes ``expert user''
    2. ``user'' includes ``expert user''
    3. ``expert user'' includes ``user''
    4. ``expert user'' generalizes ``user''
    5. ``expert user'' extends ``user''
11. Which of the following cost is unlikely to be a cost component after the development phase is completed?
    1. cost of system upgrade
    2. salary of systems administrators
    3. salary of programmers
    4. cost of internet service provider (for an online system)
    5. cost annual maintenence contracts
12. Observe the following cumulative cost chart:

    

    Which of the following is true?

    1. System A is always less expensive than system B
    2. System B is always less expensive than system A
    3. System B does not start saving money until about month 45
    4. System A does not start saving money until about month 45
    5. None of the above is true
13. Which part of the following flowchart is potentially repetitive?

    

    1. operation1
    2. operation2
    3. operation1 and operation2
    4. operation1 and the condition check $x < y$
    5. operation2 and the condition check $x < y$
14. In the following decision table, which action(s) is/are taken when C1 is true, C2 is false and C3 is true?

    C1	C2	C3	A1	A2	A3
    T	T	T	X	X	X
    T	T	F		X
    T	F	T	X	X
    T	F	F	X	X	X
    F	T	T		X	X
    F	T	F	X	X
    F	F	T		X	X
    F	F	F	X	X

    1. only A1
    2. only A1 and A3
    3. only A1 and A2
    4. only A2 and A3
    5. only A3
15. We need to express the logic/process to validate a credit card transaction. Which type of diagram is appropriate for this purpose?
    1. state diagram
    2. activity diagram
    3. use case diagram
    4. class diagram
    5. sequence diagram
16. In the following state diagram, what happens when the user clicks the ``start'' button when the timer is still in ``idle'' state?

    

    1. nothing happens
    2. the timer jumps from the ``idle'' state to the ``count down'' state
    3. the timer transitions from the ``idle'' state to the ``time set'' state
    4. the timer jumps to the final state
    5. the timer restarts from the initial state
17. Despite the fact that activity diagrams are not ``structured'' like decision trees, decision tables and pseudocode, what is a strong point of activity diagrams that makes it unique?
    1. ability to express data flow
    2. ability to express parallel threads
    3. ability to express loops
    4. ability to interleave decisions and actions
    5. the combination of all of the above
18. The aggregation relationship can be used in which type of diagrams?
    1. class diagram
    2. use case diagram
    3. sequence diagram
    4. activity diagram
    5. state diagram
19. Which diagram describes how the deletion of an object of a class may trigger the deletion of an object of another class?
    1. class diagram
    2. use case diagram
    3. sequence diagram
    4. activity diagram
    5. state diagram
20. Each transition coming out of a decision state in an activity diagram must have...
    1. a trigger specified
    2. a guard condition specified
    3. an action specified
    4. a trigger and a guard condition specified
    5. a trigger and an action specified
21. We need to modify the ``feel-and-look'' of a system. For example, a numeric field in an user interface may be enhanced to only allow digits at data-entry time. What classes will be modified? (Note that a modification may necessitate everything be changed, I am just asking which ones needs to be changed.)
    1. Boundary classes
    2. Control classes
    3. Data classes
    4. Control classes and Data classes
    5. Boundary classes and Data classes
22. We are given some tables, and we know that the column someID is used as a primary key in one table, while it is used as a foreign key in the others. Which table uses someID as a primary key?

    This is table1:

    someID	colA	colB
    143	Tony	Smith
    3511	Jane	White
    23	Pat	Peterson
    782	Kenny	Lee

    This is table2:

    someID	colC
    143	1582
    143	2328
    3511	3849
    23	48293

    This is table3:

    someID	colD
    143	5928
    3511	99832
    23	37293
    23	23212

    1. table1
    2. table2
    3. table3
    4. table1 and table2
    5. all three tables use ``someID'' as a primary key
23. If a table/class does not conform to the second normal form, what is one of the potential problems?
    1. difficult to search
    2. difficult to query (resulting in long and complex queries)
    3. consumes more storage than necessary
    4. requires too many supporting tables
    5. easy to make mistakes in queries
24. The following table does not confirm to which normal form?

    ID	FirstName	LastName	Phone1	Phone2
    2384	Tak	Auyeung	555-5555
    93022	Damon	Antos	123-4556	283-2839
    49208	Dave	Fox	987-6543

    1. first normal form
    2. second normal form
    3. third normal form
    4. all of the above (yes, this is the correct answer!)
    5. none of the above, this class conforms to all three normal forms.