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