Question
Question 1
1 out of 1 points
Using lists to break information into manageable pieces conforms to the SOS guideline of:
organize
shortcuts
organize
simplicity
show
Question 2
1 out of 1 points
Two different names that refer to the same data item best defines:
synonym
homonym
synonym
transitive dependency
alias
Question 3
1 out of 1 points
The set of all data types and ranges of values that an attribute can assume defines:
domain
cardinality
constraint set
domain
reference set
Question 4
1 out of 1 points
Which of the following is not a true statement regarding data flows?
A data flow can go directly back to the same process it leaves.
A fork in a data flow means that exactly the same data goes from a common location to two or more different processes, data stores, or sources/sinks.
A data flow can go directly back to the same process it leaves.
A data flow has a noun phrase label.
A data flow has only one direction of flow between symbols.
Question 5
1 out of 1 points
A named property or characteristic of an entity that is of interest to the organization defines:
attribute
relationship
instance
gerund
Question 6
1 out of 1 points
Which of the following is not a true statement regarding a relation?
Each row in a relation corresponds to an attribute of that relation.
Each relation consists of a set of named columns and an arbitrary number of unnamed rows.
Each column in a relation corresponds to an attribute of that relation.
An entry at the intersection of each row and column has a single value.
Each row in a relation corresponds to an attribute of that relation.
Question 7
1 out of 1 points
A table used to determine the location of rows in a file that satisfy some condition best describes:
index
relation
structure chart
index
domain table
Question 8
1 out of 1 points
A method that helps you to better understand how a system fits within existing business activities and data best defines:
system granularity
context development
integration depth
organizational breadth
Question 9
1 out of 1 points
Recording a customer's payment is represented on a data flow diagram as a:
process
source
data flow
data store
Question 10
1 out of 1 points
The guideline specifying that dialogues be logically grouped and have a beginning, middle, and end is:
closure
shortcuts and sequence
consistency
control
Question 11
1 out of 1 points
Which of the following is not a rule for structuring data entry fields?
Never justify data entries.
Never require data that is already on-line or that can be computed.
Always provide default values when appropriate.
Never justify data entries.
Always place a caption adjacent to fields.
Question 12
1 out of 1 points
An Internet authoring language that allows designers to create customized tags, enabling the definition, transmission, validation, and interpretation of data between applications best describes:
XML
HTTP
BIND
HTML
XML
Question 13
1 out of 1 points
The process of migrating mainframe applications to personal computers, workstations, and networks is sometimes called:
upsizing
downsizing
downgrading
resizing
Question 14
1 out of 1 points
All of the following are usability characteristics except:
satisfaction
completeness
speed
accuracy
Question 15
1 out of 1 points
Each regular entity type in an E-R diagram is transformed into a:
relation
row in a relation
column in a relation
tuple in a relation
Question 16
1 out of 1 points
Process, logic, and data model descriptions of a system must be consistent and complete because:
they each describe different but complementary views of the same information system
they are prepared during the analysis phase
they are constructed in parallel by separate analyst teams
programming tasks require the integration of the information contained in the diagrams
Question 17
0 out of 1 points
A computer-based file containing employee information is represented on a data flow diagram as a:
data flow
source
data store
process
Question 18
1 out of 1 points
Providing Internet content to users based upon knowledge of that customer best describes:
personalization
micromarketing
personalization
customization
profiling
Question 19
1 out of 1 points
The most widely used interface method is:
menu interaction
object-based interaction
natural language interaction
menu interaction
command language interaction
Question 20
1 out of 1 points
Grouping related options together and requiring the same option to have the same wording and codes each time it appears refers to the:
organization guideline for menu design
wording guideline for menu design
selection guideline for menu design
organization guideline for menu design
highlighting guideline for menu design
Question 21
1 out of 1 points
Which of the following combines range and hash partitioning by first segregating data by ranges on the designated attribute and then within each of these partitions it further partitions by hashing on the designated attribute?
composite partitioning
combined partitioning
transitive partitioning
functional partitioning
Question 22
1 out of 1 points
Combining all normalized user views into one consolidated logical database model refers to:
view integration
requirements structuring
view integration
normalization
file integration
Question 23
1 out of 1 points
The extent to which information contained on one level of a set of nested data flow diagrams is also included on other levels refers to:
DFD consistency
DFD completeness
DFD gap proofing
DFD flexibility
Question 24
1 out of 1 points
An assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete is:
triggering operation
entity integrity
referential integrity constraints
domains
Question 25
1 out of 1 points
Which of the following statements regarding the differences between file server and client/server architectures is true?
While software maintenance on the file server architecture is considered low, software maintenance on the client/server architecture is mixed since some new parts must be delivered to each client.
While the file server architecture involves efficient data transfers, the client/server architecture has large file and data transfers.
Servers and clients perform processing in a file server architecture. Only servers perform processing in a client/server architecture.
While database security and integrity on a file server architecture is high, it is low on the client/server architecture.
While software maintenance on the file server architecture is considered low, software maintenance on the client/server architecture is mixed since some new parts must be delivered to each client.
Question 26
1 out of 1 points
A square on a data flow diagram represents a:
data store
data flow
process
source/sink
Question 27
1 out of 1 points
Potentially high usability problems for some applications exist for keyboards in all of the following areas except:
visual blocking
adequate feedback
speed
movement scaling
Question 28
1 out of 1 points
A decision table does not include:
statements
condition stubs
action stubs
rules
Question 29
1 out of 1 points
An indifferent condition is represented by a(n):
dash (-)
dash (-)
asterisk (*)
exclamation point (!)
pound sign (#)
Question 30
1 out of 1 points
When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes:
the primary key of the corresponding relation
the foreign key in the corresponding relation
a nonkey attribute in the corresponding relation
a secondary key in the corresponding relation
Question 31
1 out of 1 points
The diagram that shows the scope of the system, indicating what elements are inside and which are outside the system, is called a:
context diagram
level-2 diagram
referencing diagram
representative diagram
Question 32
1 out of 1 points
The deliverables of process modeling state:
how you should develop the system during physical design
what you learned during requirements determination
how you should implement the new system during implementation
what you learned during project planning
Question 33
1 out of 1 points
The primary deliverable from the conceptual modeling step within the analysis phase is a(n):
E-R diagram
state-transition diagram
context data flow diagram
decision tree
Question 34
1 out of 1 points
The data manipulation operation (insert, delete, or update) that initiates the operation is called a(n):
condition
action
user rule
event
Question 35
1 out of 1 points
Movement to another screen requires the functional requirement of:
cursor control capabilities
editing capabilities
exit capabilities
help capabilities
Question 36
1 out of 1 points
When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:
second normal form
third normal form
fourth normal form
fifth normal form
Question 37
1 out of 1 points
A many-to-many relationship that associates certain items with their component items is called a:
binary structure
bill-of-materials structure
binary relationship
ternary relationship
Question 38
1 out of 1 points
During logical database design, the work of all systems development team members is coordinated and shared through:
the project dictionary
scheduled weekly meetings
the project leader
JAD sessions
Question 39
1 out of 1 points
Which of the following statements is true regarding normalization?
Normalization produces a set of well-structured relations that contain all of the data mentioned in system inputs and outputs.
Normalization is a top-down process.
Through the use of anomalies, stable structures are produced.
Normalization is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.
Question 40
1 out of 1 points
Which of the following client/server architectures places all software on the client except for the data management functions?
distributed function
remote presentation
remote data management
distributed processing
Question 41
1 out of 1 points
When designing Web pages, which of the following is the recommendation for avoiding bleeding-edge technology?
make sure that users do not need the latest browsers or plug-ins to view your site
avoid using large images, lots of images, unnecessary animations, or other time-consuming content
avoid scrolling text and animations since they are both hard to read and users often equate such content as advertising
make sure that users do not need the latest browsers or plug-ins to view your site
make sure you avoid designing any legitimate information in a manner that resembles advertising
Question 42
1 out of 1 points
The primary characteristic of a client-based LAN is that:
all data manipulation is performed at the client PC, not at the file server
all data manipulation is performed at the file server, not at the client PC
all data manipulation is performed at the client PC, not at the file server
each client has a copy of the database and performs all data manipulations
the database is stored on the file server and all data manipulations are performed by the file server
Question 43
1 out of 1 points
For a binary many-to-many relationship existing between entity types A and B:
a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship
the primary keys of relation A and relation B are designated as functionally dependent attributes
secondary keys are used to establish the relationship
place the primary key of either entity in the relation for the other entity or do this for both entities
Question 44
1 out of 1 points
In general, highlighting:
should not be used to warn users of errors in data entry or processing
should not be used to provide warnings to users regarding possible problems such as unusual data values
should not be used in tandem
should be used sparingly to draw the user to or away from certain information and to group together related information
Question 45
1 out of 1 points
In the case of designing forms and reports, the major deliverables are:
the design specifications
an updated baseline project plan and updated statement of work
entity-relationship diagrams
the implemented forms and reports
Question 46
1 out of 1 points
The ability to provide field-level help is often referred to as:
context-sensitive help
screen-level help
systems-level help
application-level help
Question 47
1 out of 1 points
Basic procedures for constructing a decision table do not include:
listing all possible rules
naming the conditions and the values each condition can assume
identifying selection criteria
simplifying the decision table
Question 48
1 out of 1 points
A communication protocol for exchanging information on the Internet best describes:
HTTP
BIND
HTML
XML
Question 49
1 out of 1 points
Which of the following statements regarding the differences between file server and client/server architectures is true?
While database security and integrity are low on a file server architecture, they are high on a client/server architecture.
While network usage involves efficient data transfers on a file server architecture, it is not efficient on a client/server architecture.
In terms of hardware and system software flexibility, there is less need for coordination between the client and server on a client/server architecture than on a file server architecture.
In terms of concurrent data access, concurrent data access is managed by the client in a client/server architecture.
Question 50
1 out of 1 points
Client-based deliveries of applications to users of PCs and workstations are called:
client-delivery applications
local applications
front-end applications
back-end applications
Question 51
1 out of 1 points
The general design guideline stating that outputs should be self-explanatory and not require users to remember information from prior outputs in order to complete tasks is:
ease
efficiency
flexibility
format
Question 52
1 out of 1 points
If a form is delivered on a visual display terminal, which design specification section would describe the capabilities of this device?
narrative overview
sample design
testing and usability
management issues
Question 53
1 out of 1 points
When designing forms and reports, the first activity is to:
gain an understanding of the intended user and task objectives by collecting initial requirements during requirements determination
structure and refine the requirements independent from the users
ask users to review and refine prototypes of the form or report
structure and refine the requirements with the users
Question 54
1 out of 1 points
Which of the following refers to the set of all data types and values that an attribute can assume?
domains
referential integrity constraints
triggering operations
entity integrity
domains
Question 55
1 out of 1 points
An effectively designed form:
minimizes the need to scroll windows
provides default values when practical
displays data in appropriate field lengths
does all of these
Question 56
1 out of 1 points
A concise statement of the business rule to be enforced by the triggering operation refers to:
user rule
condition
action
event
Question 57
1 out of 1 points
An arrow on a data flow diagram represents a:
data store
data flow
process
source/sink
Question 58
1 out of 1 points
Research conducted on the usage of color found that:
color had positive effects on user task performance and perceptions when the user was under time constraints for the completion of a task
color is universally better than no color
the benefits of color are apparent regardless of the presentation format of the information
limiting the number and amount of color is not a good idea
Question 59
1 out of 1 points
Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?
Entries in cells are simple.
Entries in columns are from the same set of values.
Each row is unique.
The sequence of rows is insignificant.
Question 60
1 out of 1 points
For a binary one-to-one relationship between two entities A and B, the relationship is represented by:
either adding the primary key of A as a foreign key of B or adding the primary key of B as a foreign key of A
adding the primary key of A as a foreign key of B
adding the primary key of B as a foreign key of A
combining the two entities into one relation
Question 61
1 out of 1 points
A set of two or more multivalued attributes that are logically related defines:
relationship
gerund
repeating group
class
Question 62
1 out of 1 points
When condition values are either "yes" or "no", these values are called a(n):
extended entry
simple entry
complex entry
limited entry
Question 63
1 out of 1 points
Entering invalid data into a field describes:
transposing
transcripting
appending
truncating
Question 64
1 out of 1 points
Which of the following is a fundamental question to ask when designing forms and reports?
Who will use the form or report?
What is the purpose of the form or report?
Where does the form or report need to be delivered and used?
All of these
Question 65
1 out of 1 points
The process of linking together previous stand-alone personal computers to form networks that support workgroup computing is sometimes called:
upsizing
downsizing
upgrading
communicating
Question 66
1 out of 1 points
A method by which users interact with information systems defines:
dialogue
discussion
interface
session
Question 67
1 out of 1 points
If a data flow appears on the context diagram and is also represented at level-0, this would be referred to as:
leveling
flow conservation
balancing
matching
Question 68
1 out of 1 points
A supplier of auto parts to our company is represented on a data flow diagram as a:
process
source
data flow
data store
Question 69
1 out of 1 points
A computing server where data analysis functions primarily reside best defines:
file server
analytical server
dedicated server
application server
Question 70
1 out of 1 points
The section of a design specification that explains to those who will actually develop the final form why this form exists and how it will be used is called:
narrative overview
testing and usability assessment
rationale and benefit
usage and application
Question 71
1 out of 1 points
The menu positioning method that places a menu near the current cursor position is the:
pop-up menu
drop-down menu
box menu
cursor menu
Question 72
1 out of 1 points
A data flow diagram that represents a system's major processes, data flows, and data stores at a high level of detail refers to:
level-0 diagram
context diagram
level-1 diagram
level-00 diagram
Question 73
1 out of 1 points
The process of converting complex data structures into simple, stable data structures is referred to as:
normalization
simplification
structuring
process modeling
Question 74
1 out of 1 points
A named two-dimensional table of data is a:
network
tree structure
relation
tuple
Question 75
1 out of 1 points
If an associative entity exists, then:
a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship
the primary keys of relation A and relation B are designated as functionally dependent attributes
secondary keys are used to establish the relationship
place the primary key of either entity in the relation for the other entity or do this for both entities
Question 76
1 out of 1 points
Data in motion, moving from one place in a system to another, defines:
data store
process
source
data flow
Question 77
1 out of 1 points
Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?
referential integrity constraints
triggering operations
entity integrity
domains
Question 78
1 out of 1 points
An association between the instances of one or more entity types that is of interest to the organization best defines:
occurrence
relationship
coupling
cardinality
Question 79
1 out of 1 points
During physical design, you consider:
the definitions of each attribute
the descriptions of where and when data are entered, retrieved, deleted, and updated
the expectations for response time and data integrity
All of these
Question 80
1 out of 1 points
For each entity, the name of the identifier is:
identified by using a double-lined ellipse
bold on an E-R diagram
written in all capital letters on an E-R diagram
Question 81
1 out of 1 points
Tables should be used instead of graphs when the user will be:
comparing points and patterns of different variables
forecasting activities
reading individual data values
detecting trends over time
Question 82
1 out of 1 points
When designing the navigation procedures within your system, the primary concerns are:
the design of between-field navigation and the ability to provide feedback
grouping data fields into logical categories and assigning group labels
flexibility and consistency
accuracy and reliability
Question 83
1 out of 1 points
When two 3NF relations are merged to form a single relation:
transitive dependencies may result
weak entities are created
recursive relationships may result
IS-A relationships are formed
Question 84
1 out of 1 points
Assume the first condition has four values; the second condition has two values; the third condition has two values. How many rules will there be?
8
7
16
24
Question 85
1 out of 1 points
To convert a relation to second normal form, you decompose the relation into new relations using the attributes, called:
determinants
foreign key
pointer
relationship key
Question 86
1 out of 1 points
The three main constructs of the entity-relationship modeling notation include each of the following except:
data entities
data flows
relationships
attributes
Question 87
1 out of 1 points
Which of the following is a true statement?
An employee application is an example of a report.
Reports are only for reading and often contain data about multiple unrelated records in a computer file.
Reports are used to convey information on a single item.
Generally, reports are only printed on paper.
Question 88
1 out of 1 points
Which of the following is not an advanced rule governing data flow diagramming?
Composite data flows on one level cannot be split into component data flows at the next level.
To avoid having data flow lines cross each other, data stores may be repeated on a DFD.
At the lowest level of DFDs, new data flows may be added to represent data that are transmitted under exceptional conditions.
The inputs to a process must be sufficient to produce the outputs from the process.
Question 89
1 out of 1 points
Software building blocks that are used to assure that common system capabilities like user interfaces and printing are standardized as well as modules for facilitating the data exchange between clients and servers best describes:
an application program interface
firmware
a software patch
a database management system
Question 90
1 out of 1 points
The condition that causes the operation to be triggered:
condition
action
entity name
user rule
Question 91
1 out of 1 points
The focus placed on forms and reports during logical design is on:
the content and layout design of the forms and reports
identifying how specific forms or reports should be implemented
identifying the content, layout design, and implementation method
None of these
Question 92
1 out of 1 points
Which of the following specifies that an entity instance can simultaneously be a member of two (or more) subtypes?
overlap rule
total specialization rule
partial specialization rule
disjoint rule
Question 93
1 out of 1 points
A sphere mounted on a fixed base that steers the cursor on a computer display is a:
trackball
mouse
light pen
joystick
Question 94
1 out of 1 points
The variation of menu design is most often related to:
All of these
the capabilities of the development environment
the skills of the developer
the size and complexity of the system
All of these
Question 95
1 out of 1 points
A miracle process is one that:
has only inputs
has only outputs
cannot be exploded further
has insufficient inputs to produce the associated processes
Question 96
1 out of 1 points
The input device that is most accurate for text selection is the:
mouse
keyboard
trackball
light pen
Question 97
1 out of 1 points
A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a(n):
attribute
data element
relationship
entity
Question 98
1 out of 1 points
When selecting an identifier, one should:
use intelligent keys
use large composite keys instead of single-attribute surrogate keys
choose a candidate key that will not change its value over the life of each instance of the entity type
choose a candidate key such that for each instance of the entity, the attribute is guaranteed to have valid values or is null
Question 99
1 out of 1 points
A data warehouse that is limited in scope and whose data are obtained by selecting and summarizing data from the enterprise data warehouse best describes a(n):
information desk
rule base
data mart
data center
Question 100
1 out of 1 points
A human-computer interaction method where symbols are used to represent commands or functions defines:
object-based interaction
form interaction
menu interaction
command language interaction
USA 
India