IT 261 Final UPDATED ACTUAL
Questions and CORRECT Answers
An acronym for Create, Read/Report, Update, and Delete; a technique to validate or refine
use cases - CORRECT ANSWER✔✔- CRUD technique
A unique set of internal activities within a use case - CORRECT ANSWER✔✔- Scenarios or
use case instance
A textual model that lists and describes the processing details for a use case. - CORRECT
ANSWER✔✔- use case description
Notation on a sequence diagram showing optional messages. - CORRECT ANSWER✔✔-
opt frame
The vertical line under an object on a sequence diagram to show the passage of time for the
project. - CORRECT ANSWER✔✔- lifeline or object lifeline
Part of a message between objects that is evaluated prior to transmission to determine
whether the message can be sent. - CORRECT ANSWER✔✔- True/false condition
A query language used to access and update the data in a relational database is called _____. -
CORRECT ANSWER✔✔- SQL
A table is in 2NF and that no non-key attribute is functionally dependent on any other non-
key attribute satisfies the ___ - CORRECT ANSWER✔✔- third normal form (3NF)
A(n) _________ is the key chosen by a database designer to define relationships by being
used as a foreign key in other tables. - CORRECT ANSWER✔✔- primary key
____ is an integrated collection of stored data that is centrally managed and controlled. -
CORRECT ANSWER✔✔- database
, Two-dimensional data structures consisting of columns and rows are called ____. -
CORRECT ANSWER✔✔- Tables
The value held in a single table cell is called a(n)____. - CORRECT ANSWER✔✔- attribute
value
A database component that contains descriptive information about the data stored in the
physical data store is referred to as a(n) ____. - CORRECT ANSWER✔✔- schema
_______ imposes a restriction that a table is in 1NF and that each non-key attribute is
functionally dependent on the entire primary key. - CORRECT ANSWER✔✔- Second
normal form (2NF)
An attribute or set of attributes that are unique identifiers and could serve as the primary key
is called a(n)_____. - CORRECT ANSWER✔✔- Candidate Key
A method that is associated with a class instead of with objects of the class is called ____. -
CORRECT ANSWER✔✔- class-level method
A way of categorizing a model element by its characteristics, indicated by guillemets (<< >>)
is called ____. - CORRECT ANSWER✔✔- stereotype
____ is the process to identify the set of classes, their methods, and their messages required to
execute a use case. - CORRECT ANSWER✔✔- Object-oriented design
A design principle in which an intermediate class is placed between two classes to decouple
them but still link them is called ___. - CORRECT ANSWER✔✔- indirection
A representation of the period during which a method of an object is alive and executing is
called ____. - CORRECT ANSWER✔✔- activation lifeline
___ is a relationship between packages, classes, or use cases in which a change in the
independent item requires a change in the dependent item. - CORRECT ANSWER✔✔-
Dependency relationship
Questions and CORRECT Answers
An acronym for Create, Read/Report, Update, and Delete; a technique to validate or refine
use cases - CORRECT ANSWER✔✔- CRUD technique
A unique set of internal activities within a use case - CORRECT ANSWER✔✔- Scenarios or
use case instance
A textual model that lists and describes the processing details for a use case. - CORRECT
ANSWER✔✔- use case description
Notation on a sequence diagram showing optional messages. - CORRECT ANSWER✔✔-
opt frame
The vertical line under an object on a sequence diagram to show the passage of time for the
project. - CORRECT ANSWER✔✔- lifeline or object lifeline
Part of a message between objects that is evaluated prior to transmission to determine
whether the message can be sent. - CORRECT ANSWER✔✔- True/false condition
A query language used to access and update the data in a relational database is called _____. -
CORRECT ANSWER✔✔- SQL
A table is in 2NF and that no non-key attribute is functionally dependent on any other non-
key attribute satisfies the ___ - CORRECT ANSWER✔✔- third normal form (3NF)
A(n) _________ is the key chosen by a database designer to define relationships by being
used as a foreign key in other tables. - CORRECT ANSWER✔✔- primary key
____ is an integrated collection of stored data that is centrally managed and controlled. -
CORRECT ANSWER✔✔- database
, Two-dimensional data structures consisting of columns and rows are called ____. -
CORRECT ANSWER✔✔- Tables
The value held in a single table cell is called a(n)____. - CORRECT ANSWER✔✔- attribute
value
A database component that contains descriptive information about the data stored in the
physical data store is referred to as a(n) ____. - CORRECT ANSWER✔✔- schema
_______ imposes a restriction that a table is in 1NF and that each non-key attribute is
functionally dependent on the entire primary key. - CORRECT ANSWER✔✔- Second
normal form (2NF)
An attribute or set of attributes that are unique identifiers and could serve as the primary key
is called a(n)_____. - CORRECT ANSWER✔✔- Candidate Key
A method that is associated with a class instead of with objects of the class is called ____. -
CORRECT ANSWER✔✔- class-level method
A way of categorizing a model element by its characteristics, indicated by guillemets (<< >>)
is called ____. - CORRECT ANSWER✔✔- stereotype
____ is the process to identify the set of classes, their methods, and their messages required to
execute a use case. - CORRECT ANSWER✔✔- Object-oriented design
A design principle in which an intermediate class is placed between two classes to decouple
them but still link them is called ___. - CORRECT ANSWER✔✔- indirection
A representation of the period during which a method of an object is alive and executing is
called ____. - CORRECT ANSWER✔✔- activation lifeline
___ is a relationship between packages, classes, or use cases in which a change in the
independent item requires a change in the dependent item. - CORRECT ANSWER✔✔-
Dependency relationship
