CIS 3365 Chapter 2
10. A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user. a. True b. False
False
11. In an SQL-based relational database, each table is dependent on every other table. a. True b. False
False
15. In Chen notation, entities and relationships have to be oriented horizontally; not vertically. a. True b. False
False
18. The external model is the representation of the database as "seen" by the DBMS. a. True b. False
False
19. The hierarchical model is software-independent. a. True b. False
False
2. An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data. a. True b. False
False
20. The relational model is hardware-dependent and software-independent. a. True b. False
False
5. Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user. a. True b. False
False
7. Database designers determine the data and information that yield the required understanding of the entire business. a. True b. False
False
8. Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. a. True b. False
False
12. In an SQL-based relational database, rows in different tables are related based on common values in common attributes. a. True b. False
True
13. Each row in the relational table is known as an entity instance or entity occurrence in the ER model. a. True b. False
True
35. The hierarchical data model was developed in the _____. a. 1960s b. 1970s c. 1980s d. 1990s
a
36. 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. a. hierarchical b. network c. object-oriented d. entity relationship
b
1. A data model is usually graphical. a. True b. False
True
22. A(n) _____ is anything about which data are to be collected and stored. a. attribute b. entity c. relationship d. constraint
b
14. M:N relationships are not appropriate in a relational model. a. True b. False
True
16. Today, most relational database products can be classified as object/relational. a. True b. False
True
17. The network model has structural level dependence. a. True b. False
True
3. An implementation-ready data model should contain a description of the data structure that will store the end-user data. a. True b. False
True
4. Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain. a. True b. False
True
6. In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. a. True b. False
True
9. Business rules must be rendered in writing. a. True b. False
True
24. A(n) _____ is the equivalent of a field in a file system. a. attribute b. entity c. relationship d. constraint
a
31. A noun in a business rule translates to a(n) _____ in the data model. a. entity b. attribute c. relationship d. constraint
a
33. In the _____ model, the basic logical structure is represented as an upside-down tree. a. hierarchical b. network c. relational d. entity relationship
a
34. In the _____ model, each parent can have many children, but each child has only one parent. a. hierarchical b. network c. relational d. entity relationship
a
23. A(n) _____ represents a particular type of object in the real world. a. attribute b. entity c. relationship d. node
b
38. VMS/VSAM is an example of the _____. a. hierarchical model b. file system data model c. relational data model d. XML data model
b
41. A(n) _____ enables a database administrator to describe schema components. a. extensible markup language (XML) b. data definition language (DDL) c. unified modeling language (UML) d. query language
b
42. The relational data model was developed in the _____. a. 1960s b. 1970s c. 1980s d. 1990s
b
44. A(n) _______ enables a database administrator to describe schema components. a. extensible markup language (XML) b. data definition language (DDL) c. unified modeling language (UML) d. query language
b
49. Which of the following is true of NoSQL databases? a. They do not support distributed database architectures. b. They are not based on the relational model. c. They are geared toward transaction consistency rather than performance. d. They do not support very large amounts of sparse data.
b
50. Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS? a. Data node b. Client node c. Name node d. Map node
b
21. A(n) _____'s main function is to help one understand the complexities of the real-world environment. a. node b. entity c. model d. database
c
25. A(n) _____ is bidirectional. a. attribute b. entity c. relationship d. constraint
c
30. Which of the following is true of business rules? 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.
c
32. A verb associating two nouns in a business rule translates to a(n) _____ in the data model. a. entity b. attribute c. relationship d. constraint
c
37. The object-oriented data model was developed in the _____. a. 1960s b. 1970s c. 1980s d. 1990s
c
40. MySQL is an example of the _____. a. hierarchical model b. file system data model c. relational data model d. XML data model
c
46. The _____ data model is said to be a semantic data model. a. relational b. network c. object-oriented d. entity relationship
c
47. The _____ data model uses the concept of inheritance. a. relational b. network c. object-oriented d. entity relationship
c
48. Which of the following types of HDFS nodes stores all the metadata about a file system? a. Data node b. Client node c. Name node d. Map node
c
26. A(n) _____ is a restriction placed on the data. a. attribute b. entity c. relationship d. constraint
d
27. _____ are important because they help to ensure data integrity. a. Attributes b. Entities c. Relationships d. Constraints
d
28. _____ are normally expressed in the form of rules. a. Attributes b. Entities c. Relationships d. Constraints
d
29. Students and classes have a _____ relationship. a. one-to-one b. one-to-many c. many-to-one d. many-to-many
d
39. Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models. a. hierarchical b. file system c. relational d. XML Hybrid
d
43. The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. a. hierarchical b. network c. object-oriented d. entity relationship
d
45. The _____ model uses the term connectivity to label the relationship types. a. relational b. network c. object-oriented d. entity relationship
d
