Updated Warehouse Test Guide
1. A database is an organized collection of ________ related data. A. logically B. physically C. loosely D. badly
Answer: A
11. Customers cars, and parts are examples of: A. entities. B. attributes. C. cardinals. D. relationships.,
Answer: A
14. Which of the following is a completeness constraint? A. Total specialization B. Partial generalization C. Total recall D. Partial hybridization
Answer: A
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.
Answer: A
19. A person's name birthday, and social security number are all examples of: A. attributes. B. entities. C. relationships. D. descriptors.,
Answer: A
20. When all multivalued attributes have been removed from a relation it is said to be in: A. first normal form. B. second normal form. C. Boyce-Codd normal form. D. third normal form.,
Answer: A
26. In a supertype/subtype hierarchy each subtype has: A. only one supertype. B. many supertypes. C. at most two supertypes. D. at least one subtype.,
Answer: A
43. A rule that states that each foreign key value must match a primary key value in the other relation is called the: A. referential integrity constraint. B. key match rule. C. entity key group rule. D. foreign/primary match rule.
Answer: A
43. When identifying the parts of the packaged data model that apply to your organization one should first start with: A. entities. B. attributes. C. primary keys. D. relationships.,
Answer: A
5. The most common types of entities are: A. strong entities. B. weak entities. C. associative entities. D. smush entities.
Answer: A
7. The process of defining one or more subtypes of a supertype and forming relationships is called: A. specialization. B. generalization. C. creating discord. D. selecting classes.
Answer: A
9. The process of defining a more general entity type from a set of more specialized entity types is called: A. generalization. B. specialization. C. normalization. D. extrapulation.
Answer: A
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.
Answer: B
1. ________ database specification indicates all the parameters for data storage that are then input to database implementation. A. Logical B. Physical C. Schematic D. Conceptual
Answer: B
10. In the SQL language the ________ statement is used to make table definitions. A. create session B. create table C. create index D. select,
Answer: B
11. ________ are established between entities in a well-structured database so that the desired information can be retrieved. A. Entities B. Relationships C. Lines D. Ties
Answer: B
13. An entity type whose existence depends on another entity type is called a ________ entity. A. strong B. weak C. codependent D. variant
Answer: B
16. ________ 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
Answer: B
17. 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
Answer: B
17. The ________ states that no primary key attribute may be null. A. referential integrity constraint B. entity integrity rule C. partial specialization rule D. range domain rule
Answer: B
18. An attribute that must have a value for every entity (or relationship. instance is a(n.: A. composite attribute. B. required attribute. C. optional attribute. D. multivalued attribute.
Answer: B
19. A rule that CANNOT be violated by database users is called a: A. password. B. constraint. C. program. D. view.
Answer: B
21. The ________ rule states that an entity instance can simultaneously be a member of two (or more. subtypes. A. disjoint B. overlap C. partial specialization D. total specialization
Answer: B
25. A workgroup database is stored on a central device called a: A. client. B. server. C. remote PC. D. network.
Answer: B
29. A knowledge base of information or facts about an enterprise is called a(n.: A. enterprise information system. B. repository. C. systems information unit. D. database process.
Answer: B
3. Data is represented in the form of: A. data trees. B. tables. C. data notes. D. chairs.
Answer: B
31. In a supertype/subtype hierarchy subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy. A. subtypes B. supertypes C. constraints D. dimensions,
Answer: B
33. An alternative name for an attribute is called a(n.: A. synonym. B. alias. C. alternate attribute D. related characteristic.
Answer: B
37. 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.
Answer: B
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,
Answer: B
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.
Answer: B
9. A primary key that consists of more than one attribute is called a: A. foreign key. B. composite key. C. multivalued key. D. cardinal key.
Answer: B
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. attribute inheritance. D. generalization.
Answer: C
11. The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. A. semi-specialization B. total specialization C. partial specialization D. disjointedness
Answer: C
24. A constraint between two attributes is called a(n.: A. functional relation. B. attribute dependency. C. functional dependency. D. functional relation constraint.
Answer: C
37. The SDLC phase in which the detailed conceptual data model is created is the ________ phase. A. planning B. design C. analysis D. implementation
Answer: C
39. An iterative methodology that rapidly repeats the analysis design, and implementation phases of the SDLC is called: A. CASE. B. CAD. C. RAD. D. MST.,
Answer: C
41. ________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business. A. Programmers B. Users C. Systems analysts D. Database analysts
Answer: C
5. 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.
Answer: C
6. 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.
Answer: C
7. An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A. link attribute. B. link key. C. foreign key. D. foreign attribute.
Answer: C
10. A person place, object, event, or concept about which the organization wishes to maintain data is called a(n.: A. relationship. B. object. C. attribute. D. entity.,
Answer: D
13. With the database approach data descriptions are stored in a central location known as a: A. server. B. mainframe. C. PC. D. repository.,
Answer: D
24. A relationship between the instances of a single entity type is called a ________ relationship. A. ternary B. primary C. binary D. unary
Answer: D
30. The need to ________ relations commonly occurs when different views need to be integrated. A. metadata B. system C. drop D. merge
Answer: D
31. An attribute that can be calculated from related attribute values is called a ________ attribute. A. simple B. composite C. multivalued D. derived
Answer: D
8. A ________ defines or constrains some aspect of the business. A. business constraint B. business structure C. business control D. business rule
Answer: D
8. Data that describe the properties of other data are: A. relationships. B. logical. C. physical. D. metadata.
Answer: D
47. A composite key consists of only one attribute.
Answer: FALSE
49. A subtype is a generic entity that has a relationship with one or more entities at a lower level.
Answer: FALSE
68. In an E-R diagram strong entities are represented by double-walled rectangles.,
Answer: FALSE
46. Data structures include data organized in the form of tables with rows and columns.
Answer: TRUE
47. Metadata are data that describe the properties of other data.
Answer: TRUE
55. A data model is a graphical system used to capture the nature and relationships among data.
Answer: TRUE
55. Specialization is the reverse of generalization.
Answer: TRUE
56. Data names should always relate to business characteristics.
Answer: TRUE
69. In an E-R diagram an associative entity is represented by a rounded rectangle.,
Answer: TRUE
