Frage 1
Frage
21. A(n) _________’s main function is to help one understand the complexities of the realworld environment.
Antworten
-
A. node
-
b. entity
-
c. model
-
d. database
Frage 2
Frage
22. A(n) ____________ represents a particular type of object in the real world.
Antworten
-
a. attribute
-
b. entity
-
c. relationship
-
d. node
Frage 3
Frage
23. A(n) __________ is anything about which data are to be collected and stored.
Antworten
-
a. attribute
-
b. entity
-
c. relationship
-
d. constraint
Frage 4
Frage
24. A(n) ___________ is the equivalent of a field in a file system.
Antworten
-
a. attribute
-
b. entity
-
c. relationship
-
d. constraint
Frage 5
Frage
25. A(n) _________ is bidirectional.
Antworten
-
a. attribute
-
b. entity
-
c. relationship
-
d. constraint
Frage 6
Frage
26. A(n) _________ is a restriction placed on the data.
Antworten
-
a. attribute
-
b. entity
-
c. relationship
-
d. constraint
Frage 7
Frage
27. ________ are important because they help to ensure data integrity.
Antworten
-
a. Attributes
-
b. Entities
-
c. Relationships
-
d. Constraints
Frage 8
Frage
28. ________ are normally expressed in the form of rules.
Antworten
-
a. Attribtues
-
b. Entities
-
c. Relationships
-
d. Constraints
Frage 9
Frage
29. Students and classes have a ____________ relationship.
Antworten
-
a. one-to-one
-
b. one-to-many
-
c. many-to-one
-
d. many-to-many
Frage 10
Frage
Business rules are derived from ____.
Antworten
-
a.a detailed description of an organization’s operations
-
b.standards and practices developed over the years
-
c.managers’ recommendations
-
d.governmental oversight organization standards
Frage 11
Frage
31. Which of the following is true of business rules?
Antworten
-
a. They allow the designer to set company policies with regard to data.
-
b. They allow the designer to develop business processes.
-
c. They can serve as a communication tool between the users and designers.
-
d. They provide a framework for the company’s self-actualization.
Frage 12
Frage
32. A noun in a business rule translates to a(n) __________ in the data model.
Antworten
-
a. entity
-
b. attribute
-
c. relationship
-
d. constraint
Frage 13
Frage
33. A verb associating two nouns in a business rule translates to a(n) __________ in the data model.
Antworten
-
a. entity
-
b. attribute
-
c. relationship
-
d. constraint
Frage 14
Frage
34. The hierarchical data model was developed in the __________.
Antworten
-
a. 1960s
-
b. 1970s
-
c. 1980s
-
d. 1990s
Frage 15
Frage
35. The object-oriented data model was developed in the ____________.
Antworten
-
a. 1960s
-
b. 1970s
-
c. 1980s
-
d. 1990s
Frage 16
Frage
36. VMS/VSAM is an example of the ___________.
Frage 17
Frage
37. Oracle 11g is an example of the ___________.
Frage 18
Frage
38. MySQL is an example of the ________.
Frage 19
Frage
39. In the ________ model, the basic logical structure is represented as an upside-down tree.
Antworten
-
a. hierarchical
-
b. network
-
c. relational
-
d. entity relationship
Frage 20
Frage
40. In the __________ model, each parent can have many children, but each child has only one parent.
Antworten
-
a. hierarchical
-
b. network
-
c. relational
-
d. entity relationship
Frage 21
Frage
41. The relational data model was developed in the _________.
Antworten
-
a. 1960s
-
b. 1970s
-
c. 1980s
-
d. 1990s
Frage 22
Frage
42. In the _______ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
Antworten
-
a. hierarchical
-
b. network
-
c. object-orientated
-
d. entity relationship
Frage 23
Frage
44. A(n) ________ enables a database administrator to describe schema components.
Antworten
-
a. extensible markup language (XML)
-
b. data definition language (DDL)
-
c. unified modeling language (UML)
-
d. query langauge
Frage 24
Frage
24.The ____ model was developed to allow designers to use a graphical tool to
examine structures rather than describing them with text.
Antworten
-
a. hierarchial
-
b. network
-
c. object-oriented
-
d. entity relationship
Frage 25
Frage
49. The ________ model uses the term connectivity to label the relationship types.
Antworten
-
a. relational
-
b. network
-
c. object-oriented
-
d. entity relationship
Frage 26
Frage
51. The _________ data model is said to be a semantic data model.
Antworten
-
a. relational
-
b. network
-
c. object-oriented
-
d. entity relationship
Frage 27
Frage
52. The ________ data model uses the concept of inheritance.
Antworten
-
a. relational
-
b. network
-
c. object-oriented
-
d. entity relationship
Frage 28
Frage
53. One of the limitations of the ________ model is that there is a lack of standards.
Antworten
-
a. hierarchical
-
b. network
-
c. relational
-
d. entity relationship
Frage 29
Frage
54. The ________ model is the end users’ view of the data environment.
Antworten
-
a. abstract
-
b. external
-
c. conceptual
-
d. internal
Frage 30
Frage
30.A(n) ____ model represents a global view of the database as viewed by the entire
organization.
Antworten
-
a. external
-
b. conceptual
-
c. internal
-
d. physical