compiled questions

Which term describes a systems development project that is plagued with too much analysis work? Analysis Paralysis The Analysis Phase Documentation Reframing

Analysis Paralysis

Compared to traditional coding practices, which of the below is NOT an advantage of pair programming? More (and better) communication among developers Higher levels of productivity Higher-quality code Coding written in silos

Coding written in silos

Each ________ in a relation corresponds to an attribute of that relation. Entity Data Column Row

Column

________ and ________ are the two types of prototypes. New process; old process Long term; short-term Evolutionary; throwaway Throwaway; permanent

Evolutionary; throwaway

With only ________ symbols, you can use DFDs to represent both physical and logical information systems. a. Four b. Three c. Five d. Six

Four

Which of the following is NOT a characteristic of good systems analyst? Impertinence Relax constraints Attention to detail Great at finances

Great at finances

In logical database design, we use a process called ________, which is a way to build a data model that has the properties of simplicity, non-redundancy, and minimal maintenance. Data modeling Database designing De-normalization Normalization

Normalization

A unary relationship is a relationship between the instances of ________ entity type(s). One Two Three Five

One

In a relation, each row is unique and uniqueness is guaranteed because the relation has a non-empty ________ key value. Unique Composite Candidate Primary

Primary

A(n) ________ is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation. Composite key Primary key Identifier Index

Primary key

Each ________ of a relation corresponds to a record that contains data values for an entity. Column Entity Attribute Row

Row

________ are NOT a component of data flow diagram symbols. a. Processes b. Data stores c. Data flows d. Data programs

d. Data programs

A ________ is the origin and/or destination of the data, and these are sometimes referred to as external entities because they are outside the system. a. Data graph b. Data flow c. Process d. Source

d. Source

Which of the following is a situation in which prototyping is useful for requirements determination? a. When formal documentation of system requirements are needed b. When stand-alone systems aren't needed c. When user requirements are clear and well understood d. When tools and data are rapidly available to working systems

d. When tools and data are rapidly available to working systems

A ________ can be best understood as data in motion, moving from one place in a system to another. a. Process b. Data flow c .Data store d. Data source

b. Data flow

A ________ is a picture of the movement of data between external entities and the processes and data stores within a system. a. Process flow diagram b. Data flow diagram c. Data diagram d. Procedure flow diagram

b. Data flow diagram

A(n) ________ is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. Relationship Associative entity Identifier Cardinality

Associative entity

A functional dependency is a particular relationship between two ________. Attributes Rows Databases Tables

Attributes

On what basis are objects referenced, selected, qualified, sorted, and categorized? Attributes and secondary keys Entities Primary keys Index

Attributes and secondary keys

The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A. Cardinality Relationship Identifier Association

Cardinality

The concept of DFD ________ refers to whether you have included in your DFDs all of the components necessary for the system you are modeling. Completeness Accuracy Balancing Processing

Completeness

________ were developed to make systems developers' work easier and more consistent. Data analysis tools Computer-aided software engineering (CASE) tools Software designing tools Modeling tools

Computer-aided software engineering (CASE) tools

A(n) ________ data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations. Conceptual Physical Logical Entity

Conceptual

What information do the objectives cover in an interview guide? A list of issues the analysts have with the current system Information about the interviewer Specific questions on what the analyst wants to confirm Data collection questions

Data collection questions

During logical database design, you must account for every data element on a system input or output form or report and on the ________. E-R diagram Conceptual design Physical design Logical design

E-R diagram

________ are large, complex systems that consist of a series of independent system modules. Supply chain management systems Enterprise-wide systems Customer relationship management systems Transaction processing systems

Enterprise-wide systems

A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data. Dimension Attribute Object Entity

Entity

Event entity types should be named for the result of the ________, not the activity or process of the event. Event Class Entity Object

Event

No process can have only ________ and if an object has only that, then it must be a sink. Inputs Procedure Outputs Arrow

Inputs

An entity ________ is a single occurrence of an entity type. Instance Object Attribute Class

Instance

Which of the following is a primary way to gather information? Interviewing Gather documentation Review procedures Direct observation

Interviewing

Which SDLC phase focuses on the business aspects of the design? Design Physical Logical Analysis

Logical

No process can have only ________. It would be making data from nothing (a miracle). If an object has only outputs, then it must be a source. Sources Sinks Inputs Outputs

Outputs

Logical and ________ database design is typically performed in parallel with other systems design steps. Normal Physical Conceptual Normalized

Physical

In which part of the design phase of the SDLC are the logical specifications of the system from logical design transformed into technology-specific details from which all programming and system construction can be accomplished? Implementation Object modeling Physical design Logical design

Physical design

What is the first phase in the Systems Development Life Cycle? Analysis Design Planning Procedure

Planning

One purpose of database design is to structure the data in stable structures, called normalized tables, that are not likely to change over time and that have minimal ________. Data Space Redundancy Columns

Redundancy

In a ________ database model, data is represented as a set of related tables or relations. Logical Conventional Relational Physical

Relational

A(n) ________ is an association between the instances of one or more entity types that is of interest to the organization. Attribute Repeating group Relationship Identifier

Relationship

All of the following are documents that are helpful in understanding future systems, except ________. Business plans External correspondence Reports from future organizational studies Job descriptions

Reports from future organizational studies

Which of the below is a traditional methodology used to develop, maintain, and replace information systems? Prototyping OOAD RAD SDLC

SDLC

Similar attributes of different entity types should use ________ but distinguishing names. Similar Different Unique Duplicate

Similar

Entries in cells are simple and an entry at the intersection of each row and column has a ________ value. Duplicate Single Multi Repeating

Single

Who has the primary responsibility for the design and analysis of information systems? Systems analyst Software engineer Employees Applications developer

Systems analyst

Most organizations find it beneficial to use a standard set of steps, called ________, to develop and support their information systems. Systems development methodology Supply chain management systems Analytical processing systems Customer relationship management systems

Systems development methodology

A well-structured relation is a relation that contains a minimum amount of redundancy and that allows users to insert, modify, and delete the rows without error or inconsistencies and is also known as a ________. Column Row Table Key

Table

A ternary relationship is a simultaneous relationship among instances of ________ entity type(s). One Two Three Ten

Three

An entity ________ is described just once in a data model, whereas many ________ of that may be represented by data stored in the database. Type; instances Type; classes Instance; types Class; objects

Type; instances

The ________ is a document written to describe how a particular job is performed. System document Work procedure Mission statement Goals document

Work procedure

Why are forms important? a. Because they explain what data flows out of a system b. Because they are documentation c. Because every company uses them d. A form is not important.

a. Because they explain what data flows out of a system

The concept of DFD ________ refers to whether you have included in your DFDs all of the components necessary for the system you are modeling. a. Completeness b. Accuracy c. Balancing d. Processing

a. Completeness

A ________ is a diagram of process logic where the logic is reasonably complicated. a. Decision table b. Decision box c. Decision column d. Decision flow

a. Decision table

A(n) ________ is an attribute whose value can be computed from related attribute values. a. Derived attribute b. Composite attribute c. Required attribute d. Optional attribute

a. Derived attribute

When an organization has the resources and a system must be built from scratch, an organization should choose what type of software? a. In-house development b. Prepackaged software c. Off the shelf d. Open source

a. In-house development

Which of the following is NOT an advantage of a group interview? a. It is a waste of an analyst's time to interview a group b. The interviewees can hear each other's opinions c. Synergy d. It is easier to ascertain the general agreements

a. It is a waste of an analyst's time to interview a group

Which of the following is NOT a feature of eXtreme Programming? a. Long cycles b. Incremental planning approach c. Focus on automated tests written by programmers and customers to monitor the development process d. Reliance on an evolutionary approach to development

a. Long cycles

Which of the following is NOT a source of requirements gathering for the systems analyst? a. Market conditions b. Users of the current system c. Reports d. Procedures

a. Market conditions

A(n) ________ is an attribute that may take on more than one value for each entity instance. a. Multi-valued attribute b. Single-valued attribute c. Identifier d. Candidate key

a. Multi-valued attribute

____________________ current system users is a more direct way of seeing how an existing system operates. a. Observing b. Asking c. Polling d. Surveying

a. Observing

Which of the following is NOT a major category of sources of software? a. Offshore b. Cloud computing vendors c. In-house developers d. Package software

a. Offshore

A ________ is the work or actions performed on data so that they are transformed, stored, or distributed. a. Process b. Data store c. Flowchart d. Data flow

a. Process

A ________ is a business document that contains only predefined data; it is a passive document used solely for reading or viewing. a. Report b. Form c. Flowchart d. Word document

a. Report

Which firm is best known for its ERP software solution? a. SAP AG b. Oracle c. Microsoft d. Google

a. SAP AG

Which of the following is a new, faster, and more flexible technique for analysis gathering requirements? a. The Planning Game b. Observing Users c. Procedures d. Users

a. The Planning Game

A relation is a named, ________-dimensional table of data. Each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows. a. Two b. One c. Three d. Four

a. Two

When considering off-the-shelf software, which choice is one of the most important criteria to consider? a. Vendor support b. Cost c. Flexibility d. Response time

a. Vendor support

Which of the following is an example of an open ended question? a. What is the main issue with the current computer system? b. What unit are sales currently shown in? c. Do you participate in flextime? d. When was the last time the system malfunctioned?

a. What is the main issue with the current computer system?

An effective way to gather information about the system from users is ________. a. Taking Internet surveys b. Asking them questions c. Reading corporate memos d. Reading redesign documents

b. Asking them questions

A binary one-to-many (1:N) relationship in an E-R diagram is represented by adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a(n) ________ in the relation that is on the many side of the relationship. a. Primary key b. Foreign key c. Unique key d. Index

b. Foreign key

In logical database modeling and design, we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________. a. Summation b. Integration c. Addition d. Combination

b. Integration

________ DFD development recognizes that requirements determination and requirements structuring are interacting, not sequential, subphases of the analysis phase of the SDLC. a. Primitive b. Iterative c. Subjective d. Consistent

b. Iterative

A ________ is a DFD that represents a system's major processes, data flows, and data stores at a high level of detail. a. Level-1 diagram b. Level-0 diagram c. Level-2 diagram d. Level-3 diagram

b. Level-0 diagram

At the ________ level of DFDs, new data flows may be added to represent data that are transmitted under exceptional conditions. These data flows typically represent error messages or confirmation notices. a. Highest b. Lowest c. Basic d. Medium

b. Lowest

A(n) ________ is a specification that indicates how many objects participate in a given relationship. a. Association role b. Multiplicity c. Association d. Object class

b. Multiplicity

________ is a process for converting complex data structures into simple, stable data structures. a. De-normalization b. Normalization c. Database modeling d. Relation

b. Normalization

The lowest level of a DFD is called a ________ data flow diagram. a. Low-level b. Primitive c. Level-0 d. Basic

b. Primitive

Which tool enables you to quickly take basic requirements and create a limited working system? a. CASE tools b. Prototyping c. User manual d. JAD

b. Prototyping

A common mistake many people make when they are just learning to draw E-R diagrams, especially if they already know how to do data flow diagramming, is to confuse data entities with ________ and relationships with data flows. a. Classes b. Sinks c. Relationships d. Attributes

b. Sinks

What is the purpose of gathering system records? a. To watch employee behavior for wrong doing b. To gain an objective view of what an employee is doing c. To match what the employee claims he does to what he is actually does d. To have accurate information for a performance review

b. To gain an objective view of what an employee is doing

What is primary purpose of JAD? a. To diagram forms and report generation b. To gather systems requirements simultaneously c. To create a prototype d. To assist with business process reengineering

b. To gather systems requirements simultaneously

Which relation is created by placing the primary key of either entity in the relation for the other entity or by doing this for both entities? a. Binary 1:N relationship b. Unary 1:1 relationship c. Weak entity d. Associative entity with additional key

b. Unary 1:1 relationship

According to the DFD conventions, the data flow is always depicted by a(n) ________. a. Rectangle b. Circle c. Arrow d. Triangle

c. Arrow

________ is NOT a phase in a systems development life cycle. a. Maintenance b. Planning c. Attributes d. Design

c. Attributes

What is the end result of JAD? a. A flowchart b. A CASE diagram c. Detailed documents of the current system d. A list of issues that need to be resolved

c. Detailed documents of the current system

Which of the following is NOT a form of closed-ended questions? a. True/False b. Multiple Choice c. Essay d. Ranking

c. Essay

Balancing is the conservation of inputs and outputs to a DFD process when that process is decomposed to a ________ level. a. Balanced b. Similar c. Lower d. Higher

c. Lower

Intuit's QuickBooks is an example of what type of software? a. ERP software b. In-house software c. Pre-packaged software d. Open source software

c. Pre-packaged software

A(n) ________ is an attribute that must have a value forevery entity instance. a. Derived attribute b. Composite attribute c. Required attribute d. Optional attribute

c. Required attribute

Which of the follow is NOT a part of the guidelines for effective interviewing? a. Prime questions b. Listen carefully c. Review notes within 96 hours of interview d. Be neutral

c. Review notes within 96 hours of interview

Which of the below is a true statement regarding the systems development life cycle? a. The SDLC is not iterative. b. It is not possible to complete some activities in one phase in parallel with those of another phase. c. The life cycle can be thought of as a circular process in which the end of the useful life of one system leads to the beginning of another project to develop a new version of or replace an existing system. d. The life cycle can be thought of as a linear process in which the end of the useful life of one system leads to the beginning of another project to develop a new version of or replace an existing system.

c. The life cycle can be thought of as a circular process in which the end of the useful life of one system leads to the beginning of another project to develop a new version of or replace an existing system.

"Notifying users when on the last page of a multi-paged sequence" is related to ________ for the design of forms and reports. a. Meaningful titles b. Meaningful information c. A balanced layout d. An easy navigation system

d. An easy navigation system

The most common format used for data modeling is ________ diagramming. a. Entity-class b. Entity-object c. Entity-subject d. Entity-relationship

d. Entity-relationship

________ is/are NOT a deliverable for process modeling. a. Context DFD b. DFDs of the system c. Thorough descriptions of each DFD component d. Inadequately decomposed diagrams

d. Inadequately decomposed diagrams

The result of normalization is that every ________ key attribute depends upon the whole primary key. a. Candidate b. Unique c .. Primary d. Non-primary

d. Non-primary

Where are JAD sessions normally held? a. At the corporate office b. In the meeting room c. In an executive's office d. Offsite

d. Offsite

Each entity type in the E-R diagram becomes a relation. The identifier of the entity type becomes the ________ of the relation, and other attributes of the entity type become non-primary key attributes of the relation. a. Foreign key b. Index c. Unique key d. Primary key

d. Primary key

A(n) ________ is an operation that does not have any side effects; it accesses the state of an object but does not alter the state. a. Encapsulation b. Constructor operation c. Update operation d. Query operation

d. Query operation

Which of the following is NOT a way informal systems develop? a. Individual work habits b. Resistance to control c. Inadequate formal procedures d. Top management does not mandate it

d. Top management does not mandate it

A recursive relationship is also known as a ________ relationship. a. Binary b. Ternary c. Secondary d. Unary

d. Unary