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