6274724
Frage 1
Frage
1. The ERD represents the ____ database as viewed by the end user.
Antworten
-
A) condensed
-
B) physical
-
C) logical
-
D) conceptual
Frage 2
Frage
2. Some ____ database modeling concepts can be expressed only using the Chen notation.
Antworten
-
A) developmental
-
B) conceptual
-
C) actual
-
D) specific
Frage 3
Frage
3. Attributes may share a ____.
Antworten
-
A) name
-
B) domain
-
C) location
-
D) table
Frage 4
Frage
4. The set of possible values for an attribute is a ____.
Antworten
-
A) domain
-
B) range
-
C) set
-
D) key
Frage 5
Frage
5. In an ER diagram, primary keys are indicated by ____.
Antworten
-
A) bolding
-
B) italics
-
C) underlining
-
D) a special font
Frage 6
Frage
6. Ideally, an entity identifier is composed of ____ attribute(s).
Antworten
-
A) zero
-
B) one
-
C) two
-
D) six
Frage 7
Frage
7. A ____ identifier is composed of more than one attribute.
Antworten
-
A) primary
-
B) foreign
-
C) composite
-
D) domain
Frage 8
Frage
8. The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)
Antworten
-
A) CRS_CODE
-
B) CLASS_SECTION
-
C) CRS_CODE and CLASS_SECTION
-
D) There is no primary key
Frage 9
Frage
9. A ____ attribute can be further subdivided to yield additional attributes.
Antworten
-
A) composite
-
B) simple
-
C) single-valued
-
D) multivalued
Frage 10
Frage
10. A ____ attribute is one that cannot be subdivided.
Antworten
-
A) composite
-
B) simple
-
C) single-valued
-
D) multivalued
Frage 11
Frage
11. A ____ attribute can have only one value.
Antworten
-
A) composite
-
B) simple
-
C) single-valued
-
D) multivalued
Frage 12
Frage
12. ____ attributes can have many values.
Antworten
-
A) composite
-
B) simple
-
C) single-valued
-
D) multivalued
Frage 13
Frage
13. Some attributes are classified as ____.
Antworten
-
A) simple
-
B) complex
-
C) defined
-
D) grouped
Frage 14
Frage
14. The ____ type of attribute cannot be created in a DBMS.
Antworten
-
A) derived
-
B) multivalued
-
C) simple
-
D) composite
Frage 15
Frage
15. A ____ should be a derived attribute.
Antworten
-
A) person's name
-
B) person's age
-
C) person's social security number
-
D) person's phone number
Frage 16
Frage
16. A derived attribute ____.
Antworten
-
A) must be stored physically within the database
-
B) need not be physically stored within the database
-
C) has many values
-
D) must be based on the value of three or more attributes
Frage 17
Frage
17. A derived attribute is indicated in the Chen model by a ____.
Antworten
-
A) single line
-
B) dashed line
-
C) circle
-
D) double line
Frage 18
Frage
18. A relationship is an association between ____.
Antworten
-
A) objects
-
B) entities
-
C) databases
-
D) fields
Frage 19
Frage
19. Knowing the ____ number of entity occurrences is very helpful at the application software level.
Antworten
-
A) maximum
-
B) minimum
-
C) approximate
-
D) maximum and minimum
Frage 20
Frage
20. In the ERD, cardinality is indicated using the ____ notation.
Antworten
-
A) (max,min)
-
B) (min, max)
-
C) [min ... max]
-
D) {min\max}
Frage 21
Frage
21. Another word for existence-independent is ____.
Antworten
-
A) weak
-
B) alone
-
C) unary
-
D) strong
Frage 22
Frage
22. An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.
Antworten
-
A) existence
-
B) relationship
-
C) business
-
D) weak
Frage 23
Frage
23. If an entity can exist apart from one or more related entities, it is said to be ____-independent.
Antworten
-
A) existence
-
B) relationship
-
C) business
-
D) weak
Frage 24
Frage
24. When the PK of one entity does not contain the PK of a related entity, the relationship is ____.
Antworten
-
A) missing
-
B) weak
-
C) strong
-
D) Neutral
Frage 25
Frage
25. A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Antworten
-
A) strong
-
B) weak
-
C) business
-
D) relationship
Frage 26
Frage
26. The term “____”is used to label any condition in which one or more optional relationships exist.
Antworten
-
A) participation
-
B) optionality
-
C) cardinality
-
D connectivity
Frage 27
Frage
27. The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity
Antworten
-
A) mandatory
-
B) optional
-
C) multivalued
-
D) single-valued
Frage 28
Frage
28. The Crow’s foot symbol with two parallel lines indicates ____ cardinality.
Antworten
-
A) (0,N)
-
B) (1,N)
-
C) (1,1)
-
D) (0,1)
Frage 29
Frage
29. A ____ relationship exists when an association is maintained within a single entity.
Antworten
-
A) unary
-
B) ternary
-
C) binary
-
D) weak
Frage 30
Frage
30. A ____ relationship exists when two entities are associated.
Antworten
-
A) unary
-
B) binary
-
C) ternary
-
D) weak
Frage 31
Frage
31. A ____ relationship exists when three entities are associated.
Antworten
-
A) unary
-
B) binary
-
C) ternary
-
D) weak
Frage 32
Frage
32. ____ relationships are most common.
Antworten
-
A) unary
-
B) binary
-
C) ternary
-
D) higher-degree
Frage 33
Frage
33. If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.
Antworten
-
A) self
-
B) self-referring
-
C) looping
-
D) recursive
Frage 34
Frage
34. A(n) ____ entity is composed of the primary keys of each of the entities to be connected.
Antworten
-
A) associative
-
B) recursive
-
C) unary
-
D) binary
Frage 35
Frage
35. The associative entity is also known as a ____ entity.
Antworten
-
A) unary
-
B) weak
-
C) strong
-
D) composite
Frage 36
Frage
36. The following step occurs first in the process of building an ERD: ____.
Antworten
-
A) Develop the initial ERD
-
B) Create a detailed narrative of the organization's description of operations
-
C) Identify the attributes and primary keys that adequately describe the entities.
-
D) Identify the business rules based on the description of operations.
Frage 37
Frage
37. If Tiny College had some departments that were classified as “research only,” they would not offer courses; therefore, the COURSE entity would be ____ to the DEPARTMENT entity
Antworten
-
A) existence-dependent
-
B) independent
-
C) weak
-
D) optional
Frage 38
Frage
38. The M:N relationship between STUDENT and CLASS must be divided into two 1:M relationships through the use of the ENROLL entity; the ENROLL entity is ____.
Antworten
-
A) weak
-
B) strong
-
C) optional
-
D) mandatory
Frage 39
Frage
39. If the focus is on data-retrieval speed, you might also be forced to include ____ attributes in the design, which would not ordinarily be done.
Antworten
-
A) multivalued
-
B) composite
-
C) weak
-
D) derived
Frage 40
Frage
40. Complex ____ requirements may dictate data transformations, and they may
expand the number of entities and attributes within the design.
Antworten
-
A) information
-
B) entity
-
C) design
-
D) processing
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.