Essentials of Systems Analysis and Design, 5e



MIS 4200 System and Database Analysis, Design, and Development

Answers to Review For Final Questions

(The numbers refers to the questions in the Review package given)

30) The end user is not the person in the organization most involved in the systems analysis and design process.

Answer: TRUE

Page Reference: 3 (if want to check the book for details)

31) A boundary is the point of contact where a system meets its environment or where subsystems meet each other.

Answer: FALSE

Page Ref: 7

32) An interface separates a system from other systems.

Answer: FALSE

Page Ref: 7

33) In the systems development life cycle, it is possible to complete some activities in one phase in parallel with some activities of another phase.

Answer: TRUE

Page Ref: 13

34) A feasibility study is conducted before the second phase of the SDLC to determine the economic and organizational impact of the system.

Answer: TRUE

Page Ref: 14

35) The output of the systems planning and selection phase is a description of the alternative solution recommended by the analysis team.

Answer: FALSE

Page Ref: 14

36) Logical design is tied to a specific hardware and software platform.

Answer: FALSE

Page Ref: 15

37) During logical design, the analyst team decides which programming languages the computer instructions should be written in, which database systems and file structures will be used for the data, and which hardware platform, operating system, and network environment the system will run under.

Answer: FALSE

Page Ref: 15

38) Systems implementation and operation is the final phase of the SDLC.

Answer: TRUE

Page Ref: 15

39) During operation, programmers make the changes that users ask for and modify the system to reflect changing business conditions.

Answer: TRUE

Page Ref: 17

40) Involving the user in analysis and design is a key advantage to the prototyping technique.

Answer: TRUE

Page Ref: 18

41) Joint application design (JAD) is a structured process in which users, managers, and analysts work together for several days in a series of intensive meetings to specify or review system requirements.

Answer: TRUE

Page Ref: 19

42) A key principle of the Agile Methodologies is a clear focus on people rather than roles.

Answer: TRUE

Page Ref: 21

TRUE/FALSE

CHAPTER 4 – Systems Exercise 01

| |Requirements structuring is the first activity of the systems planning and selection phase. |T |F |

| |Note: p. 84 in book for details | | |

| | | | |

| |Projects identified by top management have a cross-functional focus. |T |F |

| |Note: p. 85 in book | | |

| |The development group identifies projects based on the ease with which existing hardware and systems will integrate with the |T |F |

| |proposed project. | | |

| |Note: p. 85 in book | | |

| |To maintain consistency, the classification and ranking of projects should only be performed by top management or a steering |T |F |

| |committee. | | |

| |Note: p. 95-96 in book | | |

| |The criteria used to evaluate projects will vary by organization. |T |F |

| |Note: p. 86 in book | | |

| |A schedule of specific IS development projects is the primary deliverable from the project identification and selection |T |F |

| |phase. | | |

| |Note: p. 87 in book | | |

| |Due to the principle of incremental commitment, a selected project will result in a working system. |T |F |

| |Note: p. 88 in book | | |

| |The objective of project identification and selection is to transform a vague system request document into a tangible project|T |F |

| |description. | | |

| |Note: p. 88 in book | | |

| |The major outcome from project initiation and planning are the Baseline Project Plan. |T |F |

Database Questions

52) Which of the following can be used to run the oralab02.sql script file in SQL Plus? (choose all correct answers)

a. Execute oralab02.sql

b. @ oralab02.sql

c. Run oralab02.sql

d. Start oralab02.sql

e. None of the above

53) You want to use the INSERT INTO command to add data to all the columns of an Oracle table, but you don’t remember the order of the columns in the table. What SQL command can you use to verify the order? Answer: ____DESCRIBE____________________________________________

54) When you use the CREATE SEQUENCE command to create a sequence, you need to use

a COMMIT command (at a later time) for the sequence to ultimately exist in the database. T F

Explanation: COMMIT is only need for DML command (like INSERT INTO), NOT for DDL commands like CREATE TABLE or CREATE SEQUENCE

55) The SQL CREATE SEQUENCE command is a data manipulation language command. T F

Explanation: No it is a DDL command used to define (i.e. create) database objects called sequences. CREATE TABLE is another DDL command used to create table objects in a database.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download