Software Engineering I

Which of the following types of attributes is not proper in an analysis class? A) integers B) strings C) doubles D) compound E) date

Compound

A(n) _____ formalizes the interactions between a client and server object. A) relationship B) contract C) abstract object D) concrete object E) abstraction

Contract

Manipulating certain parameters to refine the way features work in a software package is called _____. A. a workaround B. adjustment C. customization D. feature adjustability E. parameterizing

Customization

A simple rule to follow when creating problem domain classes and data access and manipulation classes is that there should be ______________. A) One data access and manipulation class for each concrete problem domain class B) Two data access and manipulation classes for each concrete problem domain class C) N data access and manipulation classes for each concrete problem domain class, where N is the number of methods in the problem domain class D) N data access and manipulation classes for each concrete problem domain class, where N is the number of subclasses of the problem domain class E) None of the above

One data access and manipulation class for each concrete problem domain class

The ____ of an object is defined by the value of its attributes and its relationships with other objects at a particular point in time. A. activity B. action C. state D. guard condition E. transition

State

_____ has emerged as the standard for the design of object-oriented systems. A) Java B) C++ C) VisualBasic D) UML E) Microsoft .NET

UML

In an object-oriented system, changes can take place at the following level of abstraction. A) variable B) method C) class/object D) cluster (examples: partition, package) E) all of the above

all of the above

A(n) ______ matrix can be used to organize the pros and cons of the design alternatives so that the best solution will be chosen in the end. A. alternative B. cost-benefit C. feasibility D. design E. evaluation

alternate

The size of a database is determined by the _____. A) amount of raw data in the tables B) amount of raw data in the tables and overhead requirements for the DBMS C) number of instances in the tables D) overhead requirements for the DBMS E) overhead requirements for the DBMS and number of instances in the tables

amount of raw data in the tables and overhead requirements for the DBMS

Which of the following Structured English statements is an advanced form of an IF statement? A) action statement B) For statement C) While statement D) Case statement E) Do statement

case statement

A class/object should only represent one thing, and a method should only solve a single task. This principle is often referred to as _____. A) coupling B) cohesion C) connascence D) multiple inheritance E) none of the above

cohesion

Of all of the types of interaction coupling, _____ is the worst. A) stamp B) data C) content or pathological D) common or global E) control

content or pathological

_____ refers to the level of interdependency or interrelationship among the modules in a system. A) coupling B) cohesion C) connascence D) multiple inheritance E) single inheritance

coupling

Which of the following types of interaction coupling is "best?" A) stamp B) data C) content or pathological D) common or global E) control

data

In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model. A) cluster B) denormalize C) index D) normalize E) optimize

denormalize

A(n) _____ is less expensive and easier for novice users to use, but it does not have the features that are necessary to support mission-critical or large scale systems. A) database B) database management system C) end-user database administrative system D) end-user database management system E) enterprise database management system

end-user database management system

A(n) _____ can support large volumes of data and support applications that run an entire company. A) database B) database management system C) end-user database administrative system D) end-user database management system E) enterprise database management system

enterprise database management system

Data may be stored in the following formats _____. A) databases B) entities C) entities and files D) files E) files and databases

files and databases

If the data model does not have any repeating fields it is in _____. A) base normal form B) first normal form C) non-normal form D) second normal form E) third normal form

first normal form

A mini-table that contains values from one or more columns in a table and the location of the values within the table is called a(n) _____. A) index B) interfile cluster C) intrafile cluster D) raw data calculation E) volumetric

index

_____ suggests that only the information required to use an object should be available outside the object. A) encapsulation B) information hiding C) polymorphism D) inheritance E) cohesion

information hiding

What are the two types of coupling in object-oriented systems? A) interaction, data B) data, inheritance C) data, stamp D) interaction, inheritance E) data, common

interaction, inheritance

To improve the access speed of a database, similar records in a table are stored together in primary key order. This optimizing access speed process is called _____. A) denormalization B) indexing C) interfile clustering D) intrafile clustering E) volumetrics

intra file clustering

Detailed design is important for two reasons. First, preexisting classes and components need to be understood, organized, and pieced together, and second, _____. A) it is common for the project team to write some code and produce original classes that support the application logic of the system B) it is tempting to jump in without planning C) modular design is outdated D) the SDLC continues to be used instead of a more reliable method of analysis for systems E) top-down modular approaches are an acceptable method of analysis that must be performed during the planning phase

it is common for the project team to write some code and produce original classes that support the application logic of the system

Object-oriented systems have three general types of cohesion: _____, _____, and _____. A) method, class, inheritance B) method, generalization/specialization, inheritance C) generalization/specialization, class, object D) method, class, generalization/specialization E) functional, sequential, procedural

method, class, generalization/specialization

A(n) _____ is the equivalent to a subsystem. A) collaboration B) partition C) layer D) factor E) abstraction

partition

_____ means having the ability to send the same message to different objects, which can be interpreted differently by different objects. A) encapsulation B) polymorphism C) inheritance D) coupling E) cohesion

polymorphism

The type of database that is most capable of supporting complex data types is _____. A) hierarchical integrity B) primary integrity C) table integrity D) referential unity E) referential integrity

referential integrity

A data model that does not contain repeating fields and that the data models leads to tables containing fields that are dependent on a whole primary key is in _____ normal form. A) balanced B) first C) primary D) second E) third

second

A relational database may be optimized for _____. A) data type and storage efficiency B) relational type C) speed of access D) storage efficiency E) storage efficiency and speed of access

storage efficiency and speed of access

A(n) _____ is basically an electronic list of information that is stored on a disk. A) storage of objects in the relational table structure B) good support for typical data management operations C) SQL support D) support for inheritance E) all of the above are characteristics of object-relational databases

support for inheritance

A master file stores core information that is important to the business, is normally kept for long periods of time, and is regularly updated. A. True B. False

t

A method that combines two functions that use the same attributes to execute exhibits Coincidental cohesion, and this type of cohesion is desirable. A. True B. False

t

A method that performs multiple functions that are unrelated to one another exhibits Coincidental cohesion, and this type of cohesion is undesirable.

t

A value added contract provides for the outsourcer to gain a percentage of the completed systems benefits. A. True B. False

t

An audit file contains information about how data changes over time; it records before and after images of data as it is altered so that it can be validated later. A. True B. False

t

Clustering similar records together is one way of reducing access time. A. True B. False

t

Denormalization of a data model reduces the number of joins that must be performed in a query, which increases the speed of data access. A. True B. False

t

Functional method cohesion is the "best" type of method cohesion. A. True B. False

t

Generalization/specialization cohesion addresses the sensibility of the inheritance hierarchy. A. True B. False

t

Mapping between the problem domain objects and an OODBMS is a straightforward one-to-one mapping. A. True B. False

t

Most object-oriented programming languages support sequential and random access files. A. True B. False

t

Object wrappers enable object-oriented systems to interact with legacy systems through an Application Program Interface (API). A. True B. False

t

Sequential access files are very efficient for operations such as report writing. A. True B. False

t

The leader in the database market and a system that can handle diverse data needs is the relational DBMS. A. True B. False

t

The most efficient tables in a relational database in terms of speed have redundant data and null values. A. True B. False

t

The physical architecture layer will include the classes that interact with middleware applications. A. True B. False

t

The two primary dimensions to optimize a relational database are storage efficiency and speed. A. True B. False

t

Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound. A. True B. False

t

In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database. A) attribute B) row C) table D) relationship E) unique identifier

table

SQL operates on _____. A. rows of data at a time B. columns of data at a time C. tables of data at a time D. the entire database E. any of the above

tables of data at a time

Fan-out refers to _____. A) the number of attributes a class has B) the number of messages sent by a method C) the number of times a message is sent by a method D) the number of times an attribute is passed from a class E) none of the above

the number of messages sent by a method

_____ is the process of estimating the amount of data that the hardware will need to support, so that the server hardware specifications are sufficient for the project's needs. A) Indexing B) Interfile clustering C) Intrafile clustering D) Raw data calculating E) Volumetrics

volumetrics