Question 1

eXtreme Programming:

Accepted Answer

A)  is distinguished by its short development cycles. 
B)  focuses on automated tests written by programmers and customers to monitor the process of development. 
C)  uses two-person programming teams. 
D)  has a customer on-site during the development process. 
E)  does all of the above. 
A)  is distinguished by its short development cycles. 
B)  focuses on automated tests written by programmers and customers to monitor the process of development. 
C)  uses two-person programming teams. 
D)  has a customer on-site during the development process. 
E)  does all of the above.

Question 2

eXtreme Programming is distinguished by its long development cycles and predictive planning approach.

Accepted Answer

A) True 
 B)False

Question 3

On a class diagram, an association between object classes is signified by a double-ended arrow that connects the two object classes.

Accepted Answer

A) True 
 B)False

Question 4

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

Accepted Answer

A)  secondary key. 
B)  recursive foreign key. 
C)  composite key. 
D)  complex key. 
E)  concatenated key. 
A)  secondary key. 
B)  recursive foreign key. 
C)  composite key. 
D)  complex key. 
E)  concatenated key.

Question 5

An aggregation expresses a part-of relationship between a component object and an aggregate object.

Accepted Answer

A) True 
 B)False

Question 6

Data security can be built into a file through encryption, passwords, or prohibiting users from directly manipulating a file.

Accepted Answer

A) True 
 B)False

Question 7

A data marker is a field of data that can be used to locate a related field or row of data.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following would the Agile Software Development anarchists place more value on?

Accepted Answer

A)  Individuals and interactions 
B)  Contract negotiations 
C)  Following a plan 
D)  Comprehensive documentation 
E)  Team member roles 
A)  Individuals and interactions 
B)  Contract negotiations 
C)  Following a plan 
D)  Comprehensive documentation 
E)  Team member roles

Question 9

Each regular entity type in an E-R diagram is transformed into a:

Accepted Answer

A)  row in a relation. 
B)  column in a relation. 
C)  relation. 
D)  tuple in a relation. 
E)  database. 
A)  row in a relation. 
B)  column in a relation. 
C)  relation. 
D)  tuple in a relation. 
E)  database.

Question 10

Which of the following shows the time period during which an object performs an operation, either directly or through a call to some subordinate operation?

Accepted Answer

A)  Asynchronous message 
B)  Activation 
C)  Critical path 
D)  Simple message 
E)  Component diagram 
A)  Asynchronous message 
B)  Activation 
C)  Critical path 
D)  Simple message 
E)  Component diagram

Question 11

View integration is the last step of logical database design.

Accepted Answer

A) True 
 B)False

Question 12

Assume the structure of a relation is Employee (EmpID, Name, Dept, Salary). The number of attributes for this relation would:

Accepted Answer

A)  be three. 
B)  be four. 
C)  be five. 
D)  be six. 
E)  vary depending upon the number of employees. 
A)  be three. 
B)  be four. 
C)  be five. 
D)  be six. 
E)  vary depending upon the number of employees.

Question 13

A concrete class is a class that has no direct instances, but whose descendants may have direct instances.

Accepted Answer

A) True 
 B)False

Question 14

For any relation R, if, for every valid instance of A, that value of A uniquely determines the value of B:

Accepted Answer

A)  then a primary dependency exists in the relation. 
B)  then A is said to be functionally dependent on B. 
C)  then B is said to be functionally dependent on A. 
D)  then A and B are candidate keys for the relation. 
E)  None of the above are True. 
A)  then a primary dependency exists in the relation. 
B)  then A is said to be functionally dependent on B. 
C)  then B is said to be functionally dependent on A. 
D)  then A and B are candidate keys for the relation. 
E)  None of the above are True.

Question 15

The process of converting complex data structures into simple, stable data structures is referred to as:

Accepted Answer

A)  normalization. 
B)  simplification. 
C)  structuring. 
D)  process modeling. 
E)  relational conversion. 
A)  normalization. 
B)  simplification. 
C)  structuring. 
D)  process modeling. 
E)  relational conversion.

Question 16

According to the Agile Software Development Manifesto, the most efficient and effective method of conveying information to and within a development team is face-to-face conversation.

Accepted Answer

A) True 
 B)False

Question 17

Multiplicity level is an indication of how many objects participate in a given relationship.

Accepted Answer

A) True 
 B)False

Question 18

When using the sequential file organization, the addition of rows requires rewriting the file.

Accepted Answer

A) True 
 B)False

Question 19

During the Iteration Planning Game, programmers prepare:

Accepted Answer

A)  Task Cards. 
B)  Story Cards. 
C)  Pseudocode Cards. 
D)  Structured English. 
E)  Structure Charts. 
A)  Task Cards. 
B)  Story Cards. 
C)  Pseudocode Cards. 
D)  Structured English. 
E)  Structure Charts.

Question 20

According to the Agile Software Development Manifesto, continuous attention to technical excellence and good design enhances agility.

Accepted Answer

A) True 
 B)False

eXtreme Programming:

eXtreme Programming is distinguished by its long development cycles and predictive planning approach.

On a class diagram, an association between object classes is signified by a double-ended arrow that connects the two object classes.

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

An aggregation expresses a part-of relationship between a component object and an aggregate object.

Data security can be built into a file through encryption, passwords, or prohibiting users from directly manipulating a file.

A data marker is a field of data that can be used to locate a related field or row of data.

Which of the following would the Agile Software Development anarchists place more value on?

Each regular entity type in an E-R diagram is transformed into a:

Which of the following shows the time period during which an object performs an operation, either directly or through a call to some subordinate operation?

View integration is the last step of logical database design.

Assume the structure of a relation is Employee (EmpID, Name, Dept, Salary). The number of attributes for this relation would:

A concrete class is a class that has no direct instances, but whose descendants may have direct instances.

For any relation R, if, for every valid instance of A, that value of A uniquely determines the value of B:

The process of converting complex data structures into simple, stable data structures is referred to as:

According to the Agile Software Development Manifesto, the most efficient and effective method of conveying information to and within a development team is face-to-face conversation.

Multiplicity level is an indication of how many objects participate in a given relationship.

When using the sequential file organization, the addition of rows requires rewriting the file.

During the Iteration Planning Game, programmers prepare:

According to the Agile Software Development Manifesto, continuous attention to technical excellence and good design enhances agility.

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Structuring System Requirements: Conceptual Data Modeling

Designing the Human Interface

Systems Implementation and Operation

Filters

Exam 9: Designing Databases

eXtreme Programming:

eXtreme Programming is distinguished by its long development cycles and predictive planning approach.

On a class diagram, an association between object classes is signified by a double-ended arrow that connects the two object classes.

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

An aggregation expresses a part-of relationship between a component object and an aggregate object.

Data security can be built into a file through encryption, passwords, or prohibiting users from directly manipulating a file.

A data marker is a field of data that can be used to locate a related field or row of data.

Which of the following would the Agile Software Development anarchists place more value on?

Each regular entity type in an E-R diagram is transformed into a:

Which of the following shows the time period during which an object performs an operation, either directly or through a call to some subordinate operation?

View integration is the last step of logical database design.

Assume the structure of a relation is Employee (EmpID, Name, Dept, Salary). The number of attributes for this relation would:

A concrete class is a class that has no direct instances, but whose descendants may have direct instances.

For any relation R, if, for every valid instance of A, that value of A uniquely determines the value of B:

The process of converting complex data structures into simple, stable data structures is referred to as:

According to the Agile Software Development Manifesto, the most efficient and effective method of conveying information to and within a development team is face-to-face conversation.

Multiplicity level is an indication of how many objects participate in a given relationship.

When using the sequential file organization, the addition of rows requires rewriting the file.

During the Iteration Planning Game, programmers prepare:

According to the Agile Software Development Manifesto, continuous attention to technical excellence and good design enhances agility.

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Structuring System Requirements: Conceptual Data Modeling

Designing the Human Interface

Systems Implementation and Operation

Filters