IS 410 Exam I Mock Test

3) Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload A) Define one vehicle entity type to hold all entities. B) Define a separate entity type for each entity. C) Define a supertype called vehicle and make each of the entities subtypes. D) Keep only the Truck entity type.

A) Define one vehicle entity type to hold all entities.

37) Which of the following is true of packaged data models? A) Relationships are connected to the highest-level entity type in an order that makes sense. B) All subtype/supertype relationships follow the total specialization and disjoint rules. C) No entities on the many sides of a relationship can be weak. D) All weak entities are considered strong.

A) Relationships are connected to the highest-level entity type in an order that makes sense.

28) The following figure shows an example of: STUDENT: SID Name Address (Street, City, State, ZipCode) A) a composite attribute. B) a relational attribute. C) a derived attribute. D) a multivalued attribute.

A) a composite attribute.

17) A property or characteristic of an entity type that is of interest to the organization is called a(n): A) attribute. B) coexisting entity. C) relationship. D) cross-function.

A) attribute.

19) A person's name, birthday, and social security number are all examples of: A) attributes. B) entities. C) relationships. D) descriptors.

A) attributes.

4) Data modeling may be the most important part of the systems development process because: A) data characteristics are important in the design of programs and other systems components. B) the data in a system are generally less complex than processes and play a central role in development. C) data are less stable than processes. D) it is the easiest.

A) data characteristics are important in the design of programs and other systems components.

17) A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. A) disjointness constraint B) disjoint rule C) partial specialization D) total specialization

A) disjointness constraint

1) A form of database design which maps conceptual requirements is called: A) logical designs. B) response designs. C) security design. D) physical design.

A) logical designs.

3) A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly

A) logically

33) Understanding the steps involved in transforming EER diagrams into relations is important because: A) one must be able to check the output of a CASE tool. B) there are rarely legitimate alternatives from which to choose. C) CASE tools can model any situation. D) CASE tools model hypothetical business problems.

A) one must be able to check the output of a CASE tool.

17) A major difference between data warehouses and transactional systems as compared to big data is: A) the data is unstructured in big data systems. B) the size of the CPU used. C) the programming required to access data. D) all of the above.

A) the data is unstructured in big data systems.

4) Subtypes should be used when: A) there are attributes that apply to some but not all instances of an entity type. B) supertypes relate to objects outside the business. C) the instances of a subtype do not participate in a relationship that is unique to that subtype. D) a recursive relationship is needed.

A) there are attributes that apply to some but not all instances of an entity type.

26) The period that can be considered a "proof of concept" time was the: A) 1950s. B) 1960s. C) 1970s. D) 1990s.

B) 1960s.

4) ________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. A) Business rule constraint B) Data integrity C) Business integrity D) Data structure

B) Data integrity

22) A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? A) First B) Second C) Third D) Fourth

B) Second

19) ________ is a tool even non-programmers can use to access information from a database. A) ODBC B) Structured query language C) ASP D) Data manipulation query language

B) Structured query language

2) Which of the following is a generic entity type that has a relationship with one or more subtypes? A) Megatype B) Supertype C) Subgroup D) Class

B) Supertype

36) The traditional methodology used to develop, maintain, and replace information systems is called the: A) Enterprise Resource Model. B) Systems Development Life Cycle. C) Unified Model. D) Systems Deployment Life Cycle.

B) Systems Development Life Cycle.

32) An alternative name for an attribute is called a(n): A) synonym. B) alias. C) alternate attribute. D) related characteristic.

B) alias.

36) A ________ specifies the number of instances of one entity that can be associated with each instance of another entity. A) degree B) cardinality constraint C) counter constraint D) limit

B) cardinality constraint (Chap 2 - page 84)

35) When a regular entity type contains a multivalued attribute, one must: A) create a single relation with multiple lines for each instance of the multivalued attribute. B) create two new relations, one containing the multivalued attribute. C) create two new relations, both containing the multivalued attribute. D) delete the relation and start over.

B) create two new relations, one containing the multivalued attribute.

36) Packaged data models: A) are ready to use right out of the box. B) require customization. C) allow partial specialization. D) cannot be used for most applications.

B) require customization.

18) An attribute that must be present for every entity (or relationship) instance is a(n): A) composite attribute. B) required attribute. C) optional attribute. D) multivalued attribute.

B) required attribute.

47) Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called: A) tables on write. B) schema on write. C) on demand paging. D) caching.

B) schema on write.

27) A departmental multi-tiered client/server database is stored on a central device called a: A) client. B) server. C) remote PC. D) network.

B) server.

2) Data is represented in the form of: A) data trees. B) tables. C) data notes. D) chairs.

B) tables.

3) A fact is an association between two or more: A) words. B) terms. C) facts. D) nuggets.

B) terms.

24) A candidate key must satisfy all of the following conditions EXCEPT: A) the key must uniquely identify the row. B) the key must indicate the row's position in the table. C) the key must be nonredundant. D) each nonkey attribute is functionally dependent upon it.

B) the key must indicate the row's position in the table.

45) A value that indicates the date or time of a data value is called a: A) value stamp. B) time stamp. C) checkpoint. D) check counter.

B) time stamp.

46) A data warehouse derives its data from: A) on-line transactions. B) various operational data sources. C) reports. D) a data mart.

B) various operational data sources.

29) In the figure below, which attribute is multivalued? Employee_ID Emplyee_Name Address Date_Employed (Skill) [Years_Employed] A) Years_Employed B) Employee_ID C) Skill D) Address

C) Skill

16) A user view is: A) what a user sees when he or she looks out the window. B) a table or set of tables. C) a logical description of some portion of the database. D) a procedure stored on the server.

C) a logical description of some portion of the database.

39) The SDLC phase in which the detailed conceptual data model is created is the ________ phase. A) planning B) design C) analysis D) implementation

C) analysis

2) Database management involves all of the following EXCEPT: A) collecting data. B) organizing data. C) design web pages. D) managing data.

C) design web pages.

23) A constraint between two attributes is called a(n): A) functional relation. B) attribute dependency. C) functional dependency. D) functional relation constraint.

C) functional dependency.

103) The relational data model is no longer popular in the 21st century. True/False

False

106) In multi-tier database architectures, little functionality needs to be programmed into the client application. True/False

False

46) A composite key consists of only one attribute. True/False

False

48) A subtype is a generic entity that has a relationship with one or more entities at a lower level. True/False

False

50) A member of a subtype does NOT necessarily have to be a member of the supertype. True/False

False

50) Databases were developed as the first application of computers to data processing. True/False

False

56) An example of a term would be the following sentence: "A student registers for a course." True/False

False

62) The primary key of the many side migrates to the one side when transforming a one-to-many relationship. True/False

False

63) Data redundancy is used to establish relationships between data but is never used to improve database performance. True/False

False

63) When transforming a one-to-one relationship, a new relation is always created. True/False

False

65) A user view is how the user sees the data when it is produced. True/False

False

65) An identifier assigned to an associative entity is also called a cross-relation key. True/False

False

77) Packaged data models use an entity type to store union data. True/False

False

80) A co-dependency is a constraint between two attributes or two sets of attributes. True/False

False

82) A relation is in first normal form if it has no more than one multivalued attribute. True/False

False

85) It is not permissible to associate attributes with relationships. True/False

False

86) A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type. True/False

False

104) Although personal databases improve productivity, one risk is that data cannot be shared with other users. True/False

True

105) The most common way to support a group of individuals who work together on a project or group of similar projects is with a multi-tier client/server database. True/False

True

45) Data structures include data organized in the form of tables with rows and columns. True/False

True

46) The E-R model is used to construct a conceptual model. True/False

True

47) A business rule is a statement that defines or constrains some aspect of the business. True/False

True

16) The ________ rule specifies that an entity can be a member of only one subtype at a time. A) exclusion B) disjoint C) removal D) inclusion

B) disjoint

1) The logical representation of an organization's data is called a(n): A) database model. B) entity-relationship model. C) relationship systems design. D) database entity diagram. (Chap 2 - page 56)

B) entity-relationship model.

44) A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. A) one-to-one B) many-to-many C) one-to-many D) strong

B) many-to-many

29) Which of the following is NOT a cost and/or risk of the database approach? A) Specialized personnel B) Cost of conversion C) Improved responsiveness D) Organizational conflict

C) Improved responsiveness

43) ________ anomalies can be caused by editing data in tables. A) Insertion B) Deletion C) Modification D) Creation

C) Modification

37) The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase. A) planning B) design C) analysis D) implementation

C) analysis

16) An entity type name should be all of the following EXCEPT: A) concise. B) specific to the organization. C) as short as possible. D) a singular noun.

C) as short as possible.

35) An entity cluster can be formed by: A) deleting a supertype and its subtype. B) combining metadata. C) combining a strong entity and its weak entities. D) deleting metadata.

C) combining a strong entity and its weak entities.

20) An attribute of an entity that is computed is a(n): A) optional attribute. B) composite attribute. C) derived attribute. D) fuzzy attribute.

C) derived attribute.

34) A nonkey attribute is also called a(n): A) column. B) unimportant datum. C) descriptor. D) address.

C) descriptor.

5) An attribute (or attributes) that uniquely identifies each row in a relation is called a: A) column. B) foreign field. C) primary key. D) duplicate key.

C) primary key.

7) Relational databases establish the relationships between entities by means of common fields included in a file called a(n): A) entity. B) relationship. C) relation. D) association.

C) relation

8) A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A) enterprise view B) reporting document C) user view D) user snapshot

C) user view

28) Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. A) 40 percent B) 25 percent C) 60 percent D) 80 percent

D) 80 percent

18) Which organizational function should set database standards? A) Management B) Application development C) Technical services D) Database Administration

D) Database Administration

1) The property by which subtype entities possess the values of all attributes of a supertype is called: A) hierarchy reception. B) class management. C) multiple inheritance. D) attribute inheritance.

D) attribute inheritance.

9) A graphical system used to capture the nature and relationships among data is called a(n): A) XML data model. B) hypertext graphic. C) relational database. D) data model.

D) data model.

38) The SDLC phase in which database processing programs are created is the ________ phase. A) planning B) design C) analysis D) implementation

D) implementation

37) A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship. A) optional B) unidirectional C) mandatory link D) mandatory one

D) mandatory one

3) A two-dimensional table of data sometimes is called a: A) group. B) set. C) declaration. D) relation.

D) relation.

44) A relation that contains minimal redundancy and allows easy use is considered to be: A) clean. B) simple. C) complex. D) well-structured.

D) well-structured.

2) A good data definition will describe all of the characteristics of a data object EXCEPT: A) subtleties. B) examples. C) who determines the value of the data. D) who can delete the data.

D) who can delete the data.

85) Anomalies do not generally arise out of transitive dependencies. True/False

False

47) A primary key is an attribute that uniquely identifies each row in a relation. True/False

True

48) Information is processed data. True/False

True

49) An entity instance of a subtype represents the same entity instance of the supertype. True/False

True

49) Metadata are data that describe the properties of other data. True/False

True

55) Data names should always relate to business characteristics. True/False

True

57) A fact is an association between two or more terms. True/False

True

58) A good data definition is always accompanied by diagrams, such as the entity-relationship diagram. True/False

True

59) An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data. True/False

True

61) A relational database establishes the relationships between entities by means of a common field. True/False

True

62) Separation of metadata from application programs that use the data is called data independence. True/False

True

64) If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations. True/False

True

64) Redundancy increases the risk of inconsistent data. True/False

True

74) An entity cluster should focus on some area of interest to some community of users, developers, or managers. True/False

True

75) An entity cluster can have a relationship with another entity cluster much the same way that an entity can have a relationship with another entity. True/False

True

76) Packaged data models are meant to be customized. True/False

True

78) A universal data model is a generic or template data model that can be reused as a starting point for a data modeling project. True/False

True

81) A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation. True/False

True

84) It is desirable that no two attributes across all entity types have the same name. True/False

True

87) One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier. True/False

True