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