ITS THE THING
1) Project identification and selection is also known as ________. A) A preproject step B) The Project ID C) The first step D) Project selection
A
12) On what basis are objects referenced, selected, qualified, sorted, and categorized? A) Attributes and secondary keys B) Entities C) Primary keys D) Index
A
17) An entity ________ is a single occurrence of an entity type. A) Instance B) Object C) Attribute D) Class
A
20) Event entity types should be named for the result of the ________, not the activity or process of the event. A) Event B) Class C) Entity D) Object
A
47) ________ need to be managed in order to be minimized. A) Risks B) ROIs C) Employees D) Estimates
A
48) Which of the following is NOT a potential consequence of not managing risks? A) Unqualified project management B) Inaccurate duration times C) Failure to achieve appropriate system performance levels D) Inaccurate cost estimates.
A
5) ________ is the process of defining clear activities necessary to complete activities in a single project. A) Project planning B) Project initiation C) Baseline D) Business case
A
54) Which type of project should companies not have too many of? A) High risk B) High cost C) Huge staff D) Unknown technical environment
A
61) The ________ rule specifies that an entity instance of the super type does not have to belong to any subtype. A) Total specialization B) Partial specialization C) Overlap D) Disjoint
B
66) The ________ rule specifies that an entity instance can simultaneously be a member of two (or more) subtypes. A) Business B) Overlap C) Disjoint D) Total specialization
B
72) Which business rule specifies rules concerning the relationships between entity types? A) Triggering operations B) Referential integrity constraints C) Entity integrity D) Domains
B
75) A(n) ________ is a concise statement of the business rule to be enforced by the triggering operation. A) Event B) User rule C) Action D) Condition
B
77) There is/are ________ principal type(s) of packaged data model(s). A) One B) Two C) Three D) Five
B
63) The ________ rule specifies that if an entity instance of the super type is a member of one subtype, it cannot simultaneously be a member of any other subtype. A) Business B) Overlap C) Disjoint D) Partial specialization
C
69) Which business rule specifies that each instance of an entity type must have a unique identifier that is not null? A) Triggering operations B) Referential integrity C) Entity integrity D) Domains
C
7) Which of the following is NOT a part of project initiation? A) Create the project initiation team B) Establish management procedures C) Create a project budget D) Develop the project charter
C
84) The term ________ data model means a conceptual data model with some additional properties associated with the most popular type of database technology like relational databases. A) Universal B) Physical C) Logical D) Industry-specific
C
4) Why is PIP challenging? A) Because it is expensive B) Because only systems analysts participate in the process C) Because it is a closed-ended process D) Because it turns a vague system request into a project description
D
41) Which term below means that money available today is worth more than the same amount tomorrow? A) Cost benefit B) Discount rate C) Variable costs D) Time value of money
D
57) Which type of feasibility deals with project duration? A) Political feasibility B) Contract feasibility C) Time feasibility D) Schedule feasibility
D
60) A ________ is an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other sub-groupings. A) Repeating group B) Multi-valued C) Super-type D) Subtype
D
89) The ________ shows the static structure of an object-oriented model: the object classes, their internal structure, and the relationships in which they participate. A) Data model B) Object class C) Object diagram D) Class diagram
D
92) 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
18) An entity ________ is described just once in a data model, whereas many ________ of that may be represented by data stored in the database. A) Type: instances B) Type: classes C) Instance: types D) Class: objects
A
22) Similar attributes of different entity types should use ________ but distinguishing names. A) Similar B) Different C) Unique D) Duplicate
A
24) 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
28) 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
3) 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. A) Conceptual B) Physical C) Logical D) Entity
A
30) What makes all projects feasible? A) Unlimited resource and infinite time B) Limited scope C) A great budget D) A highly skilled project team
A
31) A unary relationship is a relationship between the instances of ________ entity type(s). A) One B) Two C) Three D) Five
A
34) All of the following are tangible benefits except ________. A) Decreased flexibility B) Cost reduction C) Increased speed of activity D) Improvement of management planning
A
35) The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A. A) Cardinality B) Relationship C) Identifier D) Association
A
35) Which of the following is an example of a tangible benefit? A) Error reduction in data entry B) Improvement of employee morale C) Faster decision making D) Positive impacts on society
A
42) ________ is/are the rate at which money can be borrowed. A) Cost of capital B) Present value C) Fixed costs D) Time value of money
A
50) Which of the following is NOT a way to manage project risks? A) Changing the budget B) Changing the project plan C) Carefully assigning project team members D) Set up monitoring methods
A
67) ________ rules are specifications that preserve the integrity of the logical data model. A) Business B) Disjoint C) Overlap D) Total specialization
A
70) Which business rule specifies the validity of attribute values? A) Triggering operations B) Referential integrity C) Entity integrity D) Domains
A
76) A(n) ________ is the data manipulation operation (insert, delete, or update) that initiates the operation. A) Event B) User rule C) Action D) Condition
A
85) Which benefit of purchased data models refers to the fact that they are very general, covering almost all options employed by the associated functional area or industry? A) Consistent and complete B) Validated C) Cost reduction D) Facilitates systems analysis
A
88) The ________ of an object encompasses its properties (attributes and relationships) and the values of those properties. A) State B) Condition C) Behavior D) Event
A
9) All of the following are part of project planning except ________. A) Organizing the team B) Creating a resource plan C) Identifying risk D) Developing the project scope
A
94) A(n) ________ class is a class that has no direct instances but whose descendants may have direct instances. A) Abstract B) Concrete C) Object D) Associative
A
10) What of the following is NOT a purpose for a baseline project plan? A) Resources are more quantifiable B) Eliminate risks C) Decide if a project should be rejected D) A depository for information collected during initiation
B
11) What unique characteristic(s) distinguish(es) each object from other objects of the same type? A) Secondary key B) Primary key C) Composite key D) Index
B
15) An entity ________ is a collection of entities that share common properties or characteristics. A) Object B) Type C) Subject D) Relationship
B
19) 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
2) Which of the following is NOT a question asked to determine if project initiation and planning has ended and analysis has begun? A) What kind of effort should be expended on PIP? B) Who is going to pay for PIP? C) Who is responsible for performing PIP? D) Why is PIP so challenging?
B
27) A(n) ________ is an attribute that has meaningful component parts. A) Optional attribute B) Composite attribute C) Required attribute D) Derived attribute
B
30) The ________ of a relationship is the number of entity types that participate in that relationship. A) Object B) Degree C) Identifier D) Measure
B
31) All of the following are categories of feasibility except ________. A) Technical B) Scope C) Scheduling D) Political
B
33) A ________ relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling. A) Secondary B) Binary C) Primary D) Ternary
B
36) 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. A) Relationship B) Associative entity C) Identifier D) Cardinality
B
39) A new hardware purchase is classified as a(n) ________. A) Tangible benefit B) One-time cost C) Fixed cost D) IS fee
B
43) Which option identifies the point at which benefits equal costs? A) Net present value B) Break-even analysis C) Time value of money D) Present value
B
44) Which of the following is NOT an example of an economic cost-benefit analysis technique? A) Net present value B) Time value of money C) Return on investment D) Break-even analysis
B
51) Which of the following is NOT an example of a project risk assessment factor? A) Project duration time B) Customer's commitment to system C) Familiarity with other systems D) Organizational personnel changes resulting from system
B
56) Which feasibility is concerned with the project attaining its desired objectives? A) Technical feasibility B) Operational feasibility C) Schedule feasibility D) Legal feasibility
B
6) What is an example of a project assumption? A) Size B) Potential problems C) Scope D) Complexity
B
87) A(n) ________ has a well-defined role in the application domain, and it has state (data), behavior, and identity characteristics. A) Event B) Object C) Activity D) Class
B
91) The ________ is the technique of hiding the internal implementation details of an object from its external view. A) Query operation B) Encapsulation C) Constructor operation D) Update operation
B
93) 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
96) A part-of relationship in which parts belong to only one whole object, and the parts live and die with the whole object is called ________. A) Method B) Composition C) Aggregation D) Polymorphism
B
73) A domain is the set of all data types and ranges of values that ________ may assume. A) Entities B) Instances C) Attributes D) Events
C
11) Which document outlines all work required to complete the project? A) Baseline project plan B) Business plan C) Project scope document D) Feasibility document
C
13) An ________ model is a detailed, logical representation of the entities, associations, and data elements for an organization or business area. A) E-D B) E-O C) E-R D) E-A
C
16) Each entity type in an E-R model is given a ________ because it represents a class or set, it is singular. A) Class B) Type C) Name D) Degree
C
2) During requirements structuring, a ________ model represents conceptual data requirements for a particular system. A) Business B) Project C) Data D) Relationship
C
23) A ________ key is an attribute (or combination of attributes) that uniquely identifies each instance of an entity type. A) Primary B) Unique C) Candidate D) Duplicate
C
25) 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
29) A(n) ________ is an association between the instances of one or more entity types that is of interest to the organization. A) Attribute B) Repeating group C) Relationship D) Identifier
C
3) Who is typically responsible for performing the PIP process? A) Managers B) Users C) Systems analyst D) The business unit
C
32) Which feasibility category deals with identifying financial benefits associated with the project? A) Political B) Legal C) Economic D) Technical
C
34) A ternary relationship is a simultaneous relationship among instances of ________ entity type(s). A) One B) Two C) Three D) Ten
C
36) Which of the following is an example of an intangible cost? A) Hardware costs B) Labor costs C) Customer goodwill D) Employee training
C
38) Which of the following is NOT a guideline for better cost estimation? A) Have clear guidelines for creating estimates B) Use experienced developers C) Update estimates at the end of the project D) Use historical data
C
40) Which of the following is NOT an example of a recurring cost? A) Software maintenance B) Data storage expenses C) System conversion D) Hardware leases
C
45) Which of the options below means the organization has the ability to build the requested system? A) Economic feasibility B) Return on investment C) Technical Feasibility D) Break-even point
C
52) Which of the following is a less risky approach to the technical parts of a project? A) User involvement B) Using a matrix C) Using standard technology D) Having a well-equipped IT staff
C
90) The ________ is a logical grouping of objects that have the same (or similar) attributes, relationships, and behaviors: also called class. A) Operation B) Encapsulation C) Object class D) Object diagram
C
97) The fact that the same operation may apply to two or more classes in different ways is known as ________. A) Aggregation B) Abstract operation C) Polymorphism D) Composition
C
29) A Project Scope Statement can be used to ________. A) Detail project estimates B) Outline a schedule C) Prepare the project for the analysis phase D) Serve as a contract
D
1) The most common format used for data modeling is ________ diagramming. A) Entity-class B) Entity-object C) Entity-subject D) Entity-relationship
D
14) A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data. A) Dimension B) Attribute C) Object D) Entity
D
21) A(n) ________ is a named property or characteristic of an entity that is of interest to the organization. A) Event B) Instance C) Relationship D) Attribute
D
26) A(n) ________ is an attribute that may not have a value forevery entity instance. A) Required attribute B) Derived attribute C) Composite attribute D) Optional attribute
D
32) A recursive relationship is also known as a ________ relationship. A) Binary B) Ternary C) Secondary D) Unary
D
33) A(n) ________ comes from an information system that can be measured monetarily. A) Project benefit B) Economic feasibility C) Project plan D) Tangible benefit
D
37) Which of the following is an example of a procurement IS cost? A) System maintenance B) User training C) Personal recruiting D) Organizational disruptions
D
46) Which of the following is NOT a consideration during the assessing technical feasibility stage? A) System size B) System complexity C) System target hardware D) System cost
D
49) Failure to integrate the new system with the old system is an example of ________. A) A poor break even analysis B) Failure to create an adequate project scope statement C) Failure to recognize tangible benefits D) Failure to assess and manage risks
D
53) Each organization has to decide its acceptable project mix of ________. A) Costs B) Personnel C) Requirements D) Risks
D
55) The following is NOT an example of a type of feasibility study. A) Operational feasibility B) Technical feasibility C) Economic feasibility D) Resource feasibility
D
62) The ________ rule specifies that each entity instance of the super-type must be a member of some subtype of the relationship. A) Partial specialization B) Business C) Overlap D) Total specialization
D
68) How many types of business rules are there in conceptual data modeling? A) One B) Two C) Three D) Four
D
71) Which business rule specifies constraints on valid values for attributes? A) Triggering operations B) Referential integrity C) Entity integrity D) Domains
D
74) A(n) ________ is an assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete. A) Domain B) Event C) Referential integrity D) Triggering operation
D
8) What is the term that describes the best estimate of a project's scope, benefits, cost, and resources? A) Management procedure B) Project charter C) Resource plan D) Baseline project plan
D
83) ________ data models are generic data models that are designed to be used by organizations within specific industries. A) Universal B) Conceptual C) Logical D) Industry-specific
D
86) Which benefit of purchased data models provides database planning and analysis by providing a first data model, which we can use to generate specific analysis questions and concrete, not hypothetical or abstract, examples of what might be in the appropriate database? A) Validated B) Consistent and complete C) Cost reduction D) Facilitates systems analysis
D
95) A class that can have direct instances (e.g., Outpatient or Resident Patient) is called a(n) ________ class. A) Object B) Abstract C) Associative D) Concrete
D
