CIS 3050 Chapter 2

What is the difference between an object and a class in the object oriented data model (OODM)? a. An object is an instance of a specific class b. A class is not used in OO technology c. An object is real but a class is not d. An object is equivalent to a class

a. An object is an instance of a specific class

________ independence exists when you can change the internal model without affecting the conceptual model. a. Logical b. Conceptual c. Physical d. External

a. Logical

Which of the following is NOT a characteristic of the NoSQL generation of databases that addresses the specific challenges of the Big Data era? a. They are geared toward transaction consistency and not performance b. They support distributed database architectures c. They provide high scalability, high availability, and fault tolerance d. They are not based on the relational model and SQL

a. They are geared toward transaction consistency and not performance

A data ________ is a relatively simple representation, usually graphical, of a more complex real world object event. a. model b. warehouse c. record d. field

a. model

As a general rule, a _______ in a business rule will translate into a(n) ______ in the model, and a(n) _____associating nouns will translate into a(n) ________ among the entities. a. noun, entity, verb, relationship b. verb, entity, noun, relationship c. verb, relationship, noun, entity d. noun, relationship, verb, entity

a. noun, entity, verb, relationship

Which of the following is an example of a many-to-many type of relationship? a. An academic department is chaired by one professor; a professor may chair only one academic department. b. An employee may have earned many degrees; a degree may have been earned by many employees. c. A customer may generate many invoices; each invoice is generated by one customer. d. All of these choices are correct.

b. An employee may have earned many degrees; a degree may have been earned by many employees.

A ____________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization's environment. a. database rule b. business rule c. database manager d. business program

b. business rule

In the relational database environment, designers and users perceive a(n) _______ to be a two-dimensional structure consisting of a series of row/column intersections. a. diamond b. table c. box d. line

b. table

Why is an object said to have greater semantic content than an entity? a. An object is larger than an entity b. An object is equivalent to an entity c. An object includes information about relationships between the facts within the object and information about its relationships with other objects d. An object is real but an entity is not

c. An object includes information about relationships between the facts within the object and information about its relationships with other objects

________________ is the relational term to describe the types of relationships (1:1, 1:M, M:N). a. Rules b. Procedures c. Connectivity d. Conventions

c. Connectivity

_______ data refers to cases in which the number of attributes are very large, but the number of actual data instances is low. a. Terse b. Minimal c. Sparse d. Loose

c. Sparse

The ER model is based on which of the following components? a. nouns, verbs, objects b. people, places, things c. entities, attributes, and relationships d. users, systems, processes

c. entities, attributes, and relationships

A(n) ________________ helps identify the database's main entities and their relationships using components that are graphically represented so that their role is more easily understood. a. entity instance b. user interface model c. entity relationship model (ERM) d. business rule

c. entity relationship model (ERM)

You have __________independence when you can change the physical model without affecting the internal model. a. external b. conceptual c. physical d. logical

c. physical

A _____________ is an association among (two or more) entities. a. line b. box c. relationship d. pointer

c. relationship

The basic characteristics of Big Data databases include which of the following: a. size, complexity, location b. simple, one-dimensional, static c. volume, velocity, variety d. structured, compact, small

c. volume, velocity, variety

Which of the following is NOT considered to be one of the most frequently used Big Data technologies? a. NoSQL b. Hadoop c. MapReduce d. BigEvent

d. BigEvent

A good data model is a communications device that helps ___________ discrepancies between the database design's components and the real world data environment. a. accumulate b. add to c. correlate d. eliminate or reduce

d. eliminate or reduce

Business rules help to create and _______ actions within that organization's environment. a. remove b. prevent c. outline d. enforce

d. enforce

A _____________________ is a visual representation of the relational database's entities, the attributes within those entities, and the relationships between those entities. a. graph b. table c. matrix map d. relational diagram

d. relational diagram