MIS 370 - Testbank 123
relationship
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
d
NoSQL databases: a. are geared toward transaction consistency; not performance. b. support only small amounts of sparse data. c. are based on the relational model. d. provide fault tolerance. (choose letter)
name node
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
entity
A noun in a business rule translates to a(n) in the data model. a. entity b. attribute c. relationship d. constraint
constraint
A(n) is a restriction placed on the data. a. attribute b. entity c. relationship d. constraint
business rules
From a database point of view, the collection of data becomes meaningful only when it reflects properly defined_____. a. business rules b. business norms c. business goals d. business plans
relational data model
MySQL is an example of the . a. hierarchical model b. file system data model c. relational data model d. XML data model
hierarchical
One of the limitations of the model is that there is a lack of standards. a. hierarchical b. network c. relational d. entity relationship
many-to-many
Students and classes have a relationship. a. one-to-one b. one-to-many c. many-to-one d. many-to-many
file system data model
VMS/VSAM is an example of the . a. hierarchical model b. file system data model c. relational data model d. XML data model
c
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. (choose letter)
Constraints
are important because they help to ensure data integrity. a. Attributes b. Entities c. Relationships d. Constraints
constraints
are normally expressed in the form of rules. a. Attributes b. Entities c. Relationships d. Constraints
hierachical
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
hierarchical
In the model, the basic logical structure is represented as an upside-down tree. a. hierarchical b. network c. relational d. entity relationship
network
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
1960s
The hierarchical data model was developed in the . a. 1960s b. 1970s c. 1980s d. 1990s
client node
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
model
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
data definition language (DDL)
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
entity
A(n) is anything about which data are to be collected and stored. a. attribute b. entity c. relationship d. constraint
relationship
A(n) is bidirectional. a. attribute b. entity c. relationship d. constraint
attribute
A(n) is the equivalent of a field in a file system. a. attribute b. entity c. relationship d. constraint
entity
A(n) represents a particular type of object in the real world. a. attribute b. entity c. relationship d. node
schema
An internal refers to a specific representation of an internal model, using the database constructs supported by the chosen database. a. tuple b. schema c. object d. value
XML/Hybrid data model
Oracle 11g is an example of the . a. hierarchical model b. file system data model c. relational data model d. XML/Hybrid data model
object-oriented
The data model is said to be a semantic data model. a. relational b. network c. object-oriented d. entity relationship
object-oriented
The data model uses the concept of inheritance. a. relational b. network c. object-oriented d. entity relationship
external
The model is the end users' view of the data environment. a. abstract b. external c. conceptual d. internal
entity relationship
The model uses the term connectivity to label the relationship types. a. relational b. network c. object-oriented d. entity relationship
entity relationship
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
1980s
The object-oriented data model was developed in the . a. 1960s b. 1970s c. 1980s d. 1990s
1970s
The relational data model was developed in the . a. 1960s b. 1970s c. 1980s d. 1990s
d
Which of the following is a disadvantage of the hierarchical data model? a. It does not promote data sharing. b. It is not efficient with 1:M relationships. c. It does not promote data integrity. d. It does not have standards. (choose letter)
b
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 d. They do not support very large amounts of than performance. sparse data. (choose letter)
