Question: Modality refers to:

Answer Options:

Whether a child entity can exist with or without a related instance in the parent entity The hierarchical structure that was developed in process models applied to data models The number of attributes generated by an entity Whether the entity has a unique identifier (aka ‘primary key’) or a concatenated identifier (aka ‘composite key’) Relationships of one-to-one; one-to-many; or many-to-many

Answer: Whether a child entity can exist with or without a related instance in the parent entity

 

Question: On an ERD ___________:

Answer Options:

Data elements are grouped in a hierarchical structure that is uniquely identified by number Data elements are listed alphabetically with a cross listing to the processes that manipulate them Processes are listed alphabetically with relationship connections drawn between processes Data elements are listed together and place inside boxes called entities Data elements are described as singular (1:1); plural/s (1 ); or didactic (M )

Answer: Data elements are listed together and place inside boxes called entities

 

Question: The first step to building an Entity Relationship Diagram is to _______.

Answer Options:

Identify the entities Identify data flows from the level 0 DFD diagram Draw the relationships between the entities Identify the processes, data flows and data stores Identify the attributes for each entity

Answer: Identify the entities

 

Question: The last step in creating basic ERD’s is to:

Answer Options:

Define attributes and assign identifiers Identify relationships Compile them with Java Recognize entities Test them with users

Answer: Identify relationships

 

Question: Which is NOT a purpose of the requirements definition?

Answer Options:

To give a very high-level explanation of the business requirements
A more precise list of requirements that can be used as inputs to the rest of analysis Create functional requirements Create cost/benefit analysis Create non-functional requirements

Answer: To give a very high-level explanation of the business requirements

 

Question: Which is NOT a requirements analysis strategy?

Answer Options:

Understanding of the as-is system Identifying improvements Developing requirements for the to-be system Root cause analysis Understanding of screen design, layout and navigation

Answer: Understanding of screen design, layout and navigation

 

Question: Which of the following is true about a JAD facilitator?

Answer Options:

They can participate in the discussion to settle a disagreement They keep track of all discussions by entering information into the computer They allow sidebar discussions and unstructured activities They recognize that some people know more about the system and proposed system and will dominate the discussion and know that is a positive thing They set the meeting agenda

Answer: They set the meeting agenda

 

Question: The two methods to validate that an ERD is well formed are _______:

Answer Options:

Balancing with process models and renaming theory Balancing with process models and following design guidelines created by Chen Renaming theory Normalization and balancing with process models Normalization and following design guidelines created by Chen

Answer: Normalization and balancing with process models

 

Question: What is true about creating an entity relationship diagram?

Answer Options:

There will be at most seven entities There will be at most seven relationships It is an iterative process Entities will have at most seven attributes If you identify more than seven entities, analyze and combine until you have seven or less

Answer: It is an iterative process

 

Question: When normalizing data models, if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from:

Answer Options:

Dependent normal form (DNF) to Independent normal form (INF) 2nd normal form (2NF) to 3rd normal form (3NF) 0 normal form (0NF) to 1st normal form (1NF) Generalized normal form (GNF) to fully normalized form (FNF) 1st normal form (1NF) to 2nd normal form (2NF)

Answer: 0 normal form (0NF) to 1st normal form (1NF)

 

Question: A popular TDM WAN technology is

Answer Options:

Frame relay Synchronous Optical Network (SONET) ATM X.25

Answer: Synchronous Optical Network (SONET)

 

Question: Frequency division multiplexed WANs are used to leverage the data carrying capacity of

Answer Options:

Wi-Fi Copper wires PCs Optical fiber

Answer: Optical fiber

 

Question: When traversing from the source to destination, data packets typically cross

Answer Options:

Multiple LANs and one WAN Multiple LANs and multiple WANs One LAN and multiple WANs None of the above

Answer: Multiple LANs and multiple WANs

 

Question: In the TCP/IP stack, WAN technologies are considered to be instances of the

Answer Options:

Transport layer Network layer Physical layer Data link layer

Answer: Data link layer

 

Question: ATM specifies data rates in the range of

Answer Options:

56 kbps – 45 mbps 56 kbps – 2 mbps 50.112 mbps – 150.336 mbps 1.544 mbps – 622.08 mbps

Answer: 56 kbps – 2 mbps

 

Question: Thick clients contain:

Answer Options:

Enormous storage abilities Almost all or most of the application logic Almost none or less than half of the application logic Almost all of the data logic None of these

Answer: Almost all or most of the application logic

 

Question: An example of a multilingual requirement is:

Answer Options:

The system will operate in English, French and Spanish Country managers can define custom fields All date fields will be presented in a uniform format Personal information about English customers cannot be sent to Chinese systems Country managers are able to change telephone number formats

Answer: The system will operate in English, French and Spanish

 

Question: When you join two relational database tables together, frequently the primary key in one table will be a __________ in the other table.

Answer Options:

Foreign key International key Primary key Linked list Entity

Answer: Foreign key