IS390 CH 11-13, Exam 1-3

9. The authors describe "writing programs" as:

a) A fun, creative activity

29. Acceptance testing is generally done in two stages:

a) Alpha tests and beta tests

Marco is working for iTunes and needs to have a database that can store complex data. His best choice might be: a) An object database b) A relational database c) A red-green database d) A tree database e) A spanning database

a) An object database

7. The process of coordinating a program as it changes through construction (like keeping files and programs in different places) is called:

a) Change control

14. On test plans:

a) Each individual test has a specific objective and describes a set of very specific test cases to examine

30. When you join two relational database tables together, frequently the primary key in one table will be a ____________ in the other table. a) Foreign key b) International key c) Primary key d) Linked list e) Entity

a) Foreign key

24. As compared to integration testing, system testing:

a) Is much broader in scope

25. Integration testing focuses on ___________; while system tests focus on _______________.

a) Modules working together; meeting business requirements

31. The authors suggest a good time to start the documentation process is:

a) Once the interface design and program specifications are complete

32. This type of documentation is designed to be used when the user needs to learn how to perform a specific function (such as updating a field or adding a new record):

a) Reference documentation

Most relational database systems support: a) Referential integrity b) Pop-up menus c) Customizable user-interface colors and graphics d) The 'three-clicks' rule e) Broadband connectivity

a) Referential integrity

The purpose of creating physical ERDs is to: a) Show implementation details and to explain more about the 'how' of the final system b) Normalize the database to third normal form c) Do a new technology analysis d) Drive the users nuts e) Help junior analysts to find the transactions between systems

a) Show implementation details and to explain more about the 'how' of the final system

The project team is very knowledgeable about relational database management systems. In terms of feasibility, this might be best known as: a) Technical feasibility ('can we build it') b) Economic feasibility ('should we build it') c) Managerial feasibility ('why would we build it') d) Graphical feasibility ('does it fit this project') e) Organizational feasibility ('if we build it, will they use it')

a) Technical feasibility ('can we build it')

22. Which of the following is NOT an approach to integration testing?

a) Use-case testing

The concept for planning good performance of databases is known as: a) Volumetrics b) Econometrics c) Moving averages d) Correlation e) PERT

a) Volumetrics

Considering conversion style, conversion locations, and conversion modules, the most risky approach is probably:

a) direct, simultaneous, whole-system

33. Connie knows that _________ when trying to motivate people to change

a) people act on what they believe to be true, not what actually is true

44. Training is probably the most _________ part of any change management initiative.

a) self-evident

6. Bridget is managing a systems development project. The programmers have gotten farther and farther behind in the schedule. One thing she should NOT do is:

b) Add more programmers to the development team

This type of file records "before" and "after" images of data as the data gets altered. a) Intelligent files b) Audit files c) Master files d) Raw files e) Prime files

b) Audit files

The concept of putting records that are somehow related together on the same server (or storage device) is called: a) Carmelization b) Clustering c) Joining d) Normalization e) Hybrid technologies

b) Clustering

4. Which is generally the best understood component of the SDLC and may offer the fewest problems?

b) Developing the system's software

31. The CRUD matrix shows a) The crud that is coming into the system and how to quarantine it b) Exactly how data are used and created by the major processes in the system c) The 1:M relationships on an ERD diagram d) The external entities, process and major data flows from the Context DFD diagram e) Where customer, relationships, users and developers will interact with a system

b) Exactly how data are used and created by the major processes in the system

2. The two basic formats for data storage: a) Spreadsheets and documents b) Files and databases c) Databases and presentations d) Flash and web forms e) ERDs and Use cases

b) Files and databases

5. According to the textbook, which of the following is not a cause of project failure?

b) Flaws in aesthetics

32. The most efficient tables (in terms of storage efficiency) in relational database management systems: a) Have duplicate data, especially for when more than one table is joined together for queries b) Have no redundant data c) Are denormalized d) Have entire tables duplicated e) Use plasma technologies

b) Have no redundant data

4. Juan is using a file that is created by an older, legacy system. It is likely that the data is: a) Unusable b) In a proprietary format c) In a standard format (like comma separated value) d) Is sorted by customer's middle name e) In an object-oriented structure like Ariel

b) In a proprietary format

19. Generally, most errors (defects) are found in which two testing periods?

b) Integration testing and system testing

The type of processing system that creates reports for supervisors (and other functional users) probably would be a: a) Transaction Processing System (TPS) b) Management Information System (MIS) c) Executive Support System (ESS) d) Decision Support System (DSS) e) Rebate Management System (RMS)

b) Management Information System (MIS)

18. Which of the following is NOT a general test stage?

b) Module tests

Which of the following is not a RDBMS? a) Oracle b) NoSQL c) SQL d) MySQL e) None of these

b) NoSQL

51. _________________ is the process of refining the system to make sure it continues to meet business needs.

b) System maintenance

15. The test objective is taken directly from:

b) The program specification

11. The term 'bug' in software came from:

b) The story of a moth getting caught inside an early computer

29. Primary keys are: a) The same as default keys (or default values) b) Unique values for each record in a file or table c) Elementary values (like 'primary' school) d) Prime numbers in a Fibonacci sequence e) The same as foreign keys

b) Unique values for each record in a file or table

27. Acceptance tests are done primarily by:

b) Users

47. Generally the cheapest training to deliver would be:

b) computer-based training (CBT)

43. With resistant adopters (those that simply refuse to accept the change with the new system), it might be better to:

b) ignore this small minority of resistant adopters and focus on the larger majority of ready and reluctant adopters

It has been a busy project experience for Omar. During the analysis phase, he encountered some negative feedback from users. During design, his best user-interface analyst left for a new position and a novice user-interface designer took over. And during the coding, the team had to rely on some off-shore developers who had trouble understand the programming specifications. To get the system running as expected, the testing time was reduced. Which of the following conversion approaches might be the safest approach for Omar and the project team?

b) parallel, pilot site, simultaneous conversion

28. What is probably a common scenario in most organizations when installing a new system?

b) resistance to change exists

39. Which of the following is a true statement about successful change?

b) the likelihood of successful change is increased when the cost of the transition to individuals who must change is low

49. Once the project team has installed the system and performed the change management activities, the system is officially turned over to:

b) the operations group

The authors suggest that "with new systems," it may be best:

b) to expect the worst

31. A comment about why people resist change might be:

b) what is good for the organization is not necessarily good for the people

23. When installing hardware, it is best to:

b) work closely with the vendors who are supplying the hardware

16. The authors suggest that:

c) "It is impossible to test every possible combination of input and situation"

42. Research has shown that about __________ of potential adopters will be ready adopters.

c) 20% to 30%

20. Unit tests focus on:

c) A program or a program module

26. Which of the following is probably something that system testing WILL NOT verify?

c) Conformance to Sarbanes-Oxley requirements

One common method to increase access speed is to: a) Use legacy databases in a indexed sequential access method b) Encrypt all data with 256 byte encryption c) Denormalize the tables d) Delete all primary keys e) Only use alphabetic data

c) Denormalize the tables

In most cases, decision support systems are best at: a) Finding particular records that are stored in legacy databases b) Finding processes that are stored in object databases c) Finding aggregated data d) Analyzing audit (or log) files for possible intrusion and security breaches e) Red and green linked list processing

c) Finding aggregated data

Legacy databases might include ________ and ______________ a) Master files and transaction files b) Audit files and look-up files c) Hierarchical databases and network databases d) Tree databases and leaf databases e) Red databases and Green databases

c) Hierarchical databases and network databases

33. Which of the following is NOT a general type of navigation control for help topics?

c) Inverted pointer

21. Black-box testing:

c) Is reserved for very complex systems

6. This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists). a) History Files b) Audit files c) Master files d) Transaction files e) Intelligent files

c) Master files

8. If a program module is taking longer to develop than expected, the recommended action is:

c) Move the expected completion date back

3. Which of the following is an open source DBMS? a) Microsoft Access b) SQL Server c) MySQL d) Excel e) CASE

c) MySQL

13. Test plans:

c) Often have 20 to 30 pages

28. The goal of acceptance testing is:

c) To confirm that the system is complete and meets the business needs

36. Early adopters in the new customer resource management system received faster computers with more memory. In terms of management policy, this is probably an example of:

c) bonus processes

22. Which is NOT a step involved in preparing the technology?

c) convert the logical DFDs into physical DFDs

A lot of the 'unfreeze' part of Lewin's three step model for managing organization change:

c) has been accomplished to this point in the project by the systems development life cycle (SDLC) processes

45. Training should focus on:

c) helping the users to accomplish their jobs

48. The goal of post-implementation activities is to:

c) institutionalize the use of the new system

The two types of conversion modules are:

c) modular conversion and whole-system

34. Which is NOT a basic tool for structuring work processes in organizations?

c) promoting earlier adopters to management positions

Which is NOT a post-implementation activity?

c) system request

32. Connie is trying to motivate users to adopt the new system. The first step she needs to consider is:

c) the factors that inhibit change and the perception of costs and benefits

17. When testing individual modules, it sometimes happens that some modules are not finished when testing starts, so the programmer usually writes _______ for the unfinished modules to enable the modules around them to be tested.

d) "Stub Modules"

A default value is: a) The first value in a table b) The median value in a table c) The smallest value in a table d) A value that probably occurs most frequently e) A mistake made by Dee (aka the name "Dee's fault")

d) A value that probably occurs most frequently

5. Which of the following is NOT a file type described in the textbook? a) History files b) Audit files c) Look-up files d) Algebra files e) Transaction files

d) Algebra files

Which of the following is not a characteristic of Big Data? a) Huge volume b) Rapid velocity c) Great variety d) All are characteristics e) None are characteristics

d) All are characteristics

Plans to handle potential business disruption due to technical problems during conversion are covered in the:

d) Business Contingency Plan

Document-oriented databases have the following characteristics, except: a) Large bit files b) Audio files c) Video files d) Files with uniform structure e) image files

d) Files with uniform structure

12. A program is not considered finished until:

d) It has passed its testing

In a registration database, Ross has tables for student, professor, classroom, class, class-hour. Since his campus has about 12,000 students, when he runs queries about what student is in what class, taught by what professor in what classroom at which hour, the DBMS software will have to perform many _________ a) Axes b) Parallels c) Concretes d) Joins e) Enrolls

d) Joins

1. Which of the following is not a general function of any application program? a) Data storage b) Presentation logic c) Data access logic d) Linked-list modules e) Application logic

d) Linked-list modules

Which of the following is a concept not generally associated with decision support systems? a) Data warehouses b) Data marts c) Aggregated data d) Object orientation e) Multidimensional databases

d) Object orientation

Barb is working on a database design. For the most efficient storage she should remove: ______ and ______. a) Primary keys and foreign keys b) International keys and redundancy c) Adjectives and adverbs d) Redundancy and null values e) Special characters and primary keys

d) Redundancy and null values

The most popular type of database today is the: a) Hierarchical database b) Tree database c) Green database d) Relational database e) Piecemeal database

d) Relational database

30. The two fundamental documentation types are:

d) System documentation and user documentation

23. System tests are usually conducted by:

d) Systems analysts

FoodTitan is a large grocery store chain in the Chicago, Milwaukee, and the Upper Midwest. Generally their stores have from 18 to 36 checkout lanes with scanners. When somebody scans a bar code, the system is probably using a _____ to process the purchased items. a) Executive support system (ESS) b) Barcode processing system (BPS) c) Management information system (MIS) d) Transaction Processing system (TPS) e) A grocery store processing system (GSPS)

d) Transaction Processing system (TPS)

This type of file is used to update a master file: a) Roster Files b) Training files c) Master files d) Transaction files e) Integrated files

d) Transaction files

3. The largest single component of any systems development project in terms of both time and cost could be:

d) Writing programs

53. Which is most likely NOT a part of Project Assessment?

d) a thorough analysis of the software coding as to standards, cohesion and coupling

30. Which is NOT a change management plan step?

d) installing 'user friendly' hardware

35. The habitual routines for how work is performed are called:

d) standard operating procedures

When considering costs of a new system conversion, which is NOT a common cost to consider?

d) the hardware costs for a pilot system

One of the problems with a parallel conversion is:

d) the users have to enter data into both systems

Many tools like ERwin can help you with database size information and the calculation of volumetrics. a) ERD master b) DFD master c) Denormalization d) Pop-up menu e) CASE

e) CASE

Which is NOT a type of database file? a) Hierarchical databases b) Relational databases c) Object databases d) Multidimensional databases e) Federal database

e) Federal database

1. During the implementation phase of the SDLC:

e) None of these

10. A major credit card company has an hour of system downtime on the Friday after Thanksgiving (generally one of the biggest shopping days of the year). Which might be a good estimate of the amount of income lost from this outage?

e) Over $500,000

Omar is creating an order database for a multiple site car dealership. The data will be fairly simple: names, addresses, city, state, zip code, make of car, model, style, color, etc. Probably the best choice for him would be a _____________ database. a) Multidimensional b) Hierarchical c) Legacy d) Object e) Relational

e) Relational

New databases collectively referred to as NoSQL databases have appeared in recent years. Which of the following are categorized as a NoSQL database? a) Document-oriented database b) Wide column stores c) Graph databases d) Extensible record stores e) Relational Database system

e) Relational Database system

The acronym for the standard language used to access data in relational databases is: a) ERD b) CRM c) ERP d) BPR e) SQL

e) SQL

Systems that support decision making will probably: a) Do a lot of updating of data b) Be transaction processing systems c) Be audit files d) Use Gantt charts e) Usually just read data - and often in ad hoc ways

e) Usually just read data - and often in ad hoc ways

27. Which is not a common data type? a) Character b) Text c) Integer d) Date e) Video

e) Video

2. During the implementation phase of the SDLC:

e) none of these