CIS 3365 Chapter 2 Test Questions and Answers All Correct

CIS 3365 Chapter 2 Test Questions
and Answers All Correct

The _____ model uses the term connectivity to label the relationship types.
a. relational b. network
c. object-oriented d. entity relationship - Answer-d

The _____ data model is said to be a semantic data model.
a. relational b. network
c. object-oriented d. entity relationship - Answer-c

The _____ data model uses the concept of inheritance.
a. relational b. network
c. object-oriented d. entity relationship - Answer-c

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 - Answer-c

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 - Answer-False

Business rules must be rendered in writing.
a. True
b. False - Answer-True

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 - Answer-False

In an SQL-based relational database, each table is dependent on every other table.
a. True
b. False - Answer-False

In an SQL-based relational database, rows in different tables are related based on
common values in common attributes.

, a. True
b. False - Answer-True

Each row in the relational table is known as an entity instance or entity occurrence in
the ER model.
a. True
b. False - Answer-True

M:N relationships are not appropriate in a relational model.
a. True
b. False - Answer-True

In Chen notation, entities and relationships have to be oriented horizontally; not
vertically.
a. True
b. False - Answer-False

Today, most relational database products can be classified as object/relational.
a. True
b. False - Answer-True

The network model has structural level dependence.
a. True
b. False - Answer-True

A data model is usually graphical.
a. True
b. False - Answer-True

An implementation-ready data model needn't necessarily contain enforceable rules to
guarantee the integrity of the data.
a. True
b. False - Answer-False

An implementation-ready data model should contain a description of the data structure
that will store the end-user data.
a. True
b. False - Answer-True

Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain.
a. True
b. False - Answer-True

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.