MIS 311 chap 11, MIS 311 chap 12, MIS 406 - Ch 10, Legit T/F Chapter 10 CSIT 338

A DSS is a design support structure and does the 'ETL' (extract, transform and load) to create data warehouses.

FALSE

A great advantage of object oriented database management systems is their ease of learning.

FALSE

Adding new requirements to a project after the system design has been finalized is called "requirements creep".

FALSE

Alpha and beta tests are part of systems testing.

FALSE

An 'international key' is used to relate two tables together (like customer ID from the customer table is an international key in the order table).

FALSE

Analysts should not worry about the users' perceptions of the new system during acceptance testing.

FALSE

Brian wants an e-commerce system to be able to do a lot of rapid processing - like search for particular keywords in documents; return the price of an item; update quantities in the shopping cart. He is probably building an Expert System.

FALSE

By the time the design phase is started, all time estimates should be within 5% of the actual completion time.

FALSE

Change control in application development is a formal process for changing written documentation into online documentation, and frequently uses specialized 'cyber documentation agents' to create menus, screens and online user documentation.

FALSE

Charles has been assigned to developing modules CRM_input_web; CRM_input_validation; CRM_database_retrieval; and CRM_database_update. He is two weeks behind and is only on the second module. This is definitely a serious issue and Charles should be reprimanded or even fired for incompetence.

FALSE

Data marts are larger, aggregated legacy databases.

FALSE

During program design - and again here in the actual programming coordination, we find that it is best to have modules that overlap and have high coupling and low cohesion.

FALSE

During the implementation phase of the Systems Development Life Cycle (SDLC), systems analysts spend their time writing programs and coding applications.

FALSE

If a mismatch exists between available programming skills and the programming staff, the best method to solve this is to put more programmers on the project so that it comes in on time, and within budget!!!!

FALSE

Informix is a pure OODBMS package.

FALSE

Maria is working for the Minneapolis Dance Troop (MDT) and wants a database that can support text, numbers, video, and audio. She will probably select the multidimensional database format.

FALSE

Most relational database management systems support 'sticky' quantitative processing.

FALSE

One activity in the data storage design activity is to update the CRUDE matrix.

FALSE

One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.

FALSE

One process when considering data storage design is to move from physical data models to logical data models.

FALSE

Sanjay is creating a screen form that interfaces with a relational database. He should use the median (middle) value in the database as his default value - as that will make it easier for the users to move up and down in the table.

FALSE

Software bugs are estimated to cost the US economy $12.4 million dollars a year.

FALSE

Systems to support decision making generally need to update data frequently with a large volume of data.

FALSE

Testing is considered as a prized activity on a development project, and developers (programmers), analysts, and project managers frequently request being assigned to develop documentation.

FALSE

The authors suggest a book on managing programming projects called "The Mythical Mountain" written by Roberta Roth.

FALSE

The best design for accessing data faster is generally the most efficient storage as well.

FALSE

The critical path is the fine line between the alpha test and the beta test as you change from test data to real production data.

FALSE

The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.

FALSE

The two basic types of documentation are: portfolio documentation and assessment documentation.

FALSE

The two primary ways to optimize a relational database are (a) for storage efficiency and (b) for using the smallest amount of space.

FALSE

User documentation includes such things as logical ERDs, logical DFDs, use-cases, physical ERDs, physical DFDs and screen mockups.

FALSE

User documentation must be developed at the end of the project, after all programming, testing and approvals have occurred. To do it any earlier may risk not including changes in the system.

FALSE

When converting a logical ERD into a physical data model, you will want to specify both primary keys and international keys.

FALSE

When working on a major project, project teams will always select and stay with only one database format for consistency of development and use.

FALSE

A CRUD matrix shows exactly how data are used and created by major processes in the system.

TRUE

A relational database that is used extensively in data warehousing is a multidimensional database.

TRUE

Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF), he may want to 'denormalize' it so that access might be faster.

TRUE

An ironic fact of systems development is that the more programmers that are involved in the development of the system, the longer the project will take.

TRUE

CRUD stands for 'create', 'read', 'update' and 'delete'.

TRUE

Decision support systems are not designed to find individual records, but to find aggregated information (such as 'what three products sold the best in Boston in February').

TRUE

Generally when assigning programming development tasks, the project manager will analyze skill levels and capabilities of programming staff and also analyze the modules for complexity and try to match complex modules to more experienced and skilled programming developers.

TRUE

If a program module is taking longer to develop than expected, generally the most appropriate approach is to move the expected completion date back by the same amount of time that the module will be late.

TRUE

If the system being analyzed, designed and developed requires programming (as compared to a package or outsourcing), developing the software may be the single largest component of any systems development activity in terms of both time and money.

TRUE

Jasmine is an example of an object-oriented database system.

TRUE

Microsoft Access is an end-user DBMS.

TRUE

Rachel wants aggregated data like find the number of banking customers who have savings accounts over $100,000 and home mortgages with her bank. She probably wants to use a Decision Support System.

TRUE

Referential integrity is the idea of ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

TRUE

System documentation takes all the processes, notes, diagrams from systems analysis and systems design and puts it in a project binder for future reference.

TRUE

Testing and programming are tightly coupled.

TRUE

The main difference between integration testing and system testing is that integration testing looks to see if modules work together without errors; but system testing is more focused on meeting business requirements.

TRUE

The most efficient tables in a relational database in terms of storage space have no redundant data and very few null values.

TRUE

When changing from logical data models to physical data models, you will want to change the attributes of the logical ERD to fields in the physical ERD.

TRUE

When changing logical data models to physical data models, you will want to change entities to tables or files.

TRUE

When creating a project plan, project analysts normally figure out the 'critical path'.

TRUE

When developing navigational controls for online documentation, you should consider tables of contents, indices, text searches, intelligent agents (like context sensitive help), and web-like links between systems.

TRUE

When moving from logical data models to physical data models, you should update your CRUD matrix.

TRUE

With some software systems, a day of down-time caused by a software bug can cost more than several programmers' annual salaries.

TRUE

38. When drawing the human-machine boundary, all processes in the physical DFD will be automated, so only external entities will be excluded.

False

43. A structure chart shows sequence, selection and data flows.

False

45. A control module can also be called a library module and is a set of reusable code.

False

47. A diamond on a structure chart shows sequence - like a baseball player would go to first base, then second, third and home.

False

48. Couples in structure charts always show two modules that are executed together and are drawn with horizontal lines at the top and bottom.

False

51. A structure chart is often completed in one attempt.

False

54. An effective process is an output process on a structure chart.

False

59. Fan-In describes the number of subordinates that communicate with the control module.

False

60. Generally, transaction structures occur at lower levels of a structure chart.

False

32. Because (a) preexisting code needs to be understood, organized, and pieced together; and (b) it is still common for the project team to have to write some code and adapt packages to the business environment, it is therefore good for analysts to fully understand program design.

True

34. Micah is adding implementation resources to change a logical DFD into a physical DFD. He should describe databases, files, tables, and processes as they will be implemented on the computer.

True

35. There are some 'system-related' data stores, data flows and processes that must be added when creating the physical DFD.

True

37. When building the physical data flow diagram, processes may become html web pages or Visual Basic screens.

True

39. An audit control / audit logfile might be a system related process, data flow and data store that would be added when creating physical DFDs.

True

40. When creating the physical DFD, you may want to capture system information like date and time of update and user-id of the person who did the update.

True

41. A temptation when moving from analysis to design of a system is to jump right into coding.

True

42. Amy is an analyst for an automatic payment system. She knows that she will need to create a modular, flexible plan for programmers to follow so that the ensuing system will be maintainable.

True

44. A structure chart is composed of modules that work together to form a program.

True

46. A higher-level component that contains the logic for performing other modules (subordinate modules) is known as a control module.

True

49. Data couples are shown by arrows with empty circles and show how data flows between modules.

True

50. Control couples show the passing of parameters or system related messages between modules (like 'end-of-file').

True

52. The three basic kinds of processes on a process module are afferent, central and efferent.

True

53. An afferent process is an input process on a structure chart.

True

55. A transaction structure in a structure chart contains a control module that calls subordinate modules and frequently occur with menus.

True

56. Factoring is the process of separating out a function from a module in order to create a module of its own.

True

57. A signal of poor cohesion could be the presence of control flags that are passed down to subordinate modules.

True

58. Functional, coincidental, and temporal are all types of cohesion.

True

61. A good indication of needing a transaction structure on a structure chart occurs when a DFD shows a single data flow entering a process that produces multiple data flows as outputs.

True

62. Jim is working from a leveled DFD and creating structure charts. He is finding that the lower levels of the DFD generally correspond to transform structures.

True

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

Integration testing focuses on ___________; while system tests focus on _______________. a) Modules working together; meeting business requirements b) Black-box tests; white-box tests c) End-users acceptance; project sponsor acceptance d) DFDs; ERDs e) Beta tests; alpha tests

a) Modules working together; meeting business requirements

. 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 b) Procedures manuals c) Tutorials d) Systems documentation e) Final documentation

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

Pseudocode is: a) The same as structured English b) A technique similar to structured English c) A subset of the Java programming language d) A coding environment sponsored by Oracle e) The term for designing language prototyping screens with Visual Basic or HTML

b) A technique similar to structured English

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

Generally, most errors (defects) are found in which two testing periods? a) Unit testing and integration testing b) Integration testing and system testing c) System testing and acceptance testing d) Unit testing and acceptance testing e) Alpha testing and beta testing

b) Integration testing and system testing

A general suggestion about using couples in drawing structure charts is: a) The use of many couples clarify the processing b) It is best to be conservative when applying couples to your diagram c) To use 'combination' couples when both data couples and control couples are needed d) You should have at least twice as many afferent couples as efferent couples e) Use only data couples and no control couples

b) It is best to be conservative when applying couples to your diagram

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)

Generally, transaction structures on a structure chard will have: a) Many afferent processes b) Many efferent processes c) Many data couples d) Many control couples e) Many conditional couples

b) Many efferent processes

Which of the following is NOT a general test stage? a) Unit tests b) Module tests c) Integration tests d) System tests e) Acceptance tests

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

The three types of basic processes on a process model: a) Sequence, selection and iteration processes b) Navigation, status and work processes c) Afferent, central and efferent processes d) Batch, online and real time processes e) Singular, bilateral and library processes

c) Afferent, central and efferent processes

Which of the following is NOT a general type of navigation control for help topics? a) Table of contents b) Index c) Inverted pointer d) Text search e) Intelligence agents

c) Inverted pointer

The Human-Machine Boundary a) Is the keyboard and screen b) Builds on research in ergonometry c) Is a line drawn on the physical DFD to separate human action from automated processes d) Is a part of developing the HCI interface e) Separates where manual processes are separated by human completed processes

c) Is a line drawn on the physical DFD to separate human action from automated processes

There are two symbols that describe special types of control in a structure chart. They are a curved arrow and a diamond. These symbols represent _____ and _____. a) connector, conditional line b) control, subordinate c) library module, conditional line d) loop, conditional line e) loop, connector

d) loop, conditional line

In most automated cases, data stores from logical DFDs will be converted to: a) Binary tables b) CD Rom disks c) Paper files d) Into database files / tables e) Encrypted hexadecimal values

d)Into database files / tables

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

Reusable modules, which are represented in the structure chart as rectangles with vertical lines on both sides, may often appear several times in a structure chart. These are called _____ modules. a) conditional b) control c) library d) loop e) off-page connector

c) library

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

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

Which of the following is NOT true? a) Analysts design programs in the design phase of the SDLC, programmers code programs in the Implementation phase b) Analysts can use structure charts to design programming logic c) Analysts can build in the three structures of sequence, selection and iteration into structure charts d) Programmers can take the logical DFDs and directly implement into code by compiling the metadata in the CASE tools e) Physical DFDs show additional details, such as what tables in the database replace data stores on the logical DFD

d) Programmers can take the logical DFDs and directly implement into code by compiling the metadata in the CASE tool

The third step in creating a physical DFD (data flow diagram) is a) update the metadata in the CASE repository b) draw a human-machine boundary c) add implementation references d) add system-related data stores, data flows, and processes e) update the data elements in the data flows

d) add system-related data stores, data flows, and processes

In a structure chart, the element that is drawn as an empty circle with an attached arrow is known as a(n) _____. a) conditional line b) connector c) control couple d) data couple e) module

d) data couple

31. Because project teams rely more on packaged software, program design is no longer needed.

False

33. The Human-Machine boundary is part of the Human-Computer Interface into usability systems.

False

36. Many of the data stores in the logical DFD will be changed into encrypted word processing documents when a physical DFD is developed.

False

The authors describe "writing programs" as: a) A fun, creative activity b) A tedious process c) A very mathematical and logical process d) An excellent learning process for end-users e) Answers B and C

a) A fun, creative activity

When changing a logical DFD into a physical DFD, it might be necessary to ________. a) Add system-related data stores, data flows and processes b) Normalize the logical DFD into 3NF c) Create the user-interface with smaller fonts d) Change the system architecture to three-tiered architecture e) Delete extraneous data stores and delete extraneous data flows

a) Add system-related data stores, data flows and processes

Acceptance testing is generally done in two stages: a) Alpha tests and beta tests b) Black-box tests and white-box tests c) Integration tests and systems tests d) Unit tests and module tests e) Inductive tests and deductive tests

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

The process of coordinating a program as it changes through construction (like keeping files and programs in different places) is called: a) Change control b) Separation of duties c) Judicial control d) Scope creep e) None of these

a) Change control

On test plans: a) Each individual test has a specific objective and describes a set of very specific test cases to examine b) Each user must contribute to the specific goals of the test plan c) Each member of the project team, plus all developers (programmers) must identify one specific application that they will test d) Only the master project manager tests, and only after all coding has been completed in what is called the "Omega" test e) The use of multiple choice options has been shown to effectively assess to a 99.9% accuracy rate

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

As a structure chart is constructed, it is generally best to build modules with: a) High cohesion b) Highly coupled c) High fan-out d) Have the word "and" in the module title e) A high level of coincidental cohesion

a) High cohesion

As compared to integration testing, system testing: a) Is much broader in scope b) Uses production data (rather than test data) c) Is done by hand-picked end-users (rather than systems analysts) d) Involves both black-box and red-box testing e) Makes more extensive use of stubs

a) Is much broader in scope

Generally, transform structures on a structure chart will have: a) Many afferent processes b) Many efferent processes c) Many data couples d) Many control couples e) Many conditional couples

a) Many afferent processes

The authors suggest a good time to start the documentation process is: a) Once the interface design and program specifications are complete b) Once the system test is complete c) Once the alpha acceptance test is complete d) Once the beta acceptance test is complete e) Once the logical ERDs and DFDs have been translated into physical ERDs and DFDs

a) Once the interface design and program specifications are complete

In a structure chart, the purpose of a control couple is to: a) Pass parameters from a subordinate module to the control module b) Pass parameters from the control modules to a subordinate module c) Pass data from a subordinate module to the control module d) Pass data from the control module to a subordinate module e) Chaperone the dance for programmers on the project

a) Pass parameters from a subordinate module to the control module

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')

Which of the following is NOT an approach to integration testing? a) Use-case testing b) User interface testing c) Use scenario testing d) Data flow testing e) System interface 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

The fifth step in creating a physical DFD (data flow diagram) is a) update the metadata in the CASE repository b) draw a human-machine boundary c) add implementation references d) add system-related data stores, data flows, and processes e) update the data elements in the data flows

a) update the metadata in the CASE repository

Pseudocode is: a) A language popularized by Feinstein and Longenecker in the 1990's b) A detailed outline of the lines of code that need to be written c) A 'pretend' syntax inherent in all CASE tools d) The translation of code into ASCII e) A dialect of Visual Basic only used in program design

b) A detailed outline of the lines of code that need to be written

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: a) Use a code generator that comes with high-end CASE tools b) Add more programmers to the development team c) Keep communication channels open d) Hold weekly meetings e) Keep close tabs on the process so it doesn't slip farther

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

Which is generally the best understood component of the SDLC and may offer the fewest problems? a) Developing the database design b) Developing the system's software c) Writing onscreen documentation d) Changing the data into third normal form e) Doing interviews

b) Developing the system's software

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

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

According to the textbook, which of the following is not a cause of project failure? a) Flaws in analysis b) Flaws in aesthetics c) Flaws in user interface design d) Flaws in database design e) Flaws in developing correct system specifications

b) Flaws in aesthetics

The test objective is taken directly from: a) The results of the JAD session b) The program specification c) The use-cases d) The project sponsor e) The questions raised in a focus-group application

b) The program specification

When creating the index, which of these will probably NOT be a place to find terms to include in the index: a) The set of commands in the user interface (like open file, modify, etc.) b) The set of user interface design standards (like aesthetics, layout, consistency, etc.) c) The set of major concepts in the system (like in the Tune Source example of artist, tune, music genre, etc.) d) The set of business tasks (like ordering, returns, adjustments, etc.) e) The set of synonyms for other sets (like 'quit', 'stop', 'end' for 'exit' or 'erase' for 'delete')

b) The set of user interface design standards (like aesthetics, layout, consistency, etc.)

The term 'bug' in software came from: a) An English translation of the word for defect in German b) The story of a moth getting caught inside an early computer c) The acronym BUG - for binary unknown glitch d) No one knows the reason e) None of these

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

Which is NOT true of structure charts? a) They show sequence b) They show the user interface c) They show couples d) They show selection e) They emphasize structure and reusability

b) They show the user interface

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

Acceptance tests are done primarily by: a) Programmers b) Users c) Developers d) Systems Analysts e) Project Managers

b) Users

_____ refers to how well the lines of code within each module in a structure chart relate to each other. a) calculation b) cohesion c) control d) coupling e) fan-in

b) cohesion

In a structure chart, a transaction structure _____. a) contains a control module that calls several subordinate modules in sequence, after which something "happens" b) contains a control module that calls subordinate modules, each handling a particular transaction c) contains a transactional loop d) is a subordinate module that handles a particular transaction e) is subordinate to subordinal modules

b) contains a control module that calls subordinate modules, each handling a particular transaction

The second step in creating a physical DFD (data flow diagram) is a) update the metadata in the CASE repository b) draw a human-machine boundary c) add implementation references d) add system-related data stores, data flows, and processes e) update the data elements in the data flows

b) draw a human-machine boundary

By definition, external entities on the DFD: a) Are used as the starting point for the physical data flow diagram b) Are outside the scope of the system c) Will be the top of the structure chart d) Will become database table entries e) Are updated with metadata to become part of the physical DFD

b)Are outside the scope of the system

In determining if a process is to be automated, the project team will do all of the following EXCEPT: a) Weigh the costs b) Redraw the logical DFD as a combined logical/physical DFD c) Determine benefits d) Evaluate the efficiency e) Consider the integrity of the process to the system

b)Redraw the logical DFD as a combined logical/physical DFD

The authors suggest that: a) "All testing must include live production data" b) "All testing must include both alphabetic and numeric data" c) "It is impossible to test every possible combination of input and situation" d) "Testing rarely pays for itself" e) "Testing should only be used for complex programs and situations"

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

Unit tests focus on: a) All modules (all units) b) Users and their acceptance of how a specific unit works c) A program or a program module d) Interact screen forms e) How the overall system functions

c) A program or a program module

Which of the following is probably something that system testing WILL NOT verify? a) Systems documentation b) Ability to perform under heavy load c) Conformance to Sarbanes-Oxley requirements d) How well the system meets business requirements e) The systems usability

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

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

If a program module is taking longer to develop than expected, the recommended action is: a) Put more programmers on the staff b) Force the developers to work weekends to catch up c) Move the expected completion date back d) Incorporate scope creep into the requirements e) Change the development environment into an object-oriented language

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

. Test plans: a) Are generally developed by the programmers informally b) Generally only cover main processing and not the various sub-processes c) Often have 20 to 30 pages d) Can be massive with over 200 pages of very explicit plans and directions e) Can generally be written in three pages or less

c) Often have 20 to 30 pages

The goal of acceptance testing is: a) That modules and units work together with each other b) That the databases are properly organized for both efficiency in storage and access c) To confirm that the system is complete and meets the business needs d) That both black-box and white-box tests have been approved by upper management e) To verify that the use-cases, ERDs and DFD's have been properly converted

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

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(n) _____. a) conditional line b) connector c) control couple d) data couple e) loop

c) control couple

Every part of a system that is not automated will: a) Be ignored in the implementation of the system b) Be drawn as only logical DFDs not physical DFDs c) Be outside the human-machine boundary d) Go back through the analysis phase to become automated e) Will be drawn as diamond shapes on the structure charts

c)Be outside the human-machine boundary

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. a) "By-passes" b) "Temporary Modules" c) "Placeholder Modules" d) "Stub Modules" e) "End Modules"

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

When you are updating the data elements in the data flows (when creating a physical DFD) you might need to: a) Return to users to interview them about the physical data flows b) Update the original cost/benefit analysis to reflect the physical storage c) Do a technology analysis d) Add physical data elements to the metadata descriptions in the CASE repository e) Do formal benchmarking of the data flows

d) Add physical data elements to the metadata descriptions in the CASE repository

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

. A program is not considered finished until: a) It has been used successfully for six months b) The cost of developing the program 'breaks-even' with the benefits of the program c) The ROI is positive d) It has passed its testing e) It 'dies' and is replaced by a newer version

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

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

The two fundamental documentation types are: a) System documentation and integration documentation b) Screen documentation and batch documentation c) User documentation and online documentation d) System documentation and user documentation e) Acceptance documentation and integration documentation

d) System documentation and user documentation

System tests are usually conducted by: a) Programmers (developers) b) Project managers c) Users d) Systems analysts e) Project sponsors or project champions

d) Systems analysts

Beth is considering a simple process for immediate orders. When processing an immediate order, a phone clerk writes the order on a paper form. Which of the following might be a reason NOT to automate this process? a) The clerk could make errors when writing the information wrong on the paper form b) The paper form could be lost when sent to the order filling /shipping area c) The writing on the paper form could be hard to decipher d) The costs to automate might be significantly higher than doing it manually e) The time to get the paper form from the clerk's desk to the order filling / shipping area is one day or longer

d) The costs to automate might be significantly higher than doing it manually

Which is NOT true of Structure Charts when designing programs? a) They show all the components of code that must be included in a program at a high level b) They are arranged in a hierarchical format that implies sequence c) They help analysts create programs that are easy to understand and maintain d) They are generally implemented with control flags that pass from the control modules to the subordinate modules e) They may have on-page and off-page connectors

d) They are generally implemented with control flags that pass from the control modules to the subordinate modules

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

The largest single component of any systems development project in terms of both time and cost could be: a) Conducting JAD sessions b) Gamma testing c) Developing the user interface d) Writing programs e) Having meetings

d) Writing programs

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

Processes from logical DFDs might show up on a physical data flow diagram as: a) Tables in a database b) External entities c) Outside the human-machine boundary d) Audit log files e) HTML screens or Visual Basic forms

e) HTML screens or Visual Basic forms

21. Black-box testing: a) Is reserved for special circumstances in which the tester wants to review the actual program code b) Is reserved for NASA space missions c) Is reserved for very complex systems d) Is only used by highly skilled testers e) None of these

e) None of these

During the implementation phase of the SDLC: a) Analysts will write programs b) Programmers will develop user interfaces c) Project managers will convert logical ERDs into physical DFDs d) Champions will do the data management design e) None of these

e) None of these

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? a) Under $50,000 b) From $50,000 to $99,999 c) From $100,000 to $249,999 d) From $250,000 to $500,000 e) Over $500,000

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

This particular type of documentation control lists the information in a logical form, as though the users were to read the reference documentation from start to finish: a) Index b) Text search c) Content sensitive help d) Intelligence agents e) Table of contents

e) Table of contents

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

The fourth step in creating a physical DFD (data flow diagram) is a) update the metadata in the CASE repository b) draw a human-machine boundary c) add implementation references d) add system-related data stores, data flows, and processes e) update the data elements in the data flows

e) update the data elements in the data flows