Test
Study Guide Chapter 5 & 6
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (37)
1A circle across the relationship line near an entity indicates ________.
- Aa maximum cardinality of "zero"
- Ba maximum cardinality of "one"
- Ca minimum cardinality of "optional"
- Da minimum cardinality of "required"
2 A composite attribute is an attribute that ________.
- ADescribes a characteristic of the relationship
- BIs Multivalued
- CConsists of a group of attributes
- DIs calculated at run-time
3A for-use-by pattern must involve what kind of entity?
- AWeak entity with one identifying relationship
- BStrong entity
- CSupertype entity
- DWeak entity with two identifying relationships
4A hash mark across the relationship line near an entity indicates ________.
- AA maximum cardinality of "zero"
- BA maximum cardinality of "one"
- CA minimum cardinality of "optional"
- DA minimum cardinality of "required"
5 A line-item pattern must involve what kind of entity?
- AWeak entity with one identifying relationship
- BWeak entity with two identifying relationships
- CSupertype entity
- DStrong entity
6A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called ________.
- AIncremental updates
- BIncremental deletes
- CCascading deletes
- DCascading updates
7A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.
- ACascading updates
- BCascading deletes
- CIncremental updates
- DIncremental deletes
8A surrogate key should be considered when ________.
- AA relationship is N:M
- BA composite key is required
- CThe key contains a lengthy text field
- DThe key contains a number
9An attribute that determines which subtype should be used is a(n) ________.
- ASupertype
- BSubtype
- CIdentifier
- DDiscriminator
10An entity that holds specialized attributes that distinguish it from one or more other similar entities is a ________.
- ASupertype
- BParent
- CSubtype
- DDiscriminator
11An entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity is a(n) ________.
- AID-dependent entity
- BStrong entity
- CSubtype entity
- DWeak entity
12An entity whose identifier includes the identifier of another entity is a(n) ________.
- ARequired Entity
- BWeak Entity
- COptional Entity
- DStrong Entity
13An identifier may be ________.
- AOptional
- BA relationship
- CMinimal
- DComposite
14 An occurrence of a particular entity is called an ________.
- AEntity relationship
- BEntity class
- CEntity attribute
- DEntity instance
15Each attribute of an entity becomes a(n) ________ of a table.
- AAlternate key
- BPrimary key
- CColumn
- DForeign Key
16Entities of a given type are grouped into an ________.
- AEntity attribute
- BEntity instance
- CEntity relationship
- DEntity class
17In a minimum cardinality, minimums are generally stated as ________.
- A0 or 1
- BM or N
- C1 or N
- DOne or many
18In a relational database design, all relationships are expressed by ________.
- ACreating a supertype
- BCreating a subtype
- CCreating a primary key
- DCreating a foreign key
19 In relational database design, IDdependent entities are not used to ________.
- Ahandle associative relationships
- Brepresent relationships where the child identifier does not include the key of the parent
- Crepresent N:M relationships
- Dhandle archetype/instance relationships
20Many-to-many relationships are represented by ________.
- Aan intersection table which has M:N relationships with the two tables
- Btwo tables with a 1:N relationship
- Ctwo tables with an M:N relationship
- Dan intersection table which has 1:N relationships with the two tables
21Many-to-many relationships are represented by ________.
- Aan intersection table which has M:N relationships with the two tables
- Btwo tables with a 1:N relationship
- Ctwo tables with an M:N relationship
- Dan intersection table which has 1:N relationships with the two tables
22Maximum cardinality refers to ________.
- Athe most instances of one entity class that can be involved in a relationship instance with another entity class
- Bwhether or not an instance of one entity class is required to be related to an instance of another entity class
- Cthe minimum number of entity classes involved in a relationship
- Dwhether or not an entity is a weak entity
23Minimum cardinality refers to ________.
- Athe most instances of one entity class that can be involved in a relationship with one instance of another entity class
- Bwhether or not an entity is a weak entity
- Cthe minimum number of entity classes involved in a relationship
- Dwhether or not an instance of one entity class is required to be related to an instance of another entity class
24Recursive relationships can have all of the following maximum cardinalities except ________.
- A1:1
- BN:M
- C1:N
- DM:M
25Supertype/subtype entities are said to have a(n) ________ relationship.
- AHAS-A
- BRedundant
- CIS-A
- DRecursive
26The binary constraint must cover indicates that ________.
- Aa table includes values that must occur in a ternary relationship
- Ba binary relationship includes a set of value combinations that must all occur in a ternary relationship
- Ca specific binary relationship must be included in a ternary relationship
- Da table includes values that must occur in a binary relationship
27The binary constraint must not indicates that ________.
- Aa table includes values that must not occur in a ternary relationship
- Ba binary relationship includes value combinations that must not occur in a ternary relationship
- Ca table includes values that must not occur in a binary relationship
- Da specific binary relationship must not be included in a ternary relationship
28The characteristics of a thing are described by its ________.
- AIdentifiers
- BAttributes
- CObjects
- DEntities
29The first step in transforming an extended ER model into a relational database design is to ________.
- Acreate a table for each relationship
- Bcreate a table for each entity
- Cremove any recursive relationships
- Devaluate the entities against the normalization criteria
30The identifier of the entity becomes the ________ of the corresponding table.
- ASubtype
- BSupertype
- CPrimary Key
- DForeign Key
31To represent a multivalued attribute in an E-R model, ________.
- Acreate a new IDdependent entity with a 1:1 relationship
- Bcreate a new weak, but not IDdependent entity with a 1:N relationship
- Ccreate a new IDdependent entity with a 1:N relationship
- Dcreate a new strong entity with a 1:1 relationship
32To represent a one-to-many relationship in a relational database design, ________.
- Aan intersection table must be created
- Bthe key of the table on the "many" side is placed in the table on the "one" side
- Cthe key of the parent is placed as a foreign key into the child
- Dthe key of the child is placed as a foreign key into the parent
33To represent an archetype/instance pattern in an ER model, ________.
- Acreate a new ID-dependent entity with a 1:1 relationship
- Bcreate a new ID-dependent entity with a 1:N relationship
- Ccreate a new weak, but not ID-dependent entity with a 1:N relationship
- Dcreate a new strong entity with a 1:1 relationship
34To represent an association pattern in an E-R model, ________.
- Acreate a new ID-dependent entity with a N:1 relationships to two parent entities
- Bcreate a new weak, but not ID-dependent entity with a 1:1 relationship to one other entity
- Ccreate a new strong entity with a 1:1 relationship to one other entity
- Dcreate a new ID-dependent entity with a 1:1 relationship to one other entity
35When an entity has a relationship to itself, we have a(n) ________.
- Asupertype/subtype relationship
- Barchetype/instance relationship
- Crecursive relationship
- DBoth supertype/subtype relationship and recursive relationship are correct
36When representing a 1:1 relationship in a relational database design, ________.
- Athe intersection table gets the key from both relations
- Bthe key of each table must be placed as foreign keys into the other
- Cthe key of either table may be placed as a foreign key into the other
- Dthe key of both tables must be the same
37When representing a onetomany relationship in a relational database design, ________.
- Athe parent is always on the one side of the "one-to-many" relationship
- Beither parent or child can be on the one side of the "one-to-many" relationship, and the choice is arbitrary
- Ceither parent or child can be on the one side of the "one-to-many" relationship, and special criteria indicate which table should be on the one side
- Dthe child is always on the one side of the "one-to-many" relationship
Información
- Descripción
- 1 ITD 256 Test sobre Study Guide Chapter 5 & 6, creado por jereznel el 09/06/2016.
- Autor
- jereznel
- Idioma
- English
- Visitas
- 123
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test